Condition - Testing if a CSV table is null or empty

[imadorkous]

Hello, I am having a hard time to trying to test if a CSV table is null or empty. Is there something that I am doing wrong?? 

This is how I have my flow set up:

This is the error that I am getting:

This is an example of a null/empty CSV table that I have

[v-litu-msft · Accepted solution]

Hi @imadorkous,

You could try following setting:

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[imadorkous]

YES! This worked, thank you!

[ryeradio]

I am having the same issue, but my csv file has just the header row. How can I do a conditional statement if there is nothing in the file, except for the header row?

[cgreenmzr]

Looking for same solution..... check CSV table output to see if any content besides the header row.

[ryeradio]

I created a conditions with this formula 

length(split(outputs('Get_file_content')?['body'],decodeUriComponent('%0A')))

and put is not equal to "2"

That worked for me. I hope that helps!

[KONeill102399]

I am new to power automate.  I am trying to user your formula you provided to check if there are 2 rows in a csv table.  But my cvs is a file not a table.  How do I adjust your formula?

[spartanboy]

@imadorkous: Can you provide all the steps from reading .csv to sending email. I have encountered similar needs

[KONeill102399]

Instead of reading the CSV file created a compose step after the query from power bi to check.  Then I added a condition step so that if the query resulted "0" the rest of the flow would not execute.  Then I put the rest of the flow in the condition step.