Skip to main content
Community site session details

Community site session details

Session Id : Wx1W2LfdOtyB9MzRYaGO2b
Power Automate - Building Flows
Answered

Formatting multiple choice data output

Like (0) ShareShare
ReportReport
Posted on 28 Sep 2020 19:24:39 by

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

  • Community Power Platform Member Profile Picture
    on 02 Oct 2020 at 16:01:06
    Re: Formatting multiple choice data output

    This worked perfectly! Thank you!!

  • efialttes Profile Picture
    14,756 on 29 Sep 2020 at 06:54:39
    Re: Formatting multiple choice data output

    @v-bacao-msft 

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

  • Verified answer
    v-bacao-msft Profile Picture
    on 29 Sep 2020 at 05:41:56
    Re: Formatting multiple choice data output

     

    Hi @Anonymous ,

     

    Please also try the following configuration:

    83.PNG

     

    Best Regards,

  • Community Power Platform Member Profile Picture
    on 28 Sep 2020 at 20:19:20
    Re: Formatting multiple choice data output

    Is the first step still an Initialize Variable action?

  • efialttes Profile Picture
    14,756 on 28 Sep 2020 at 19:52:46
    Re: Formatting multiple choice data output

    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/367487

    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#M94707

    Hope this helps

    Hope this helps

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Loading complete