Answered

Help in writing expression

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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,750 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
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,750 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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

Was this reply helpful? Yes No