Get Stuck on the Dropdown List

(0) Share

Report

Posted on by Jingjing

Hello,

When I run app on my cell phone, the dropdown list always get stuck.

Sometimes it shows: Displaying 0 Resutls; Sometimes after clicking the dropdown arrow for a couple times, it shows the results but very difficult to select (menu disappear suddenly before you can select something);

If I run the app on my computer, it is better. But the issue still exist sometimes.

I am wondering if this is due to my cell phone does not have much memory, or it is an common issue..

Thank you!

Categories:

Building Power Apps

All responses (6)

Answers (2)

Sort by

Steelman70 873 on at

Like
a
(0)

Report
Copy link

Link copied!

The speed of the dropdown all depends on where you store the source table for the Items of the Dropdown.
I had a similar problem when using a SharePoint list as source, so instead of using the SharePoint list directly I ClearCollect the items into a local collection when the app is started, and then use this collection as the Items for the dropdown.
This works if your items do not change very often (i.e. if it travel type: air, bus, train)
Jingjing 58 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, thank you for your suggestion. Yes, those dropdown items would not be changed often. Could you please show me some more details how I can achieve this through a local collection?
For example, I would need drop down list called Category. It has options below: 1) HR Expenses; 2) Lunch and Learns; 3) Claims; 4)Services
Thank you a lot!
Verified answer

Steelman70 873 on at

Like
a
(1)

Report
Copy link

Link copied!
Then it is even easier, you can upload static data from Excel, here is how:
Close PowerApps and with Excel create a table with a single column (or two columns if you want a choice ID). Name the table "MyChoices" and name the column "ChoiceName" (and "ChoiceID" if you want one)
Enter the choice items in the Excle table, should look almost exactly like this:

Save this Excel file on your desktop
Now back in PowerApp Studio open your PowerApp and go to Content->Data sources->Add data source then choose "Add static data to your App"
Find your file on the desktop and select it, then select MyChoices and then press Connect.
Set the Items property of your dropdown to MyChoices
Now you have a permanent copy of the table in the App, and this is called MyChoices. You can delete the Excel file and nothing will happen.

Please let me know if this works or if you get stuck.
Jingjing 58 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for the detailed explanation! I have successfully connect a static data to my App 🙂
However I am not sure about the Step 6..

I could not find the Item Property option for my drop down.
The current dropdown list showing below is the one inherited from my SharePoint list. Should I unlock the DataCard, delete the current control and add a new drop down list? Thank you!!
Steelman70 873 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, I did not realise that you had the control in a form. I am not sure what to advise, but do try to experiment. I don't use forms because I find they are difficult to customise so easier to start from scratch.
I would suggest you create a new dropdown control on a blank screen and set its .Items to your static data. If this works then try what you are thinking about in customising the form.
Verified answer

hpkeong 2,944 on at

Like
a
(2)

Report
Copy link

Link copied!

Hi

If I am not mistaken, may you
- UnLock the datacard
- Modify the Parent.Default to get your items

Please refer to:

https://powerapps.microsoft.com/en-us/tutorials/working-with-cards/
for details of how to work it out.

Hope this helps.