cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
satya
Level: Powered On

DropDown Values from SharePoint Single line of Text column

i have a SharePoint list with column of type single line of text, i need to bind the data from single line of text to drop down. duplicate records should not show and default value of dropdown should be "Please Select"
Please help me to achieve this.
3 REPLIES 3
Microsoft dinusc
Microsoft

Re: DropDown Values from SharePoint Single line of Text column

You can use a ComboBox control as following:

ComboBox1.Items=Distinct(Your_SP_List, UniqueColumn)

ComboBox1.InputTextPlaceholder="Please Select"

ComboBox1.SelectMultiple=false

satya
Level: Powered On

Re: DropDown Values from SharePoint Single line of Text column

hi,

 

i have created collection as ClearCollect(ABDrop,{colname:"Default Value"},Distinct(MyTest,colname)), but when i am trying to bind collection to Combobox it is showing empty values

Microsoft dinusc
Microsoft

Re: DropDown Values from SharePoint Single line of Text column

I'm not sure I understand the meaning of the {colname:"Default Value"} in your ClearCollect formula.

Please try this:

ClearCollect(ABDrop,Distinct(MyTest,colname))

If you intended to add an extra item to your collection, then you will have to do this by a separate Collect

 

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (4,928)