SarahS.89561 (Customer) asked a question.
Look for all matching values in a table and then write data from all matching rows for use in email
I need to be able to loop through a table for a certain value, read all the returned rows and then write data from those rows to a single email
eg. column A contains a membership number, column B contains the managers first name column C contains a service they would like to support, Column D contains another service and so on
The flow should search Column A for their membership ID and return all matching rows, I then need to write the data to something for use in an email eg. Dear {first name}, thank you for you interest in support column C service and column D service
Can't seem to find a way to do integrate through the table and then write the data to the same place
Hello @SarahS.89561 (Customer) Thank you for reacting out to our Community!
You will need to use TABLE - SEARCH ROWS to find the ROW(S), then you will then need to use LIST - REDUCE to concatenate all of the data into a single text value to then use the output from the LIST - REDUCE into a TEXT - COMPOSE in the PARENT flow to then pass to an email.
The Okta Community Catalysts Program is now live. Collect online badges when you participate in the Okta Help Center Questions community. Learn more here.
Join us in the Oktane discussion group to connect with attendees or just stay connected to the event.
Apologies, I'm a bit confused, could you give me an example flow
Regards
*Sarah Spittle *
*Infrastructure Support Specialist Citizens Advice
<http://www.citizensadvice.org.uk/>*
Internal: 231347 External: 03000 231347 Mobile: 07471950092
We give people the knowledge and confidence they need to find their way
forward - whoever they are, and whatever their problem. For everyone, for
over 80 years.
@SarahS.89561 (Customer)
This ask is may not trivial depending on what you "end format" needs to look like. What you are describing can be handled by utilizing a "reduce" card.
The reduce card allows you to pass a row of results to be processed one at a time to a helper flow. You can the return the "Memo" back up to the parent flow. On the next iteration you would concatenate the new "Memo" with the previous "Memo" and keep repeating until you have built out your structure.
The following flow does not exactly meet your current use case. What it does is embed a table into an email. The "idea' will be similar and you should be able to workout how to meet your use cased based on how this functions.
To use:
The results should be an embedded table sent to your email. You can then review the flow to figure out how to accomplish the thing you are trying to accomplish.
Thanks,
-Tim
emailHtmlTable
You are an absolute star, could not have worked that one out myself but it works a treat, thank you
Regards
*Sarah Spittle *
*Infrastructure Support Specialist Citizens Advice
<http://www.citizensadvice.org.uk/>*
Internal: 231347 External: 03000 231347 Mobile: 07471950092
We give people the knowledge and confidence they need to find their way
forward - whoever they are, and whatever their problem. For everyone, for
over 80 years.