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

Re: Dropdowns not showing items from choices column

Thank you for your response, but unfortunately I have repeatedly been doing this and to no avail.

 

The columns will just not reconnect.

 

Beyond frustrating !

Henryed07
Level: Powered On

Re: Dropdowns not showing items from choices column

I've been having the same issue too. I created a post about this, which appears to have dissapeared. Microsoft needs to look at this as it's a re-occuring issue.

 

JohannaM
Level: Powered On

Re: Dropdowns not showing items from choices column

Have got the same issue, have an App that has not had any changes and the Dropdown stopped working for no reason.

 

Have tried all of the above mentioned actions to try and none of them have resolved the problem.

 

When are Microsoft going to have a look at this issue.

Highlighted
Axford_Clare
Level: Powered On

Re: Dropdowns not showing items from choices column

We experiencing this frequently. Forms that have been working will just suddenly stop displaying drop down options or the person fields liked to our AD will not populate once the user types in 3 or more letters. The only way we have been able to get the form to work again is to open it in PowerApps, delete all affected data cards, then refresh the data source and then save and publish, then reopen the form in PowerApps, add back the data cards, and save/publish. 

While this fixes the form, it doesn't prevent this from happening again and therefore is not an acceptable solution. The most frustrating part is that the data cards often have formulas that we need to re-add once the cards are added back to the form. Sometimes these are quite complex and take some time to recreate.

There's no warning/alert when this happens so we have to wait until a colleague tells us the form isn't working. If they need to use the form urgently, they can't, and so we have to resort to paper forms until we have a chance to fix and test the form. 

PowerApps Staff _Corey_
PowerApps Staff

Re: Dropdowns not showing items from choices column

@Henryed07 @JohannaM @Axford_Clare  We have recently committed a fix for a timing issue where ComboBox controls that are searchable can be unhooked from their data when the dependent data source is refreshed (or removed and added again).  

I'll re-post a mitigation that is currently recommended from this post: https://powerusers.microsoft.com/t5/Building-PowerApps-Formerly/Sudden-appearance-of-red-x-s/m-p/371...

 

As we understand it, the issue may occur sometimes when the data source that a ComboBox control is bound to is either (a) refreshed, or (b) removed and then added again.  The current advised mitigation that has seen success with customers is to perform the following actions after refreshing or removing/adding a data source:

  1. Save the app immediately and close it
  2. Re-open the app and continue making any non-data source refresh/remove/add changes (note: you will have to make at least one trivial change to mark the app as dirty so that it can be saved again in step #3)
  3. Save the app and re-publish

This should allow the ComboBox controls to be correctly reconfigured to the correct values.

Also, if your ComboBox control contains only a small number of values, it is advised to disable IsSearchable since (a) this incurs a slight overhead when enabled, and (b) the issue of empty values only occurs when IsSearchable=true.

 

FYI--the fix is expected to be deployed to all production regions the week of October 21.

PowerApps Staff _Corey_
PowerApps Staff

Re: Dropdowns not showing items from choices column

@Henryed07 @JohannaM @Axford_Clare The fix for missing items in ComboBox drop-downs has been deployed to all production regions with Studio release 3.19101.  You will need to edit and re-publish your app(s) for the changes to take effect.

View solution in original post

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
Users Online
Currently online: 100 members 5,328 guests
Please welcome our newest community members: