Excel list rows where a cell in column is blank (filter blanks , not filter out blanks)

[MannOnion]

I am trying to build a flow that updates one excel sheet from another. It works but because of the number of rows in the table, it times out. 

I have set the flow to run out of hours but only need it to update the rows where certain columns are blank. These columns are never manually updated so if the row has a blank cell in one of the columns then it needs to be updated by this flow. 

I have found plenty of examples of how to filter out blanks but cannot work out how to only return rows where a column is blank.

[Hardesh15 · Accepted solution]

@MannOnion  Pls use one compose and pass that column value inside apply to each. Now you have that column value for each row in compose. Apply condition action and check if compose is blank or not if it is blank then use Get Row & Update Row action.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

[MannOnion]

It worked, thank you.