I am using Make.com (formerly Integromat) to automate sending emails for a licensing workflow. The main S123 table is a personal info table (name, employer, etc.) and information for individual licenses is stored in repeat tables. This allows multiple licenses and renewals for a license to all be associated with an individual and the applicant doesn't have to re-enter all of their personal info. When the status of a license application is updated (Approved/Denied/Incomplete/etc.), I want to send the applicant an email with which license (license type, new/renewal) had it's status updated and what the new status is.
In Make, I can see exactly which field values have been updated and the globalID and objectID of the repeat feature they were changed in. That allows me to setup filters on the exact items that have changed, but when I try to make the actual emails, I cannot access fields that weren't updated in a specific repeat table. Make always pulls data from fields in the first repeat feature. Is there a way to access only the edited repeat feature or a way to use the globalID or objectID to specify which feature to pull the fields from?
I did attempt to use "-1" in an array to try to grab the most recently created feature in the repeat table, but that only pulled a value (and threw an error in Make) and didn't specify which item in the array to access.
GIS Specialist - MO Office of Geospatial Information