cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate II
Advocate II

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 !

Highlighted
Helper II
Helper II

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.

 

Highlighted
Advocate I
Advocate I

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
Advocate I
Advocate I

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. 

Highlighted
Power Apps
Power Apps

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.

Highlighted
Power Apps
Power Apps

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

Highlighted
Frequent Visitor

Re: Dropdowns not showing items from choices column

I agree that this issue needs to be resolved. It keeps happening. It seems to be happening way too often. 

Highlighted
Post Partisan
Post Partisan

Re: Dropdowns not showing items from choices column

This issue is still occuring . I'm way beyond that release..

Why is Microsoft ignoring the calls for help ?

 

dave

Highlighted
Power Apps
Power Apps

Re: Dropdowns not showing items from choices column

@DAVIDPOWELL A few questions:

  • This is occurring in the latest version of Studio?
  • Or just the published app? 
  • Are you experiencing the issue with a ComboBox or Dropdown control?
    • If ComboBox, what are the rule values for Items, DefaultSelectedItems, DisplayFields, and IsSearchable?
    • If Dropdown, what are the rule values for Items and Value
  • Does a ListBox or Gallery control exhibit the same behaviour when the same Items rule is applied?
Highlighted
Post Partisan
Post Partisan

Re: Dropdowns not showing items from choices column

@_Corey_Thanks for the reply.
The application worked fine and shared fine while on SharepointLists.
I switched the dropdowns to sql server source as shown below. Still worked fine on my machine.
Once I share and publish to others. Does not work on their machine. drodown or comboboxes….
If I just place a dropdown on the form with no FILTERING the published version can see the dropdown selections.

Once I add this to the Dropdown

  • items = Filter('[dbo].[v_nsc_support_type_column_template_v2]',cbo_ComboSearch.Selected.RegionCode = RegionCode 
    The dropdown downs lose their connections.

On

 

  • This is occurring in the latest version of Studio? Yes, PowerApps version 3.20054
  • Or just the published app?  published app...works fine on my app before I publish/share to others.
  • Are you experiencing the issue with a ComboBox or Dropdown control?  both - 
    • If ComboBox, what are the rule values for Items, DefaultSelectedItems, DisplayFields, and IsSearchable?
      issearchable  =  false,
      items = Filter('[dbo].[v_nsc_support_type_column_template_v2]',cbo_ComboSearch.Selected.RegionCode = RegionCode )
       
  • Does a ListBox or Gallery control exhibit the same behaviour when the same Items rule is applied? have not tried.

Helpful resources

Announcements
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (6,736)