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

Drop down not working in Web Player or on Mobile device

Hi

 

Wondering if anyone can help?

 

I've noticed over the past week or so that when i create new apps the drop downs are not populating in the Web Player but it works fine in the design studio. I have tried it on various devices andriod, ios and different web browsers all yeild the same results.

 

Background:

Azure SQL Server

Populating the dropdown via a collection, the collection is populated on Start of the application. I have also tried OnVisible both producing the same results.

 

I'm not doing anything different to what I have done in previous applications which work fine. The problem does not happen on every app created, thus making it hard to troubleshoot. Any pointers on what to check to  try and resolve the problem would be appreciated.

 

There are no errors occuring when running the application(s) in the web player or mobile devices, just an empty dropdown column.

 

I have also tried adding a new dropdown and publishing, on occassion the drop down works and then stops again when published again.

 

Is anyone else experiencing the same?

 

If any further information is needed, do let me know and I will post.

 

Thanks

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

I am also having this issue. My Process :

 

On app start > ClearCollect( directory , 'SQL dbo' )

Dropdown > Allowed Values = directory

 

This seems to have worked fine with other apps in the past no problem, but now I am running into the same issue that you are. The dropdown items will populate in the web developer, however, in the web player or on mobile I get fields populated with blank values.

 

Will try and troubleshoot this and get back to you if I find any solutions.

 

Edit : It seems to be an issue with the ClearCollect() calling of the directory. I've had this issue before with Collections from a SQL DB not populating properly, you can find the solution in this thread

 

https://powerusers.microsoft.com/t5/Creating-Apps/Clearcollect-Not-Retrieving-All-Data/m-p/166681#M4...

 

Tldr; turn off the Advanced setting "Explicit Column Selection" .... that should fix your problem!

View solution in original post

3 REPLIES 3
Advocate II
Advocate II

I saw something similar.  I took a functioning app and did a SaveAs to a new name.  The newly saved app has issues rendering values in the drop downs (the original does not).  I am populating the dropdown via filter on a SharePoint list (cascaded values from another drop down).  The drop downs actually have values in them, but they are displaying blanks (meaning I can select 1 of 6 "empty" rows from the dropdown).

 

I have also noticed other dropdowns where the selections get "disconnected" from the original dropdown.  Meaning the display of the dropdown list when opened may be 3-4 fields below the actual drop down field.

I am also having this issue. My Process :

 

On app start > ClearCollect( directory , 'SQL dbo' )

Dropdown > Allowed Values = directory

 

This seems to have worked fine with other apps in the past no problem, but now I am running into the same issue that you are. The dropdown items will populate in the web developer, however, in the web player or on mobile I get fields populated with blank values.

 

Will try and troubleshoot this and get back to you if I find any solutions.

 

Edit : It seems to be an issue with the ClearCollect() calling of the directory. I've had this issue before with Collections from a SQL DB not populating properly, you can find the solution in this thread

 

https://powerusers.microsoft.com/t5/Creating-Apps/Clearcollect-Not-Retrieving-All-Data/m-p/166681#M4...

 

Tldr; turn off the Advanced setting "Explicit Column Selection" .... that should fix your problem!

View solution in original post

Anonymous
Not applicable

Thanks for your help with this issue, @James_Hellfeier!

 

@Anonymous

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 (9,969)