JeremyJ.88632 (Customer) asked a question.
Workflows, Concat from For Each Helper
I have a workflow that runs a For Each on a table. In the helper flow, I want to grab certain information from the row and turn it into a text string, but I want to concat that text string back to the parent flow so I have one text object that contains all of information.
For example:
Table row has First Name, Last Name, Status
John Smith Active
Jane Doe Inactive
Creates a single text object that says:
John Smith is Active, Jane Doe is Inactive
Hi @JeremyJ.88632 (Customer),
Thank you for posting on the Okta community page!
I have done some research and you might be able to achieve this by following the bellow steps:
Additionally, please keep in mind that tables are only for temporary storage and they are not to be used as a database.
I hope the above information is helpful!
As Flaviu mentioned the List Reduce card is what you will need to leverage to meet this goal. The memo field as text/string does require a default value within the List Reduce. How I work-around this is to utilize some "unique" value could be a GUID etc and I just strip it out with replace after the List Reduce card is completed.
@Jeremy Jirik
I've put together a sample flow that should get you started. It demonstrates reduce usage with text/strings and some other text manipulation.
Next to a folder in Workflows click the "gear" icon and import. Will be 2 flows.
reducedemo