Answered

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

(0) Share

Report

Posted on by Ezzyy798

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:

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:

(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

Categories:

Building flows

I have the same question (0)

All responses (12)

Answers (1)

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Ezzyy798

May i know what is the error you are getting ?

and i think the values u are trying to enter are multi choice values from sharepoint ?

Was this reply helpful? Yes No
Ezzyy798 41 on at

Like (0)

Report

The error are all the variable with array type. This is what I get from the result:
Array data type return: [{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":2,"Value":"Wooden Create"}]

and Yes, I'm trying to enter value from multiple choice(s) into my template using HTML in power automate

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

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 🙂

Was this reply helpful? Yes No
Ezzyy798 41 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Ezzyy798

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

Was this reply helpful? Yes No
Ezzyy798 41 on at

Like (0)

Report

Hi @Nived_Nambiar

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

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

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 ?

Was this reply helpful? Yes No
Ezzyy798 41 on at

Like (0)

Report

Hi @Nived_Nambiar

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

Was this reply helpful? Yes No
Verified answer

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (1)

Report

Hi @Ezzyy798

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

see below

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

and outside the loop, join it

This is To be Inspected column in my case

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

Result of this flow would be like this

Hope this helps !

Mark it as solution if it resolves your query !

Was this reply helpful? Yes No
Ezzyy798 41 on at

Like (0)

Report

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

And this is the values on my list for that specific column error
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

Was this reply helpful? Yes No