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! Go to 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.
User | Count |
---|---|
41 | |
36 | |
28 | |
23 | |
16 |