Trying to get Value from Get Items from SharePoint output into a Select, where data type is Choice

(0) Share

Report

Posted on by RubySmith11

Hi,

I have a flow that uses "Get Items from SharePoint List" to retrieve some data.

I am then using "Select" to create a new array with the two fields I need: "License" and "Priority".

The select works fine for "Priority", it is returning the value of the Priority in the SharePoint list.

However, the data returned for "License" seems to be a nested array, with other random data. The Select returns all data associated with the nested array for License.

I am wondering if this is because the data type in SharePoint is Choice? Is there a way to get it to return only the associated Value for the License?

Output from Select

{
  "License": {
    "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
    "Id": 0,
    "Value": "Finance"
  },
  "Priority": 1
}

SharePoint List

Flow

Categories:

Building flows

I have the same question (0)

All responses (1)

Answers (0)

creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report

Trying to get Value from Get Items from SharePoint output into a Select, where data type is Choice

You need to ensure you are selecting the value dynamic content for the choice column and not the choice column itself.

Hope this helps!

Consider giving me a ❤️ if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube

👉 Tips and Tricks on TikTok and Instagram

Was this reply helpful? Yes No