Unanswered

Generate excel file from SharePoint list

(0) Share

Report

Posted on by servicesGB95

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!

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@servicesGB95

Steps.

Create new excel file on your desktop.

Select number of columns which you require from SharePoint list and Format as table.

Upload this excel file into SharePoint Doc lib.

Create automated blank flow and use Flow trigger Recurrence : Select interval and frequency of recurrence.

Use Get items action

Use Add row into table action.

In this way you can export your list items in excel sheet.

if you are scheduling your flow like weekly, biweekly then do not forget to clean excel file.

To clean excel file- Use delete a row in Last

Thanks

Hardesh

Was this reply helpful? Yes No
servicesGB95 48 on at

Like (0)

Report
Copy link

Link copied!

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...

Was this reply helpful? Yes No