cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

Powerapps BInding to dropdown control?

Let's I have XLS file with the column which contains people names. I would like to have a dropdown on my editor form where I can bind sropdown to this column as well as to have the list populated with distinct names from the same column. And which would allow me to slelect a new value from the list to update the form to propagade changes to the datasource.

 

I can use context variable as a list to pass to this editor form from the view records form as a parameter for Navigate action ->

 

Navigate('EditorForm', ScreenTransition.None,  {GroupList: Distinct(SDS, PeopleNames)

28 REPLIES 28

Hi,

I want to use a dropdown control that gives me a possibility to choose a project:

  • I have to sharepointtable: project and timesheet. The powerapp is meant to let our consultants fill the timesheet with their tasks
  • ID is the number of the projects (in table project) and must be saved in the ContractID of the table timesheet
  • to give them more contextinformation I filled the dropdown with additional data: Distinct(TblProject;ID&" "&KP&" "&Title&" "&Subject) in the items section of the control
  • default section: parent.default

Now the card where I have put the dropdown control in is not using the data in the dropdown. I don't know where i can link them. I follow the tips on this discussion but it didn't work out. The dropdown just shows the complete list and always starts with the first item in the list, while it should show the project that was selected.

 

2nd question: I want to sort the dropdown list: Title-KP, can this be done in the formula?

Thanks for your advice and ideas.

Herwig

Anonymous
Not applicable

When I go to the Update and fill in step 5 as described below I get errors.  It does not seem to understand the *.Select.Value syntax when I enter the information as described.  I have followed the steps 1 - 3.  I think Step 4 states to select the card bubble for the drop down.  I select it and find Update, but when I go to fill card.name.Selected.value instead of datacardvalue#.Selected  and it errors out.  Any thoughts?

Anonymous
Not applicable

When I go to the Update and fill in step 5 as described below I get errors.  It does not seem to understand the *.Select.Value syntax when I enter the information as described.  I have followed the steps 1 - 3.  I think Step 4 states to select the card bubble for the drop down.  I select it and find Update, but when I go to fill card.name.Selected.value instead of datacardvalue#.Selected  and it errors out.  Any thoughts?

@Anonymous maybe create a new thread? I would like to point you in the right direction but I am confused what you are trying to do and where you are having issues. I have a bunch of videos that show you how to do this type of stuff but I can't even figure out which one to send you. 

Shane - Microsoft MVP, YouTube, and PowerApps Consulting for when you are in a bind to get this fixed quickly. And finally we now have PowerApps Training

I am new to powerapps (07/2018), and I found this solution helped to resolve a simular problem that I encountered moving data from a drop down list in a form, to a data source table. Thank you.

Edward

Helper IV
Helper IV

Hi,

In my screnario,

I need to get values into the dropdown from a swagger custom connetion.

 

Is there any way to get values from swagger into a dropdown.

i tried to get user infromation using custom connection, but here i'm trying to get more than 10 values into a dropdown using a custom swagger connection.

Please let e know if anyone have tried this.

 

Thanks in advance

Helper I
Helper I

Setting Update to Dropdown1.Selected.Value or Dropdown1.Selected.Text or Dropdown1.SelectedText or Dropdown1.Selected does not work.

 

I get an error "Expected Text Value"

Thanks so much,

What if the combobox is a multiple selection control? Default:Parent dont work on this.

Helpful resources

Announcements
News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (5,407)