Export new list items to existing table in Excel file once daily

Like (0) Share

Report

Posted on 11 Jul 2022 11:21:32 by samclark6

Hi all - help needed.

Has anyone built a flow to export new list items to an existing table in an Excel file once daily and could share?

I have a SharePoint list:

And a table in an Excel file on the SharePoint site:

What I would like to do is export new items at 22:00 daily from the SharePoint list to the table (so each day the new items that day will be added to the end of the table).

I have the same question (0)

All responses (5)

Answers (0)

MarconettiMarco 3,812 Super User 2024 Season 1 on 11 Jul 2022 at 13:09:24

Like (0)

Report

Re: Export new list items to existing table in Excel file once daily

I think so too 😁

Was this reply helpful? Yes No
JonDoesFlow 1,304 on 11 Jul 2022 at 13:08:17

Like (0)

Report

Re: Export new list items to existing table in Excel file once daily

Hey @MarconettiMarco , I think we are both right here haha 🙂

Was this reply helpful? Yes No
JonDoesFlow 1,304 on 11 Jul 2022 at 12:45:08

Like (0)

Report

Re: Export new list items to existing table in Excel file once daily

I have written about this in a blog post here - https://www.jondoesflow.com/post/export-new-sharepoint-list-items-to-existing-table-in-excel-file

Was this reply helpful? Yes No
MarconettiMarco 3,812 Super User 2024 Season 1 on 11 Jul 2022 at 12:34:06

Like (1)

Report
Re: Export new list items to existing table in Excel file once daily

Hello @samclark6 ,
please follow these steps:
1. Trigger "Recurrence", interval 1 per Day at 22:00
2. Get Items (from SP list); in the filter query put this expression in order to get only the records created today:
addDays(utcnow('yyyy-MM-ddTHH:mm:ssZ'),-1)
3. Add the "Add a row into a table" action in order to create as many rows as your SP list created within the current data:

That's it.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
BR,
Marco

Was this reply helpful? Yes No
JonDoesFlow 1,304 on 11 Jul 2022 at 12:07:29

Like (1)

Report

Re: Export new list items to existing table in Excel file once daily

Hey @samclark6

Yes, this is possible. First, I would add a new column to your SharePoint list and call it "Processed", make it a Yes/No column.

Then in Power Automate create a scheduled cloud flow, to run at whatever frequency you like.

Next step, get the items from the SharePoint list, an in the Filter query section put in Processed eq 'false', like below

This will get you all of the items that haven't been added to the Excel spreadsheet.

Next step, Add a row to a table:

This step will be automatically added into an Apply to Each section, under this add a Update Item action, and set the Processed field to Yes:

The entire flow is below:

If I have helped you solving your issues, please can you thumbs up this reply and accept it as a solution.

Thanks !

Was this reply helpful? Yes No