Answered

Get Sharepoint List Choice Column values

(1) Share

Report

Posted on by Kai Adler

Hi Community.

I'd like to build a flow where i iterate over all possible values of a choice column in a sharepoint list. I found several sources where i am able to get the value of a certain row, but not for the general list itself. Did anybody find a solution to this problem? Thanks in advance.

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Verified answer

Expiscornovus 33,874 Most Valuable Professional on at

Like (3)

Report
Copy link

Link copied!
Hi @KAdler,

If I understand your requirement you just want the options defined in the settings of the field, correct?

If that is the case you could use a Send an HTTP request to SharePoint action and retrieve the field via the fields method.

Below is an example

1. The field settings

2. The Uri for the HTTP request

_api/web/lists/getbytitle('@{variables('ListName')}')/fields/getbytitle('@{variables('FieldName')}')?$select=Choices

Was this reply helpful? Yes No
Kai Adler 46 on at

Like (0)

Report
Copy link

Link copied!

thanks @Expiscornovus for your perfect reply, works like a charm 🙂

Was this reply helpful? Yes No
gstlouis on at

Like (0)

Report
Copy link

Link copied!

@Expiscornovus
Where did you find documentation for the uri request? ex.
_api/web/lists/getbytitle('@{variables('ListName')}')/fields/getbytitle('@{variables('FieldName')}')?$select=Choices

I have been looking for documentation and cannot find anything

Was this reply helpful? Yes No
Expiscornovus 33,874 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @gstlouis,

Below is an example of a doc reference for the SP.FieldCollection.getbyTitle method: https://learn.microsoft.com/en-us/previous-versions/office/sharepoint-visio/jj246244(v=office.15)

Was this reply helpful? Yes No
GarryBeat 10 on at

Like (0)

Report
Copy link

Link copied!

Hi @Expiscornovus,

Your HTTP request is promising, but for me it's returning what looks like an object rather than an array:

{

  "d": {

    "__metadata": {

      "id": "https://company.sharepoint.com/teams/Network/_api/Web/Lists(guid'1085bacb-f5ad-4078-b54c-f4448cbebf81')/Fields(guid'c7921a01-c4eb-44c7-9d04-956')",

      "uri": "https://company.sharepoint.com/teams/Network/_api/Web/Lists(guid'1085bacb-f5ad-4078-b54c-f4448cbebf81')/Fields(guid'c7921a01-c4eb-44c7-9d04-956')",

      "type": "SP.FieldMultiChoice"

    },

    "Choices": {

      "__metadata": {

        "type": "Collection(Edm.String)"

      },

      "results": [

        "OMA",

        "OMB",

        "FCOM",

        "FCTM",

        "MEL",

        "FOPM",

        "Flight Efficiencies",

        "CRM",

        "WIH",

        "iPad",

        "eQRH",

        "CDL",

        "FOTM",

        "CWQR",

        "FS+ Guide",

        "FOTM",

        "LIDO",

        "Operational Quick Access",

        "Threat Matrix",

        "Briefsmart Guidance",

        "Normal Checklist",

        "Standard Aircraft Specification",

        "OMDF",

        "ACARS Operational Guidelines",

        "CSPM",

        "Pilot Competency Matrix"

      ]

    }

  }

}

How do I get just the list of "results" at the bottom? The one that starts with "OMA" and ends with "Pilot Competency Matrix".

Many thanks,

G

Was this reply helpful? Yes No
Expiscornovus 33,874 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @GarryBeat,

I see it is returning the d property. Can you make sure you use the 'application/json;odata=nometadata' value in the Headers section for the Accept key?

After that you should be able to use the below expression

body('Send_an_HTTP_request_to_SharePoint')['Choices']

Test result

Happy to help out 😁

I share more #PowerAutomate and #SharePointOnline content on my Blog, Bluesky profile or Youtube Channel

Was this reply helpful? Yes No