Answered

Help in writing expression

(0) Share

Report

Posted on by Community Power Pla...

Hello,

I have working on a flow where I am using Get row by ID . I want to fetch a value from that output and use it in a condition. How to write expression to fetch that value.

The output from Get row by Id is as below.

I tried using expression

outputs('Get_a_row_by_ID_6')?['statuscode@OData.Community.Display.V1.FormattedValue']. but this is not working . Can someone help me

Thanks.

All responses (4)

Answers (1)

MSDynamic Microsoft Employee on at

Like (0)

Report

Re: Help in writing expression

Hi! Is that '?' syntax used to retrieve the value from the JSON key?
Expiscornovus 31,648 Most Valuable Professional on at

Like (0)

Report

Re: Help in writing expression

Hi @Anonymous,

I think you need to switch the OR to an AND in your condition to get it working.
Verified answer

Expiscornovus 31,648 Most Valuable Professional on at

Like (0)

Report
Re: Help in writing expression

Hi @Anonymous,

Can you add the Body part to the expression?

Try this expression instead:

outputs('Get_a_row_by_ID_6')?['body/statuscode@OData.Community.Display.V1.FormattedValue']
Community Power Pla... on at

Like (0)

Report

Re: Help in writing expression

I used outputs('Get_a_row_by_ID_6')?['body/statuscode@OData.Community.Display.V1.FormattedValue'] which is fetching the right value.

but the condition is not working as expected.