Select function - handle missing properties

(0) Share

Report

Posted on by JacekP

Hi,

I have a problem with the function SELECT.

I want to select data from the HTTP request. Http request is geting test cases with properties (Title, RunBy,Tester,Outcome,Date,TestPlan).

Some test cases were not performed so they don't have properties (RunBy,Outcome,Date).

Therefore in action SELECT I would like to select properties RunBy,Outcome,Date only when the exist. If they don't exist I want to put some text as a property.

For example for property RunBy in SELECT action I tried to use following formulas:

if(empty(triggerbody()?['lastResultDetails']['runBy']['DisplayName']),'',triggerbody()?['lastResultDetails']['runBy']['DisplayName'])

Result: Property RunBy is always emtpy.

if(empty(item()?['lastResultDetails']['runBy']['DisplayName']),'',item()?['lastResultDetails']['runBy']['DisplayName'])

Result: error - item runBy can't be selected

Can you help me create the proper formula please?

Thank you

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Ellis Karim 11,681 Super User 2025 Season 2 on at

Like (1)

Report

Hi @JackP ,

Can you post the output value property from the Send HTTP action please. Then we can see the structure of the data and the actual properties that we need to use in the expressions.

Ellis

Was this reply helpful? Yes No
JacekP 31 on at

Like (0)

Report

Hi,
Thank you for your response.

Example of HTTP request value where there are properties for one test case:

If there are more test cases in HTTP request response, then some of them might not have 'yellow' part (when the test run for particular test case was not performed).

Thank you

Was this reply helpful? Yes No
Verified answer

JacekP 31 on at

Like (0)

Report

Hi,

I found the solution. I was going to deep into properties.
It should be:
if(empty(item()?['lastResultDetails']),'',item()?['lastResultDetails']['runBy']['DisplayName'])

instead of

if(empty(item()?['lastResultDetails']['runBy']['DisplayName']),'',item()?['lastResultDetails']['runBy']['DisplayName'])

Topic can be closed.

Was this reply helpful? Yes No