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.
