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?
Solved! Go to Solution.
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:
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
70 | |
24 | |
18 | |
16 | |
13 |
User | Count |
---|---|
137 | |
44 | |
32 | |
32 | |
29 |