Player and IDE Preview NOT Matching

[seadude]

Hello,

I'm having a serious problem here. An app is working CORRECTLY in the IDE Preview, but showing errors on the iPhone and in the browser Player. 

- Error 1:  "An error occurred on the server..."

    - There are certainly NOT 300 simultaneous sessions on this database.

    - THIS IS ONLY OCCURRING ON MOBILE PHONE! Opening the app in the browser Player does not result in this error!

    - Any ideas on this one?

- Error 2: The IDE Preview does NOT match the iPhone nor browser Player.

- In the Player (iPhone and Browser), the date shown is not rendering correctly (red block covering date).

- This date drives the color of the Gallery Items below it.

- Session ID: 52f65696-d98a-44b7-8d41-07cca344fddd; PowerApps 3.18114.16

- Choosing the same record using the IDE Preview; the date IS rendered correctly and the Gallery Items show up as they should.

- Session ID: 714bfb7f-2152-42a8-8f72-8b731c7bf9b4; PowerApps 3.18114.26

Additional Details:

- Azure SQL backend

- App worked great in my tenant

- App is not working well after being exported from my tenant (United States) and imported into customers tenant (South Africa)

- App Settings Turned On: 

    - Delayed Load

    - Use Non-blocking OnStart Rule

    - Improved App Rendering

Thank you

[cwebb365]

Well it looks like you might be doing a lot of looping / lookups on total readings there per item could be triggering that error.

I’ve had odd issues using SQL backend on my app I made for doing readings where it would work fine in preview but I would be missing data and it just wouldn’t render in play mode. The work around for that was I had to create galleries in my app that used the columns I used elsewhere in the app and I would change to where the items returned was always 0 records and it was hidden. It’s almost as if the fields had to be bind to a control ahead of time to render. I dunno. Just a hunch cause I had issues till I created those galleries and used my fields in them even though they returned no records and were not visible I couldn’t reference fields from a connected data source table till it was attached to that hidden gallery somewhere in the app.

[seadude]

Thank you very much for the reply.

Has anyone else seen this type of behavior before? Any thoughts on this issue or @cwebb365's comments?

Is there a pattern (Lookup, Filter, etc.) that can cause issues with Galleries using Azure SQL as Items?

[cwebb365]

Well I think depending how your pulling that number in your gallery it’s probably making a connection for each. So your better approach to solve that one would Probably bring your data local filtered down to the data that would be used to a collection. Then run your gallery lookups against it so it’s not going out to the database so much.

The date issue might be separate and related to what I’m talking about with a reference to a field not bound to a control. Is the date just completely missing in play mode vs designer?

[cwebb365]

Hey Seadude, take a look at this article, came across it the other day, and will explain the looping (using lookup in gallery) and how it makes calls for each, and how you can get around it by collecting your data locally first into collections, then pointing your gallery and embeded lookup to use the local collection you create. 

Hope this helps. 

https://powerapps.microsoft.com/en-us/blog/performance-considerations-with-powerapps/

[Anonymous]

Hi @seadude thank you for posting this thread and I'm sorry to hear you're experiencing this issue. Can you review the latest reply from @cwebb365 and advise if it helps your situation?

@Anonymous