Skip to main content

Notifications

Power Automate - General Discussion
Answered

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

(0) ShareShare
ReportReport
Posted on by

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!

  • Verified answer
    Re: Bypassing a data filled cell in "update a row" in power automate

    @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.

  • wskinnermctc Profile Picture
    wskinnermctc 6,512 on at
    Re: Bypassing a data filled cell in "update a row" in power automate

    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. 

  • wskinnermctc Profile Picture
    wskinnermctc 6,512 on at
    Re: Bypassing a data filled cell in "update a row" in power automate

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

  • Re: Bypassing a data filled cell in "update a row" in power automate

    "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

     

  • Re: Bypassing a data filled cell in "update a row" in power automate

    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.

  • Re: Bypassing a data filled cell in "update a row" in power automate

    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

  • Re: Bypassing a data filled cell in "update a row" in power automate

    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.

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,691

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 65,019

Leaderboard