Get/List the Drop down values from sharepoint list

[Harishv1993]

Hi 

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.

[Expiscornovus · Accepted solution]

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')