You’re offline. This is a read only version of the page.
Announcements
12
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.
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
Share
Report
All responses (
Answers (
_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')
