Skip to main content

Notifications

Community site session details

Community site session details

Session Id : iH2spEUfpueNQx6iaS770w
Power Automate - Building Flows
Answered

Export share point list to excel and update

Like (0) ShareShare
ReportReport
Posted on 19 Dec 2023 12:42:56 by 5

Hi,

 

I have existing sp list that i want to export to excel sheet using power automate.
I want the list in excel will get updated automatically once new line is added or existing line is edited.  
i have created flow but it does not work.

i get error: "Unable to process template language expressions for action 'Condition_' at line '0' and column '0': 'The template language expression 'empty(outputs('Filter_array')['body/value'])' cannot be evaluated because property 'body/value' doesn't exist, available properties are 'body'. Please see https://aka.ms/logicexpressions for usage details.'."

 

Condition: 

empty(outputs('Filter_array')['body/value']) is equal 'TRUE' 
  • ScottShearer Profile Picture
    25,223 Most Valuable Professional on 19 Dec 2023 at 14:31:31
    Re: Export share point list to excel and update

    @hmoshe 

    Understood.  Are you using the file as a data source?  If the only use of the file is for people to open in Excel and the file will refresh that is a good thing.

    I mention this because Power Automate Flows frequently experience issues when trying to update Excel files.  These issues are usually related to a "file in use" error. 

    If you experience these errors, please consider just linking the Excel worksheet to SharePoint.

     

  • hmoshe Profile Picture
    5 on 19 Dec 2023 at 14:25:49
    Re: Export share point list to excel and update

    Thanks. i am familiar with this option, but i want to refresh automatically.  i do not not want to enter the file for refrash.

  • ScottShearer Profile Picture
    25,223 Most Valuable Professional on 19 Dec 2023 at 14:09:30
    Re: Export share point list to excel and update

    @hmoshe 

    I just wanted to suggest that you don't need a Flow - simple is good...

    You can link a SharePoint list to Excel and set the Excel file to refresh the data every time the file is opened.

    To get started, go to the SharePoint list and export to Excel.

     

     

  • ManishSolanki Profile Picture
    15,085 Super User 2025 Season 1 on 19 Dec 2023 at 12:52:18
    Re: Export share point list to excel and update

    Hi @hmoshe 

     

    Pls modify the condition to:

    empty(body('Filter_array')) is equal to true
     
    If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.
     
    Thanks
  • Verified answer
    v-yetonggu-msft Profile Picture
    on 19 Dec 2023 at 12:50:49
    Re: Export share point list to excel and update

    Hi @hmoshe ,

    Please try this  expression:

    empty(body('Filter_array'))

    Best Regards,

    Sunshine Gu

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

#1
stampcoin Profile Picture

stampcoin 51

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 39 Super User 2025 Season 1

#3
rzaneti Profile Picture

rzaneti 22 Super User 2025 Season 1

Overall leaderboard
Loading started