Replace excel empty cell

[brayanrm0097]

Hi,
I want to make a flow that replace automatically the empty cells with a 0. How can I read the value of cell for replace if it is empty?
Thanks

[ChristianAbata]

hi @brayanrm0097  you could try someting like this.

[brayanrm0097]

HI,

When run the program I get this :

I believe It's possible replace the empty cells if in the update row block I put a conditional like his

if(equals(<COLUMN VALUE>, ''), 0, <COLUMN VALUE>)

So, how can I get the value of the cell?

[ChristianAbata]

hi @brayanrm0097  please try this.

First I create an excel with two columns an ID and Tareas.

Then I flow I did this.

And everything was ok and my empty row was updated with 0 value.

Please let me know if this works for you

[v-bacao-msft]

Hi @brayanrm0097 ,

If you want to filter the record in which the specified column is empty, you could leave the right parameters blank in Condition directly.

Image reference:

Please take a try and feel free to let us know if you have any other questions.

Best Regards,

[brayanrm0097]

Hi, Thanks for answer,

I see this works for one column, but how can I do when I have to replace several empty columns?

[v-bacao-msft · Accepted solution]

Hi @brayanrm0097 ,

Please try to refer to the following method to update the empty row.

Please ensure that the key column is not empty and has a unique value.

Then you could use empty() function to check if the specified column is empty, if yes, update the value of this column to 0.

You could use a similar expression to update other empty columns.

Best Regards,