Unanswered

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.

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (1)

Community Power Pla... on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,183 Most Valuable Professional on at

Like (0)

Report
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']

Was this reply helpful? Yes No
Expiscornovus 33,183 Most Valuable Professional on at

Like (0)

Report

Hi @Anonymous,

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

Was this reply helpful? Yes No
MSDynamic Microsoft Employee on at

Like (0)

Report

Hi! Is that '?' syntax used to retrieve the value from the JSON key?

Was this reply helpful? Yes No