Skip to main content

Notifications

Power Automate - Building Flows
Answered

Generate Several CSV reports from SharePoint list

(0) ShareShare
ReportReport
Posted on by 1,085

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?

  • Verified answer
    rameshmukka Profile Picture
    rameshmukka 1,085 on at
    Re: Generate Several CSV reports from SharePoint list

    I ended up doing this finally. 

    RameshMukka_1-1610271761077.png

    RameshMukka_2-1610271800119.png

     

     

     

  • PrasadAthalye Profile Picture
    PrasadAthalye 4,795 on at
    Re: Generate Several CSV reports from SharePoint list

    Can you use filter array and filter SharePoint array output by supervisor name and then build CSV on that?

    Something like below?

    PrasadAthalye_1-1610134748340.png

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,343

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard