Hello everyone,
I try creating an html table to group different modified Items from a sharepoint list.
For this I have two sharepoint lists:
ExtraHoursGeneral with these columns:
ExtraHoursDetails with these columns (HID is the same ID number of ExtraHoursGeneral):
About my flow I use the model "Start an approval in teams when a SharePoint List is modified" .
I modified this flow like this:
In Apply to each 5:
I selected the ExtraHoursDetails list:
I have to use "get items", because I need details which are on this list to create my html table:
I use filter array to connect the both sharepoint lists :
Furthermore, I use select function to select different columns I need for HTML table:
And I have this HTML table:
I create an approval with an output which is the html table:
Finally, when I create a few items on my sharepoint list, I got these king of notification:
And I got the same notification per each item I created/modified.
My main goal with the html table is to group in one table each item I created at the same time.
My main issue is when different items are added or modified, I receive this kind of notification on teams :
and when I modified a second item, I receive a second one, too.
Then my questions are :
- How may we get a table instead getting the html code ?
- How may we get only one table which groups different modified items ?
- Finally, as you can see, my condition is inside "apply to each 5". My wish is to add a terminate function when the condition is no. However, we couldn't add one when we are inside a apply to function. Do you have an idea how to solve this issue ?
I'm sorry not to find solutions for these issues. I'm really a newbie on Power Automate.
Thanks for your help.
nks for your help ! It was that !
@Anonymous with approval actions, you cant use HTML, there is Markdown syntax that needs to be used to format the content of approvals, you can refer to this documentation https://docs.microsoft.com/en-us/power-automate/approvals-markdown-support#tables to get idea of how to create tables using Markdown.
WarrenBelz
146,524
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,906
Most Valuable Professional