Answered

Null Variable - use the word NULL in http requst

(0) Share

Report

Posted on by LW-28112008-0

Working through mobile phone logic for Azure AD update user flow.

If a mobile phone doesn't exist, I current have a variable set the value of NULL.

When passing that to variable to Update User (AzureAD activity) or PATCH http GraphAPI call,the variable is an empty string and produces the two "", which isn't accepted as a valid entry

If, within the JSON payload for the graphAPI call, or in the mobilePhone property of Update User, I use the function NULL, the flow will work and accept NULL.

The output now (successful), is the actual word null, not enclosed in "" which graphAPI accpets, and the field within AzureAD is actually null. (no white space for example, which I have read as a workaround!)

Question, how do I pass, actual NULL to the JSON payload, if the variable string is empty?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

LW-28112008-0 on at

Like (0)

Report

Fixed using this expression found here automatically accept an empty string as a null val... - Power Platform Community (microsoft.com)

where there is a conversion of the empty string to an actual NULL value!
I used
if(empty(variables('mobile')),null,variables('mobile'))

where a variable (type string) named mobile, was populated with NULL function.
Adding the IF statement, to populate the JSON payload entry

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report

Hi @LukePWilkins ,

Glad to see you resolved this issue.

You coulr mark your own reply to close the case.

Best Regards,

Wearsky

Was this reply helpful? Yes No