cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
audrieg
Level 10

Performance Issues - Drop Down Control

I have created a custom Power App and there are only 3 controls on the form, and two text boxes holding the longitude and latitude values. Data sources are two connections to SharePoint Lists.

 

Connection 1 is a configuration list with only 3 items (title column only) that I am using to populate a drop down list since choice lists are read only (for use with the patch() function).

Connection 2 is a brand new list (now empty) with 5 columns and none of the columns are required.

 

I am patching 4 columns (plus the title field since it seems to need that) to the destination list (connection 2).

It should receive Reason field value, a first name, a last name, and longitude and latitude values, plus the title.

There are no errors or yield sign icons in the app.

 

On my phone the drop down takes forever (so long that it times out) to load the choices. Is there anyway I can speed it up? I have not had this problem before, and the only new thing is the longitude and latitude values.

 

Thank you in advance for your help.

Audrie

 

12 REPLIES 12
PowerApps Staff rgruian
PowerApps Staff

Re: Performance Issues - Drop Down Control

Audrie,

 

Can you please create a new app with a simple dropdown and bind it to your Connection1? Do not introduce any forms or any other dependencies.

 

    dropdown1.Items = Connection1

 

Then test it on your phone. Is it still equally slow to load the choices?

 

If it turns out to be fast(er) than the app you are describing, can you please tell me more about the way you are patching those 4 columns?

  • How/when is the patch triggered, in what formula, what property(ies)
  • What is the rough syntax you are using.

 

Thank you.

Radu Gruian [MSFT] ** PowerApps Staff
audrieg
Level 10

Re: Performance Issues - Drop Down Control

Is there an email I can use to give you access?- I can share the app with you on my tenant if you'd like.

 

I will fill in the other answers as soon as I can.

audrieg
Level 10

Re: Performance Issues - Drop Down Control

I removed everything except the dropdown and the single connection to the small list with 3 titles. I also replaced the function so it's calling all values (as you suggested above) rather than the Distinct Function I had. It the exact same experience. Works well in the browser but the drop down won't load on the phone.

 

Let me know if you want access, I just need your Microsoft email so I can add you as a user.

 

P.S. There is a background photo on the page - if that matters.

 

Thank you,

Audrie

Microsoft Employee

Re: Performance Issues - Drop Down Control

Sorry Audrie that you are running into this issue. If possible can you please share the app with mayuro microsoft?

 

Thanks,

Mayur

audrieg
Level 10

Re: Performance Issues - Drop Down Control

You have been granted tenant and app access.

Microsoft Employee

Re: Performance Issues - Drop Down Control

Thanks for sharing. This is a known issue on our side where we are trying to get some metadata for picture columns to work correctly (we are making this call even when it is not needed - in your case it does not look like it is needed.. )

 

We are actively working on this change and have aspirations of shipping a fix by the end of the month.

 

Thanks,

Mayur

audrieg
Level 10

Re: Performance Issues - Drop Down Control

I'm not sure what you mean, I didn't use any picture columns in this case. The background image is uploaded to the content media. So I might be missing something...please advise.

Highlighted
Microsoft Employee

Re: Performance Issues - Drop Down Control

You are right. The bug is on our side. For your app we should not have made a particular call which took 6 seconds .. resulting in the sluggishness you were observing.

We are working on a fix and hope to release it by the end of this month.
audrieg
Level 10

Re: Performance Issues - Drop Down Control

Oh Ok. No worries! Thanks for considering it.

 

Do you have a recommendation on what I should remove in the meantime? Is the problem the location or the background image?

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: 410 members 4,979 guests
Please welcome our newest community members: