Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Answered

Update row in excel - blank out cell

(0) ShareShare
ReportReport
Posted on by 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.

  • djarabelo Profile Picture
    3 on at
    Re: Update row in excel - blank out cell
    Massive thanks, this helped me ...
  • kulerskim Profile Picture
    12 on at
    Re: Update row in excel - blank out cell

    You can use a simple expression: 

    string('')
  • Verified answer
    Achavan Profile Picture
    286 on at
    Re: Update row in excel - blank out cell

    Hi @lardo5150 ,

     

    please try below -

    1. Initialize variable type string -

    Achavan_0-1619430541147.png

    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.

  • v-litu-msft Profile Picture
    on at
    Re: Update row in excel - blank out cell

    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:Screenshot 2021-04-26 155114.jpg

     

    Screenshot 2021-04-26 155126.jpg

     

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,651 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,997 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow