Sending emails from contact lists in a custom table

[Laurent1A]

Hello,

I'm trying to build an app that will send emails to recipients listed in a custom table.

E.g. my custom table contains invoices (with all the details) as a record and I want to send those invoices to the email address associated to it, which is on the very same record/table.

When building my app, in the recipients section I can only add users or groups.

My idea was to build a user list from my custom table, but then every user will receive the invoices!

Obviously I need to send:

Record 1 / Invoice 1 / email 1 to email 1

Record 2 / Invoice 2 / email 2 to email 2

etc.

Any suggestion on how I can do that in low-code?

Thanks!

[Laurent1A · Accepted solution]

I've found the solution so I post it.

To do so you have to use the Flow Designer and not the Email module from "ADD LOGIC AND AUTOMATION"

In the flow designer the "To" field accepts as an input the email field from the record triggering the flow.