Power Automate does not update value to null value

(0) Share

Report

Posted on by Aleksandra1

254

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.

Categories:

Building flows

I have the same question (0)

All responses (12)

Answers (1)

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report

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 254 on at

Like (0)

Report

I got a message that this expression is invalid.

Was this reply helpful? Yes No
Aleksandra1 254 on at

Like (0)

Report

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,394 Most Valuable Professional on at

Like (0)

Report

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,394 Most Valuable Professional on at

Like (0)

Report

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 254 on at

Like (0)

Report

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

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

Like (0)

Report

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 254 on at

Like (0)

Report

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

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

Like (0)

Report

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 254 on at

Like (0)

Report

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