Answered

Retrieving get item

(0) Share

Report

Posted on by eltibu

Hello,

I'm using 'Get Item' with the Excel Online (Business) connector to retrieve a particular row from an Excel table. How do I get the underlying value from one of the columns, I'm trying to get 'Column2' now for usage in a subsequent step? The get item step is named "Get Geographic Focus".

Attached is the output from the 'Get Item' step, I'm trying to obtain the value "All" from body/Column2.

I've tried so far

body('GetGeographicFocus')?['Column2']

as well as

outputs('GetGeographicFocus')?['body']?['value']?[0]?['Column2']

Categories:

Building flows

Capture.PNG

I have the same question (0)

All responses (3)

Answers (1)

v-yetonggu-msft on at

Like (0)

Report
Hi @eltibu ，

If you want to take the value of Column2 in the first item,please try this expression:

outputs('Get_Geographic_Focus')?['body/value']?[0]?['Column2']

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
Verified answer

Alex256 84 on at

Like (0)

Report

So, you need to change the name of the step in your expression into: Get_Geographic_Focus

Was this reply helpful? Yes No
eltibu on at

Like (0)

Report
Thank you, @Alex256 . That was precisely it. Sorry to bug with simple questions, sometimes the solutions are so near.
For everyone's benefit, expression used to obtain the Column 2 value is
body('Get_Geographic_Focus')?['Column2']

Was this reply helpful? Yes No