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?
Accepted Solutions
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:
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:
