Player and IDE Preview NOT Matching

(0) Share

Report

Posted on by seadude

1,855

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

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

cwebb365 3,294 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
seadude 1,855 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
cwebb365 3,294 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
cwebb365 3,294 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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/

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No