HTTP Request has Null values how do I use a condition to get past the Null values?

(1) Share

Report

Posted on by SPS-DEV-22

516

My Flow works as long as there is an image in the column that the api is checking : Vehicle 2

the Empty Photo fields are Ok. I just want to get past the Null Value for the Photo Fields that stops the flow.

The error gets thrown on the PARSE JSON-Photo2 it will sometimes have a null value. which means no photo added, which is fine. t

How do I setup a condition to check for Null value?

Would this work?
"type": "If",
"expression": {
"equals": [
"@outputs('Send_an_HTTP_request_to_SharePoint2')?['body']?['d']?['Vehicle_x0020_2_x0']",
"@null"
]
}

How do I setup the condition prior to the Jason Step and if there is a Null value continue, as it is OK to have Null values.

I want the flow to run image or no image.

All responses (3)

Answers (0)

SPS-DEV-22 516 on at

Like (0)

Report

Re: HTTP Request has Null values how do I use a condition to get past the Null values?

this did not work. it is something to do to keep the flow going but I still have the issue with a NULL value
SPS-DEV-22 516 on at

Like (0)

Report

Re: HTTP Request has Null values how do I use a condition to get past the Null values?

Ok, this looks interesting and possibly a solution.

I do have a question::
how do I setup the condition?

I was able to get the scope:
and I see a configure after run, but I cannot get it as a separate item like you are showing.

Plus I get this error

Does this mean I need to put all of the flow items in the scope? or how do I get that condition?

Also, when I set the Conditions to run after Success and or Fail
it still has the issue with the Schema failing at Null.
v-xiaochen-msft on at

Like (0)

Report

Re: HTTP Request has Null values how do I use a condition to get past the Null values?

Hi @SPS-DEV-22 ,

Please try this

result('Scope')[0]['status']

Best Regards,

Wearsky