cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Replace excel empty cell

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
1 ACCEPTED SOLUTION

Accepted Solutions

 

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.

98.PNG

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

6 REPLIES 6
Super User II
Super User II

hi @brayanrm0097  you could try someting like this.

update.PNG



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

HI,

When run the program I get this :

 

image.png

 

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?

hi @brayanrm0097  please try this.

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

dataexce.PNG

 

Then I flow I did this.

data1.PNGdata2.PNG

 

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

 

Please let me know if this works for you



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

 

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:

90.PNG

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

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi, Thanks for answer,

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

 

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.

98.PNG

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Microsoft Ignite

Microsoft Power Platform: 2021 Release Wave 1 Plan

Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (28,001)