I need help to send emails with pre-filled forms to users in my base

[MyrnaEhrlich]

I have a membership base in which I want members to review and update their data with a Form.

I have a formula field which opens the form with  pre-filled records

I created an automation to find records in a view

And then used Send an email to send form to users to fill up

This send one email to 3 users for 3 pre filled forms

How can I send 3 emails, one for each member with corresponding pre-filled form?  Eventually, I would like to send about 200 emails.

Thank you,

Myrna

[kuovonne · Accepted solution]

Add a repeating group after your find records action. For the repeating group, use the list created by the find records action. Then in the email action, use the information from the current list item.

[MyrnaEhrlich · Accepted solution]

The repeating group is working just fine.  Thank you so much.  I have a new problem, the prefill is not working when it comes from email because the _ is missing.  I tried using Encode_URL_Component with '&prefill_' but it still drops the _.  Any ideas what to do?  Thanks again

[MyrnaEhrlich · Accepted solution]

solved the missing _ using %5F

[ScottWorld]

@MyrnaEhrlich You may also want use a tool like On2Air Forms which was specifically created for these purposes.