Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Generate excel file from SharePoint list

(0) ShareShare
ReportReport
Posted on by 48

Halli, Hallo, Hallöle!

as you may know there is a function to export a list to excel in SharePoint.
In my flow I basically want to recreate this function on a scheduled date...
The problem I have is that there's no Excel-Action to create a new file or a table. I want that the flow automatically generates the  SharePoint-list items as Excel-file once in a month, it is important that .csv is not sufficient for me because I need the filter function in Excel-tables...
Any suggestions?

Thanks in advance!
 

  • servicesGB95 Profile Picture
    servicesGB95 48 on at
    Re: Generate excel file from SharePoint list

    Thanks for your reply!

    I did it as you said and the excel file gets updated with the data, but when I get the excel file with "get file content using path" to send it as E-mail, the file doesn't seem to be updated yet. It looks like the file still gets modified when I send it as E-Mail. 
    Working with timers doesn't seem to be a proper solution either...



  • Hardesh15 Profile Picture
    Hardesh15 7,087 on at
    Re: Generate excel file from SharePoint list

    @servicesGB95 

     

    Steps.

    1. Create new excel file on your desktop.
    2. Select number of columns which you require from SharePoint list and Format as table.
    3. Upload this excel file into SharePoint Doc lib.
    4. Create automated blank flow and use Flow trigger Recurrence : Select interval and frequency of recurrence.
    5. Use Get items action
    6. Use Add row into table action.
    7. In this way you can export your list items in excel sheet.
    8. if you are scheduling your flow like weekly, biweekly then do not forget to clean excel file.
    9. To clean excel file- Use delete a row in Last

    Thanks

    Hardesh

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,422

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,711

Leaderboard