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.

All responses (2)

Answers (2)

Verified answer

v-jefferni on at

Like (0)

Report

Re: check if excel file is empty

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,
Verified answer

ManishSolanki 15,085 Super User 2025 Season 1 on at

Like (0)

Report
Re: check if excel file is empty

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.