I have a form with a multiple choice question where I can say which documents are missing from a file. The flow I'm setting up sends an email with that list of missing documents.
Currently, the list appears in the email like this: ["MLS","Listing Agreement","Purchase Agreement","DPOR","Summary of Rights"]
I'm trying to make it appear like this:
MLS
Listing Agreement
Purchase Agreement
DPOR
Summary of Rights
I managed to get the formatting I wanted, but only with the full list of options. I can't seem to get that formatting with only the selected options from that form response.
This is my current set up, which is not working at all and giving this error on the Join step: Unable to process template language expressions in action 'Join' inputs at line '1' and column '14442': 'Error setting value to 'From' on 'Microsoft.Azure.Workflows.Data.Operations.JoinActionInput'.'.
*Edit- This is my first time working in Power Automate so I may be missing something obvious.
Solved! Go to Solution.
Hi @ir_lnf ,
Please also try the following configuration:
Best Regards,
Hi!
So you can convert your multiple choice response into an array by means of the following WDL expression...
split(replace(replace(replace(YOUR_FORMS_RESPONSE,'["',''),'"]',''),'","',','),',')
...as explained in this thread
Next, you can convert the array into a more readable format by following steps from this thread
Hope this helps
Hope this helps
Proud to be a Flownaut!
Is the first step still an Initialize Variable action?
Hi @ir_lnf ,
Please also try the following configuration:
Best Regards,
Your suggestion is much more simple, efficient than mine. Thax for sharing!
Proud to be a Flownaut!
This worked perfectly! Thank you!!
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
42 | |
38 | |
37 | |
35 | |
25 |
User | Count |
---|---|
39 | |
36 | |
33 | |
31 | |
26 |