Answered

Export share point list to excel and update

(0) Share

Report

Posted on by hmoshe

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'

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

v-yetonggu-msft Microsoft Employee on at

Like (3)

Report
Copy link

Link copied!
Hi @hmoshe ,
Please try this expression:
empty(body('Filter_array'))
Best Regards,
Sunshine Gu

Was this reply helpful? Yes No
Manish Solanki 15,167 Moderator on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
ScottShearer 25,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
hmoshe 5 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
ScottShearer 25,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No