web

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

News and Announcements icon

Power Platform CommunityForums Power Automate Update row in excel - ...

Power Automate

Answered

Update row in excel - blank out cell

(0) Share

Report

Report

Posted on by lardo5150 Microsoft Employee

I am using update a row in a table.

I want to blank out a cell, basically take whatever value is in there and make it an empty cell.

I tried using the dynamic null expression but it did not work.

What is the right way to blank a cell out.

Categories:

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

v-litu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @lardo5150,

You could following these steps to approach that, get tables then update a row by input the dynamic content of table name, then put item properties into the content:

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

Was this reply helpful? Yes No
Verified answer

Achavan 286 on at

Like (1)

Report
Copy link

Link copied!

Hi @lardo5150 ,

please try below -
1. Initialize variable type string -
2. Update that variable in Update excel step

Hope this helps !

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

Was this reply helpful? Yes No
kulerskim 12 on at

Like (4)

Report
Copy link

Link copied!
You can use a simple expression:
string('')

Was this reply helpful? Yes No
djarabelo 3 on at

Like (0)

Report
Copy link

Link copied!

Massive thanks, this helped me ...

Was this reply helpful? Yes No

Join the conversation