Answered

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

(0) Share

Report

Posted on by Community Power Pla... 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?

Thanks!

Categories:

General topics

I have the same question (0)

All responses (7)

Answers (1)

v-wenjuan-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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:

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
v-wenjuan-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
wskinnermctc 6,519 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
wskinnermctc 6,519 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

v-wenjuan-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

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.

Was this reply helpful? Yes No