Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Export SharePoint list to Excel .xlsx format and save to SharePoint on a daily basis

Posted on 20 Nov 2024 16:45:01 by 216
***BUMP***
 
Hi all,

I have been trying to build this flow for weeks now, and I'm losing my mind. I have followed every single YouTube video and article I can find, but nothing is working.

All I am trying to do is set up a daily backup of a SharePoint list to an Excel .xlsx file and save to SharePoint. I have successfully set this up to save as a .csv file, but I cannot seem to get it to work for an .xlsx file. It is maddening!

Can someone please help me? Specific steps/instructions would be greatly appreciated. I have managed to get one to work up until adding the rows into the table - it gives me an overlap table error, but I don't know why? I have attached a screenshot of the working .csv flow.

Thank you!
  • axray Profile Picture
    axray 216 on 26 Nov 2024 at 14:36:02
    Export SharePoint list to Excel .xlsx format and save to SharePoint on a daily basis
    @Nived_Nambiar - yes, I have tried setting the flow up by using the existing document's blank table and with not using it at all - I get (different) errors either way... either duplicate table error or I can't even open the .xlsx file after it is created.
  • Nived_Nambiar Profile Picture
    Nived_Nambiar 16,505 on 26 Nov 2024 at 01:57:46
    Export SharePoint list to Excel .xlsx format and save to SharePoint on a daily basis
    Hi @axray
     
    Sorry, actually there were some issues with the Power platform forum by which i wasn't able to post answer for this.
     
    I have checked and it seems like based on error - i could see that it happens due to already table present in excel before creating a new table - is it right ?
     
    I assume while creating the excel file - you have used the content from following compose action in the content field of create file 
     
     
    and this contains base64 format of excel file with empty table - correct ?
     
    Thanks & Regards,
    Nived N
  • axray Profile Picture
    axray 216 on 25 Nov 2024 at 16:09:37
    Export SharePoint list to Excel .xlsx format and save to SharePoint on a daily basis
    Can anyone please help?
  • axray Profile Picture
    axray 216 on 20 Nov 2024 at 18:05:24
    Export SharePoint list to Excel .xlsx format and save to SharePoint on a daily basis
    @Nived Nambiar - yes, a new .xlsx file each day (I have the naming convention set up with the formatted date) saved to a SharePoint site - these are the existing steps I have, but the last step after Create table never works (I've tried several variations - basically it would be to add rows, applied to each):

  • Nived_Nambiar Profile Picture
    Nived_Nambiar 16,505 on 20 Nov 2024 at 17:45:39
    Export SharePoint list to Excel .xlsx format and save to SharePoint on a daily basis
    Hi
     
    So you want to save the sharepoint list items that are created every day into an excel file - correct ?
     
     

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

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,129

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,797

Leaderboard