cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

Formatting multiple choice data output

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. 

Capture.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

 

Hi @ir_lnf ,

 

Please also try the following configuration:

83.PNG

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
Super User III
Super User III

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

https://powerusers.microsoft.com/t5/Using-Flows/MultiSelect-Form-Flow-to-Separate-Excel-Column/td-p/...

Next, you can convert the array into a more readable format by following steps from this thread

https://powerusers.microsoft.com/t5/Building-Flows/Loop-inside-mail-flow/m-p/698493/highlight/false#...

Hope this helps

Hope this helps

 



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Is the first step still an Initialize Variable action?

Community Support
Community Support

 

Hi @ir_lnf ,

 

Please also try the following configuration:

83.PNG

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

@v-bacao-msft 

Your suggestion is much more simple, efficient than mine. Thax for sharing!



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



This worked perfectly! Thank you!!

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (6,542)