HELP! How do I convert an array into a one-column HTML Table?

(0) Share

Report

Posted on by Community Power Pla...

I have an array variable that stores contents as follows:

[

"A",

"B",

"C",

"D"

]

How do I convert this into a usable HTML table with a column header of "Item"? The result would look like the following:

Item

Categories:

Building flows

I have the same question (0)

All responses (14)

Answers (0)

ChristianAbata 8,951 Most Valuable Professional on at

Like (2)

Report

hi @Anonymous what you need to do that is convert the array in a valid format for example you need an array like this:

to get this result

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

How do I go about converting the array provided so that there are headers at the start? The array I listed is the result of an apply to each that loops over a SharePoint list, so I can’t figure out how to get the headers in place.

Was this reply helpful? Yes No
ChristianAbata 8,951 Most Valuable Professional on at

Like (1)

Report
@Anonymousyou need to convert you array output into string like this string('HERE YOUR OUTPUT') then you can format every part of your array if is static you can use the next expresions in a separeted compose actions.
To letter A

concat(replace(split(outputs('ToString'),'","')[0],'[','{"values": '),'"}')

Letter B

concat('{"values": "',split(outputs('ToString'),'","')[1],'"}')

To letter C

concat('{"values": "',split(outputs('ToString'),'","')[2],'"}')

To letter D

concat('{"values": "',replace(split(outputs('ToString'),'","')[3],']','}'))

Then just add all the composes into you table action following the example a give you.

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

Hi @Anonymous

If your array length is fixed you could do the following way.

Above the header expression is as follows:

variables('test')[0]

variables('test')[1]

variables('test')[2]

variables('test')[3]

Test Result:

Was this reply helpful? Yes No
v-litu-msft on at

Like (1)

Report
Hi @Anonymous,

Just like @ChristianAbata 's advice, before creating an HTML table, you should create convert the array convert into JSON, and I have a simple method could help you:

Put the array into an array variable.

Initialize an array variable named JSONArray.

Create Apply to each action, then Append to array variable to put the A, B, C, D into the JSON.

Create HTML table.

Run result:

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@v-litu-msft, this is definitely the solution. Any chance you have a recommendation for how I could then drop that into a Teams message using the Post Message as Flow bot to user action? I got a message, but it shows like this:

Value A B C

Is there any way to force this to show as rows in Teams?

Was this reply helpful? Yes No
v-litu-msft on at

Like (1)

Report

Hi @Anonymous,

Sure, you could use this action:

The message in the MS teams:

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@v-litu-msft That's what I thought. This is what I am now getting, however:

<table><thead><tr><th>Value</th></tr></thead><tbody><tr><td>A</td></tr><tr><td>B</td></tr><tr><td>C</td></tbody></table>

I wonder why?

My action step has the output of the HTML table that used the JSONArray we built.

Was this reply helpful? Yes No
v-litu-msft on at

Like (1)

Report

Hi @Anonymous ,

Sorry for late, <table><thead><tr><th>Value</th></tr></thead><tbody><tr><td>A</td></tr><tr><td>B</td></tr><tr><td>C</td></tbody></table> is the code of the HTML table? How do you get this format text? you could share screenshot of the run result.

And If your problem has been solved, You could go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

Best Regards,
Community Support Team _ Lin Tu

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@v-litu-msft The values I am pulling are being created from an "Apply to each" loop for a SharePoint list:

Then, I do the steps we discussed regarding appending to an array, converting to table, and posting in Teams:

This is the result in Teams:

Was this reply helpful? Yes No