Get/List the Drop down values from sharepoint list

Like (0) Share

Report

Posted on 17 Jan 2024 13:54:57 by Harishv1993

I have a sharepoint list which is maintained by other team/organization in which we have column having Drop down values. This drop down values gets changed every month. I was trying to build a flow to create items into this flow and enquired the team how they are maintaining the value and found that they are doing it manually. So I wanted to know if there is any way to get these values in the list. So that I can use them in the flow.

Ex:

Sharepoint List:

UserName | Period | Comments

In this list Period column is of drop down type which will have values with the below format

Current ******

PP*****

PP****
**** will get changed everymonth but the strings/words Current & PP will remain as it is and they are first words in the drop down.

From the above example I want to always select the value that starts with current.

I have explored multiple options but none of them is working so can you please help me with this.

All responses (1)

Answers (1)

Verified answer

Expiscornovus 32,187 Most Valuable Professional on 17 Jan 2024 at 17:04:02

Like (0)

Report
Re: Get/List the Drop down values from sharepoint list

Hi @Harishv1993,

You can retrieve the option label/choices of a field by using a Send an HTTP request to SharePoint with a REST API call. After that you can use for example a Filter Array to check the outputs which of the choice item starts with Current.

Below is an example

1. The Send an HTTP request to SharePoint action uses.

URI

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

Headers

{ "Accept": "application/json;odata=nometadata", "Content-Type": "application/json;odata=nometadata" }

2. The Filter Array uses the Choices array from the body of the previous action

outputs('Send_an_HTTP_request_to_SharePoint')?['body']['Choices']

3. In the where section of the Filter Array this expression is used (in advanced mode)

@startsWith(item(), 'Current')