Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

Turn multiple choice [Array] from Sharepoint List to HTML template

(0) ShareShare
ReportReport
Posted on by 41

Good Day,
So I've been stuck with this since yesterday and I don't know where to put the function 'turn from array to string'. This is my template, and I use List data to fill the blank in the template:

Capture.PNG

this is my List which I have trouble with the multiple choice(s)

Capture 2.PNG

with my existing flow that I've created without turn the array first, the template become like this:

Ezzyy798_1-1684200155762.png

(I just copy my template word's html and then paste it inside Compose data operation flow)

Capture x.PNG

The result is an error on a variable of type array. So I've tried several ways that I found on google but still can't solve it. This is the flow I'm trying to create

Capture 3.PNG

Capture 4.PNG

The thing is I don't know where to put the variable since I got several types of array and how can I entered it inside my template's html like this:

Capture 33.PNG

I'd be glad and thankful if anyone can help me. Thanks in advance

  • Ezzyy798 Profile Picture
    41 on at
    Re: Turn multiple choice [Array] from Sharepoint List to HTML template

    Hi @Nived_Nambiar 

     

    It works! Thank you, your help is greatly appreciated. 

  • Nived_Nambiar Profile Picture
    17,906 Super User 2025 Season 1 on at
    Re: Turn multiple choice [Array] from Sharepoint List to HTML template

    Hi @Ezzyy798 

     

    I think it is not multi choice column, for that there would be dynamic content named (hope so) as Quality Plan Value 

    which contains the value of Quality Plan choice value selected for that item, you can directly insert it in template without any join operations 🙂

     

     

  • Ezzyy798 Profile Picture
    41 on at
    Re: Turn multiple choice [Array] from Sharepoint List to HTML template

    Hi @Nived_Nambiar 
    Thanks for the solutions, it works at most of the variables but I still have a problem with several parts of it.

     

    This is the error that I got, it says error because the data type is an Object

    Ezzyy798_0-1684484479631.png

     

    And this is the values on my list for that specific column error

    Ezzyy798_1-1684484628791.png

    Do you happen to know why there's still some error in it? All the error only affect the list that has only 2 values on its column, though I don't think all the column were Boolean type.

     

    Thanks in advance

     

  • Verified answer
    Nived_Nambiar Profile Picture
    17,906 Super User 2025 Season 1 on at
    Re: Turn multiple choice [Array] from Sharepoint List to HTML template

    Hi @Ezzyy798 

     

    I think there is some mistake while specifying the dynamic content. 

     

    see below 

     

    Nived_Nambiar_0-1684347950573.png

     

    For apply to each , select To be Inspected, for appending purposes, select To Be Inspected value. 

     

    and outside the loop, join it 

     

    Nived_Nambiar_1-1684348015921.png

     

     

    This is To be Inspected column in my case

     

    Nived_Nambiar_2-1684348053940.png

     

     

    Alternatively, another way to try same is like below using select action.

    Nived_Nambiar_3-1684348125589.png

     

    Nived_Nambiar_4-1684348142912.png

     

     

    Result of this flow would be like this 

    Nived_Nambiar_5-1684348178686.png

     

     

    Hope this helps !

     

    Mark it as solution if it resolves your query !

     

     

     

  • Ezzyy798 Profile Picture
    41 on at
    Re: Turn multiple choice [Array] from Sharepoint List to HTML template

    Hi @Nived_Nambiar 

     

    This is how I append the values, and it still didn't work well

    Ezzyy798_0-1684291944741.png

     

  • Nived_Nambiar Profile Picture
    17,906 Super User 2025 Season 1 on at
    Re: Turn multiple choice [Array] from Sharepoint List to HTML template

    Hi @Ezzyy798 

     

    I hope you are appending values as shown in below screenshot ?

     

    could u open the apply to each how you are appending the values ?

     

    Nived_Nambiar_0-1684290969610.png

     

     

     

  • Ezzyy798 Profile Picture
    41 on at
    Re: Turn multiple choice [Array] from Sharepoint List to HTML template

    Hi @Nived_Nambiar 

     

    Only these fields are multiple choice. The rest of the docs has string data type for the values

    Ezzyy798_0-1684290076189.png

    Thanks

  • Nived_Nambiar Profile Picture
    17,906 Super User 2025 Season 1 on at
    Re: Turn multiple choice [Array] from Sharepoint List to HTML template

    Hi @Ezzyy798 

     

    Just to confirm, are all values you are entering of type multi choice columns ?

     

  • Ezzyy798 Profile Picture
    41 on at
    Re: Turn multiple choice [Array] from Sharepoint List to HTML template

    Hi @Nived_Nambiar ,
    I would like the values that has multiple choice to be separated by semicolon like this

    Ezzyy798_0-1684283537152.png

    Thanks 

  • Nived_Nambiar Profile Picture
    17,906 Super User 2025 Season 1 on at
    Re: Turn multiple choice [Array] from Sharepoint List to HTML template

    Hi @Ezzyy798 

     

    Sorry for late response, 

     

    May i know how you need to enter the multi choice values, is the values should be seperated by some delimiter like comma while entering details in template ?

     

    Kindly let me know 🙂

     

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

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!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1