Converting array to html table - troubleshooting

[bug289]

I am trying to set up a flow that informs a set of people what the latest updates to a SharePoint document library are. It draws the items that were new in the last 7 days and provides certain data from the associated columns in a table which is input into an email and sent out every Monday.

Unfortunately, one of the columns is a multi-select choice column, which means the table contents are messy. I have therefore tried to build an array including only the choice items and removing all the ID etc. information that comes along with it. I have so far managed to create an array with the data I am looking for but am struggling to then convert that into an html table to go in the email.

I have Googled until I am blue in the face and tried some of the suggestions but I am still getting errors in the html table conversion, so looking for some help to troubleshoot it. I am a relative novice, my programming knowledge is based on past VBA experience so it explain it like I'm a beginner ;).

The flow steps look like this:

The output results at each stage look something like this:

The info to parse JSON etc I got from this link: https://powerusers.microsoft.com/t5/General-Power-Automate/Create-HTML-Table-from-Array-of-Strings/t...  As you can see, there is some issue with the 'split' formula that means I'm getting extra ': ' that I need to work through but the main issue is that it is still not seeing it as key value pairs and the error I get when creating the html table is:

I have tried creating the columns manually in the html table but that also didn't work.

Anyone have any thoughts or recommendations?

[Mira_Ghaly · Accepted solution]

@bug289 

I have replicated the same scenario at my side so i have a column called Title and a choice column Called ChoiceColumn , So please follow below steps to achieve what is required

1: Concatenate Expression

concat(variables('ChoiceString'),',',items('Apply_to_each_2')?['Value'])

2: Remove first , Expression

substring(variables('ChoiceString'),1,sub(length(variables('ChoiceString')),1))

Then you just pass your TableArray to create HTML

And here looks the output of the HTML Table looks like: