I have a SharePoint list with data submitted by employees during their field work. I have to develop a Power Automate Scheduled flow which would build and send the CSVs as Reports to their respective supervisors. I have the employee email in my list and i can get Supervisor email from Get Manager action. Using get items it would fetch all items. How do I build several arrays or reports within this flow for group of manager reportees and send them to respective supervisor? I am aware of Building arrays and creating them as CSVs. But in this case how do I separate records of a supervisor's reportees into separate array is the question. Can anybody help please?
I ended up doing this finally.
Can you use filter array and filter SharePoint array output by supervisor name and then build CSV on that?
Something like below?