Get Items > Select > Output?

[IPC_ahaas]

I am using "Get items" to pull values from a SharePoint List.

I want to pull specific values from that List, so I put them in a "Select".

Example output:

[
  {
    "IncidentDate": "2023-08-16",
    "Location": "101"
  }
]

I want to then pull the "Location" value ("101").

How do I do that?

[Sundeep_Malik]

Hey @IPC_ahaas 

Instead of using Select action you can directly filter it in filter query of get items action. Like the following:

Make sure Location is the logical name of the column in sharepoint list. To check it just click on the gear icon of that list, and then select list settings, you will see all the columns, just select it and then go to the url and go to the end of the url, there you will see the actual logical name of the column.

Or if you want to use select action do it like this:

Or

I hope this helps 🙂

[IPC_ahaas]

I have the process of building the Select, it's getting the data out that is my issue. I am putting these values in numerous places. So I want to get the value of "Location" and put it somewhere.

I thought it would be something like this

body('Select_Details')?['Location']

But I get this error:

[Sundeep_Malik]

@IPC_ahaas 

As it is an array its giving you an error.

You will have to use apply to each loop in that.

Send the body of select and inside it write the location.

If you think you will only get 1 value in that select then you can directly write the following expression:

body('Select_Details')?[0]?['Location']

I hope this helps 🙂