Power Automate does not update value to null value

(0) Share

Report

Posted on by Aleksandra1

253

Hello guys, I use an operation "Update a row into a table". update a row.png

For example I have column "Error", "Finding details":

null columns.png

So in these columns once I have information, and once no ( in case when these errors were solved). The problem is if I have information there (for example in column error: SOX) and after user update information to null values (delete this erorr, because it was solved), old information in these columns isn't deleted ( so I still have error SOX in cell).

I was trying to solve it with If() statement:

if(equals(items('Apply_to_each_row_where_status_==_"Passed"')?['Error'], null), null,items('Apply_to_each_row_where_status_==_"Passed"')?['Error'])

So if value in my column is null, then return null, else return value from this column.

But it doesnt help.

I have the same question (0)

All responses (12)

Answers (1)

SudeepGhatakNZ 14,381 Most Valuable Professional on at

Like (0)

Report

Re: Power Automate does not update value to null value

Since it is a string column check if the value is empty()
if(empty(items('Apply_to_each_row_where_status_==_"Passed"')?['Error']), items('Apply_to_each_row_where_status_==_"Passed"')?['Error']),'')

Please fix the opening and closing brackets (if I got the expression wrong)

Was this reply helpful? Yes No
Aleksandra1 253 on at

Like (0)

Report

Re: Power Automate does not update value to null value

I got a message that this expression is invalid.

Was this reply helpful? Yes No
Aleksandra1 253 on at

Like (0)

Report

Re: Power Automate does not update value to null value

I have edited your function: if(empty(items('Apply_to_each_row_where_status_==_"Passed"')?['Error']),'', items('Apply_to_each_row_where_status_==_"Passed"')?['Error']), but it still doesnt work 😞

Was this reply helpful? Yes No
SudeepGhatakNZ 14,381 Most Valuable Professional on at

Like (0)

Report

Re: Power Automate does not update value to null value

This is what the expression should be. Please update accordingly

if(empty(variables('MyVal')),'Empty','Not Empty')

Was this reply helpful? Yes No
SudeepGhatakNZ 14,381 Most Valuable Professional on at

Like (0)

Report

Re: Power Automate does not update value to null value

Can you put items('Apply_to_each_row_where_status_==_"Passed"')?['Error'] in a Compose action and check what you get? Is that returning a single item or array?

Was this reply helpful? Yes No
Aleksandra1 253 on at

Like (0)

Report

Re: Power Automate does not update value to null value

from json format you can see that is input i got null value (it is right)

Was this reply helpful? Yes No
SudeepGhatakNZ 14,381 Most Valuable Professional on at

Like (0)

Report

Re: Power Automate does not update value to null value

Are you able to use a Parse JSON action and pick the values for comparison from there?
I suspect probably the XPath expression is incorrect.

Was this reply helpful? Yes No
Aleksandra1 253 on at

Like (0)

Report

Re: Power Automate does not update value to null value

Can you please write me a way, how can I do it?

Was this reply helpful? Yes No
SudeepGhatakNZ 14,381 Most Valuable Professional on at

Like (0)

Report

Re: Power Automate does not update value to null value

What value does this return everytime in your case? if(equals(items('Apply_to_each_row_where_status_==_"Passed"')?['Error'], null), null,items('Apply_to_each_row_where_status_==_"Passed"')?['Error'])

Was this reply helpful? Yes No
Aleksandra1 253 on at

Like (0)

Report

Re: Power Automate does not update value to null value

just information which was in cell in excel for example error SOX, this statement doesn't update to null value

Was this reply helpful? Yes No