Skip to main content

Notifications

Power Automate - Building Flows
Answered

Get Sharepoint List Choice Column values

(1) ShareShare
ReportReport
Posted on by 40

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.

  • Expiscornovus Profile Picture
    Expiscornovus 31,089 on at
    Re: Get Sharepoint List Choice Column values

    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)

     

  • gstlouis Profile Picture
    gstlouis on at
    Re: Get Sharepoint List Choice Column values

    @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

  • CU20111035-0 Profile Picture
    CU20111035-0 40 on at
    Re: Get Sharepoint List Choice Column values

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

  • Verified answer
    Expiscornovus Profile Picture
    Expiscornovus 31,089 on at
    Re: Get Sharepoint List Choice Column values

    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

     

    choicefieldsettings.png

     

    2. The Uri for the HTTP request

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

     

    retrievechoicesoffield.png

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,445

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,741

Leaderboard