Performance Issues - Drop Down Control

[audrieg]

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

[rgruian]

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.

[audrieg]

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]

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

[mayuro]

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

Thanks,

Mayur

[audrieg]

You have been granted tenant and app access.

[mayuro]

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]

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.

[mayuro]

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]

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?