Deleting Blank Rows from Excel with a Flow

[chrisb2019]

Hi - does anyone have a condition to help make a flow delete blanks rows from a table in excel? I get an excel sheet regularly with a varying amount of items in the table and when I have them added to a sharepoint list with blank rows, there will be blank entries that come through to the sharepoint list. 

I have seen the advanced mode code for this solution but I could use help finding a way to use the basic method for conditions. 

Thanks

[v-bacao-msft · Accepted solution]

Hi @chrisb2019 ,

You could use Condition directly to determine if the specified field is empty. If it is empty, Create item action is not executed.

Best Regards,

[chrisb2019]

Thanks @v-bacao-msft, This was exactly what I needed. I knew that I must have been overcomplicating the logic!

Thanks again!