When using a simple Send Email Automation action, it is very easy to insert of "List of Records" and select which fields to show. I have this setup for an automation that is sending a confirmation email when a form is submitted, and I want them to receive a confirmation email with their form submission details integrated into the message.
Once those forms are submitted, various other actions are done to a status field to indicate the applications path through our processes. For those applications that are still pending an approval from an outside client, their status is "Still Pending".
I would like to create an automation that on a certain date/deadline resends the original message that is sent to the approver. I have built a second automation to trigger on that date, and "Find Records" that are "Still Pending". Once it creates that list, the action should "Repeat for each record" in the list, and send a custom email. I wanted to just duplicate the original message. This works all the way up to adding the original form field details, because there is no option to insert a "List of records" from the Use data from...Current Item from List of records.
What am I missing here? Any other way to achieve the end result? I often find that the logic for sending different messages to different clients, even though that's how the records are built is confusing in Airtable. It seems like the logic is built more for sending one person a list of records that match. I thought that was the point in the new Find records, and repeating group automation actions, but maybe this functionality just hasn't been fully built out yet.
Any help would be appreciated.