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

I have the same question (0)

All responses (3)

Answers (1)

Sort by

v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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
Copy link

Link copied!

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

Link copied!
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