I have a flow that is semi-working, however not finished as I'm completely stuck on this problem.
This flow selects all the data from a SharePoint list(id, name, comment). And then sends the email to me, in the following form.
[{"id":1.0,"Name":"test2","Comment":"test_comment"},
{"id":1.0,"Name":"test2","Comment":null},
{"id":2.0,"Name":"Alberto","Comment":null},
{"id":3.0,"Name":"john doe","Comment":null}]
Preferred Outcome:
----------------------
Ideally, I want to send an email where it is grouped by user ID and the Name as a table header, along with the all of that user's comments. Something like:
Name | test2 | Alberto | john doe |
Comment | some_comment
null | null | null |
I have been pondering for a couple of hours, but nothing yet has been fruitful. Any help, is more than appreciated.
Stay safe,
the_lost_panda
You can use Create HTML table to convert output to HTML and then use in the email.
For Grouping, follow below steps...
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
30 | |
30 | |
29 | |
22 | |
11 |