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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Automatically extract ...
Power Automate
Answered

Automatically extract a List (MS LISTS) in Excel format and synchronize them

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Good morning all !

I come to you to ask for help please!

I am trying to find out if it is possible to make sure to automatically extract the data from a LISTS to an xlsx files (Excel)
If so, how do you do it?

Or, how do you make Synchronize a List (MS LISTS) with an Excel file?
The goal is to create a kind of team form under MS LISTS and to feed an Excel file each time this form is modified.

(I have the option to use Power Automate if there is a need)

 

Thank you in advance for your answers! 

Categories:
I have the same question (0)
  • Verified answer
    v-duann-msft Profile Picture
    Microsoft Employee on at

    Hi @Anonymous 

     

    Thank you for posting.

     

    According to your requirement, that’s absolutely possible using flow. Here are the configuration of flow :

     

    v-duann-msft_0-1611730080209.png

     

    v-duann-msft_1-1611730080212.png

     

     

    Please kindly refer related action and property above. When we complete and test the flow, once new response detected, the flow starts. Then the new result will be added to SPO list and sync to excel file with no issue.

     

    My form:

    v-duann-msft_2-1611730080216.png

     

     

    My list:

    v-duann-msft_3-1611730080217.png

     

     

    My excel:

    v-duann-msft_4-1611730080218.png

     

    Hope the information above may help you.

     

    Thanks

    Anna

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 791

#2
Valantis Profile Picture

Valantis 582

#3
Haque Profile Picture

Haque 529

Last 30 days Overall leaderboard