How do you check for Null in Power Automate Desktop? (versus empty)

(3) Share

Report

Posted on by drake

139

We need to check to see if a JSON value is null or not. Here is the JSON:

"customfield_25300": null,

When using the "If" statement, with "Isn't empty", a "variable doesn't have a property" error message is presented (screenshots below). This error message doesn't appear, however, if customfield_25300 contains a value (e.g. "John") instead of null. This makes us think that our value in "First operand" is correct, but that the null in the JSON is in some way confusing the "If" statement.

How do you check for null in Power Automate Desktop?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

yoko2020 495 on at

Like
a
(3)

Report
Copy link

Link copied!
There is already solution here

More Samples
Copy and paste to your PAD designer.
SET NewVar TO $'''{\"name\":\"John\", \"age\":30, \"car\":null}''' Text.Replace Text: NewVar TextToFind: $'''%'null'%''' IsRegEx: False IgnoreCase: False ReplaceWith: $'''%'\"\"'%''' ActivateEscapeSequences: False Result=> NewVar Variables.ConvertJsonToCustomObject Json: NewVar CustomObject=> JsonAsCustomObject IF IsEmpty(JsonAsCustomObject['car']) THEN Display.ShowMessage Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: False ButtonPressed=> ButtonPressed3 END

Was this reply helpful? Yes No
takanee 17 on at

Like
a
(0)

Report
Copy link

Link copied!
@drake
This could be a solution.
Add In/Out Variable with 'Empty'
Not "Set Variabes"
usage example

Power Automate Desktop: null を利用する方法 - Qiita

Was this reply helpful? Yes No
sebastiendb 69 on at

Like
a
(0)

Report
Copy link

Link copied!

@drake Did you find any proper way to solve this issue? (Converting to string and then replacing the 'null' string isn't a solution, but more like a bad workaround)

Was this reply helpful? Yes No