Answered

Replace excel empty cell

(0) Share

Report

Posted on by 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

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report

hi @brayanrm0097 you could try someting like this.

Was this reply helpful? Yes No
brayanrm0097 23 on at

Like (0)

Report
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?

Was this reply helpful? Yes No
ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
v-bacao-msft on at

Like (0)

Report

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,

Was this reply helpful? Yes No
brayanrm0097 23 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

v-bacao-msft on at

Like (0)

Report

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,

Was this reply helpful? Yes No