Unanswered

Generate excel file from SharePoint list

Like (0) Share

Report

Posted on 28 Jul 2020 13:32:09 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!

All responses (2)

Answers (0)

servicesGB95 48 on 29 Jul 2020 at 09:33:05

Like (0)

Report

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 7,087 Super User 2024 Season 1 on 28 Jul 2020 at 14:01:51

Like (0)

Report
Re: Generate excel file from SharePoint list

@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