Data displays in dev preview mode but won't display in production

[Anonymous]

Hi
I'm at a loss with this.
While viewing one of my apps in preview mode (e.g. while developing it) all the data is displayed correctly.
However, when accessing the App in production mode (e.g. with the web URL) the data doesn't display either at all or just fragments.

I've built a few apps and not had this problem before. I've tried flushing my browser cache, forcing the app to refresh and using a different browser, all to no avail. I've even tried rebuilding the app - this started okay but then the problem reoccured part way through so I abandoned the rebuild.

The attached shows the screen shots of the dev preview versus production.

What is really bugging me is that the app with the problem is actually quite simple compared to the others I've built.

Any suggestions?

Thanks in advance.

[dinusc · Accepted solution]

@Anonymous, have you tried disabling the Explicit Column selection feature as per Paul's suggestion above?

[Anonymous]

Hi
The raw data wouldn't display at all (with the 4th app sharing the same database connection/database), so it's nothing to do with collections etc.

I tried creating a second database connection to the same database - PowerApps allows you to do this but you can't give it a useful name e.g. DB Connection 1, DB Connection 2, etc. This didn't make any difference.

I've now added a couple of the simple pages from the troublesome app to the back of one of the working apps - these work perfectly.

I suspect that PowerApps won't permit more than three Apps connected to the same database at the same time - very limiting if that is the case

I'll try disconnecting one of the three working apps to see if the fouth one decides to work - if it does this will confirm my suspicions (unless someone already knows?).

I'll report back once I've completed my testing.

[dinusc]

I don't think PowerApps can limit the number of connections to the back end service.

Can you please try to disable the "Explicit Column selection" feature to see if it helps?

[Anonymous]

Looks like Explicit Column was turned on by default when I created the troublesome App. The other Apps worked as Explicit Column was already turned off.