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.
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)
@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
thanks @Expiscornovus for your perfect reply, works like a charm 🙂
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