Answered

check if excel file is empty

(0) Share

Report

Posted on by deerzzxdell

Hello community, I got a problem while creating a flow to check whether excel files which got imported in to sharepoint list are empty for not. My requirement is that 2 or more files could be import into SharePoint site at the same time. For the trigger,I use when a file is created (properties only)

And I got an error like this after trying to import an empty excel file,

I assume this means the flow can't find table name because it is empty.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (2)

Sort by

Verified answer

Manish Solanki 15,169 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @deerzzxdell

You could check the length of value object returned by "Get tables" action to know if table exists or not.

You need to write an expression to get the length of an object array:

length(outputs('Get_tables')?['body/value'])

If table exists, then you can add subsequent actions in the "Yes" block.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @deerzzxdell ,

According to the error, you are correct. In flow run history, you can check the output of Get tables action and see the result. To check in real run time if the excel is empty, you can use a condition control below the Get tables action:

Best regards,

Was this reply helpful? Yes No