Workflow- "To" to specific email

Hi!

Im working on an app that create report after a client visit.
Once the report is done, a workflow is supposed to send an email to the client for a review of the visit.

I am looking to find a way to write the email adress on the “TO”, i tried Report[Email] to take the email from my data sheet but is not working.

Please help me!

Thanks!

Solved Solved
0 19 781
1 ACCEPTED SOLUTION

@Plantenance_Landscap
As you can see from my previous post, the second part of the expression is a Y/N criteria to filter/drill down the selection set. Therefore, your SELECT statement can be like this for example:

SELECT(Client List[Email],[ColumnA]=[_THISROW].[ColumnA])

This expression will filter away all the [Email] column data, where [ColumnA] value is equal to the value in the current row when the workflow was triggered.

View solution in original post

19 REPLIES 19
Top Labels in this Space