web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate getting error when flo...

Power Automate

Answered

getting error when flow is matching the row data from excel with empty cell

(0) Share

Report

Report

Posted on by dogbural

31

Hi,

I am now building scheduled flow.

I am wondering how i can filter out empty cell from excel as I am getting error when matching data based on my condition which matches based on date. However, some of cells are empty.

Is there something I can do in filter query in excel table? Say, my column is called 'Due date'.

Regards,

MK

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

tom_riha 10,187 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hello @dogbural ,

you can use 'Filter Query' in the 'List rows present in a table' action to skip all rows that don't have a value in a specific column. But the column name must be 1 word, without spaces, e.g. not 'Due date' but 'Duedate'.

ColumnName ne ''

Was this reply helpful? Yes No

Join the conversation