I need to create a flow that for each creator of an item in a SP List copy its data into a HTML Table and create a Excel File (from a template stored in SP)
I already have all the list with all data
each list has a ID and Cretor Column to link it to the Main list
@Anonymous I think first you will need to get unique values of creator from the list. You can refer to this post to get unique values https://powerusers.microsoft.com/t5/Power-Automate-Community-Blog/Get-Unique-Values-from-SharePoint-List-group-by-the-items-and/ba-p/627783
Then you need to loop through each unique creator value using apply to each and within that loop filter the list data with each creator value and add that data to excel if thats you requirement
Share
Report
All responses (
Answers (
8,531
