web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : wTu0LQHIglhmf8fpNwj0Ud
Power Automate - Building Flows
Unanswered

sharepoint list export as excel table in 2018

Like (1) ShareShare
ReportReport
Posted on 6 Aug 2018 06:32:27 by 4

Dear all,

 

I try to accomplish the task to export a sharepoint list on a regularly basis (weekly) into an excel file. In sharepoint, you have the option in the menu "Connect & Export" to "Export to Excel" which works well. However, I didn't manage to build a flow which can do the same and save the file on my desktop (ideally) or my onedrive folder.

 

I managed to get the template/example "Copy SharePoint list items into a CSV each week" to run. However, the download looks terrible. It contains all the formatting, for example each cell looks like:

 

{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":1,"Value":"xxx"}

 

Can you help me with the flow to download a csv file without all the formatting/source information  or a flow which resembles the "export to excel" command?

 

Thank you for your help

Max

 

 

 

 

  • Community Power Platform Member Profile Picture
    on 07 Dec 2020 at 15:53:10
    Re: sharepoint list export as excel table in 2018

    how to create the Value string/array in get item or in Create a csv table......i did many times but unable to do it......please help me with it

     

  • vsolanon Profile Picture
    146 on 01 Nov 2019 at 01:39:55
    Re: sharepoint list export as excel table in 2018

    Hi @hammy24,

     

    Was wondering if you were able to find a solution for this. I am currently facing the same issue

     

    Thank you in advance!

     Veronica

  • Community Power Platform Member Profile Picture
    on 26 Jun 2019 at 20:50:49
    Re: sharepoint list export as excel table in 2018

    I am currently trying to do the same thing. Trying to schedule the flow to once a week to create an excel table from a shairpoint list and then send it out to a team. Is this possible? If so, how have you done it? Thanks!

    @jammy @v-yamao-msft 

  • jammy Profile Picture
    3 on 25 Sep 2018 at 23:42:00
    Re: sharepoint list export as excel table in 2018

    that works for me, very helpful.  I have been wondering how to get items from a SP list into excel and then send out to a team.  The flow worked in test and I hope it will in anger to.  The only thing I need to add is apply to each to write the multiple line of the SP list.

  • meggers Profile Picture
    4 on 07 Aug 2018 at 17:38:13
    Re: sharepoint list export as excel table in 2018

    Hi Mabel Mao,

    thank you very much for your suggestions!
    I tried it out, but the formatting is still the same as if I export all cells automatically. It works correctly if I use the manual export to excel option, but I guess the beauty of flow is supposed to make life easier and do it automatically.

    it shows in a cell:

    {"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":4,"Value":"XXX"}

    instead of just: XXX

    Any input appreciated.
    Thank you
    Max

  • v-yamao-msft Profile Picture
    on 07 Aug 2018 at 02:47:05
    Re: sharepoint list export as excel table in 2018

    Hi @meggers,

     

    Just try to customize the columns in the action Create CSV Table. Select Custom for Columns and Yes for Include headers, then specify values for corresponding header.

     

    Please check the following screenshot.

     

    I have made a test on my side and it works fine.

    1.PNG2.PNG 

     

     

    Best regards,

    Mabel Mao

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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading complete