web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Bypassing a data fille...
Power Automate
Answered

Bypassing a data filled cell in "update a row" in power automate

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi all,

 

I am currently using update a row in power automate. I have multiple approvals run at the same time in the same flow, and if someone approves after the first person approves, the information of the first person gets deleted. My question is that when the flow runs and the data for the entry is empty, the cell is changed to nothing/empty. Is there an expression or something that I can write in there so the data doesn't change or at least all the cells that aren't important are ignored?

 

AustinB_0-1687877390391.png

 

 

Thanks!

Categories:
I have the same question (0)
  • v-wenjuan-msft Profile Picture
    Microsoft Employee on at

    Hi @Anonymous m

     

    Do you mean you want a function inserted into columns to update them to empty?

    If that's the case, just type in a blank space in the field and you will delete the original value there:

    vwenjuanmsft_0-1687942623679.png

     

    Community Support Team _ Wenjuan Zou

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

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Thanks for this but no...

    So I have a cell that is filled (shown below) and I want the "update a row" to ignore these...

     

    AustinB_0-1687954404510.png

  • v-wenjuan-msft Profile Picture
    Microsoft Employee on at

    So what's the standard of "ignoring"?

    I mean in which cases you don't want to update those cells? some cells with specific value? or the whole column you don't want to update them at all?

     

    Community Support Team _ Wenjuan Zou

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

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    "Ignore" as in don't want to update or change these cells. I don't want to update/change any of the cells that are highlighted and "ignore" them so the data that is already in them is unaffected.

     

    AustinB_1-1688054236633.png

     

  • wskinnermctc Profile Picture
    6,519 Moderator on at

    If you do not put anything in the Update row field, does it basically delete anything that is already in the Excel field?

  • wskinnermctc Profile Picture
    6,519 Moderator on at

    You will need to Get the Row before you Update the Row.

     

    Then put all of the Get the Row data into the Update the Row fields. (So the Update a Row is basically overwriting itself).

    Also put whatever approval info you have to add within the same field. So you will have 2 dynamic contents in those Update a Row fields that you want to add the approval info. 

  • Verified answer
    v-wenjuan-msft Profile Picture
    Microsoft Employee on at

    @Anonymous wrote:

    "Ignore" as in don't want to update or change these cells. I don't want to update/change any of the cells that are highlighted and "ignore" them so the data that is already in them is unaffected.

     

    AustinB_1-1688054236633.png

     


    Then you just leave them alone. Not even type in a blank space.

    If you don't insert anything in these field, the action won't change your original values.

     

    Community Support Team _ Wenjuan Zou

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

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 304

#2
David_MA Profile Picture

David_MA 245 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 243 Most Valuable Professional

Last 30 days Overall leaderboard