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!
@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.
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.
If you do not put anything in the Update row field, does it basically delete anything that is already in the Excel field?
"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.
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.
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...
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.