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

Capture.PNG

All responses (3)

Answers (1)

eltibu on at

Like (0)

Report
Re: Retrieving get item

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']
Verified answer

Alex256 84 on at

Like (0)

Report

Re: Retrieving get item

So, you need to change the name of the step in your expression into: Get_Geographic_Focus
v-yetonggu-msft on at

Like (0)

Report
Re: Retrieving get item

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