cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BrianHFASPS Post Patron
Post Patron

App works in editor / preview but not published?

I have an app that pulls data from an Azure SQL instance of two tables and one view. It is mostly just galleries that show differently filterd versions of the sql view based upon column values. I built it first using SharePoint list and then rebuilt it using SQL as backend to allow for further expansion. The app works fine in Play Preview mode from editor but doesn't work at all via Publish in web browser or on IOS app. The web version just doesn't show any data in gallery. The IOS version throws a bunch of errors. I have tried it logged in as myself (rather than shared to another user) to hopefully bypass any permissions issues. I have tried refreshing my SQL connections. I also tried disabling Explicit column selection, Improved app rendering and Use column display names. This didn't seem to make any difference. I imagine it is something about my SQL connection but can't figure out what. Here is screen capture of IOS.

IOS error.png

It looks like it might not be able to access the SQL view? Am I missing permissions somewhere for production use instead of development use?

1 ACCEPTED SOLUTION

Accepted Solutions
BrianHFASPS Post Patron
Post Patron

Re: App works in editor / preview but not published? - Bugs in Preview features!

I opened a case with support and they got back to me very quickly thankfully. As I mentioned I tried turning of Explicit column selection but they had me turn off that and Use non-blocking OnStart rule. I have to have both off, either one alone and the app still doesn't work. I am new to PowerApps is this of product breaking bugs in Preview features normal?

View solution in original post

4 REPLIES 4
BrianHFASPS Post Patron
Post Patron

Re: App works in editor / preview but not published?

I took my connection to SQL View and auto generated an app. It is view only in the pre-made app. However this app works fine using the existing connection for me and shared with other users. This tells me I think that the SQL connection is fine, it must be some other mistake in my code. The problem is I can't make it fail in the editor?

BrianHFASPS Post Patron
Post Patron

Re: App works in editor / preview but not published? - Bugs in Preview features!

I opened a case with support and they got back to me very quickly thankfully. As I mentioned I tried turning of Explicit column selection but they had me turn off that and Use non-blocking OnStart rule. I have to have both off, either one alone and the app still doesn't work. I am new to PowerApps is this of product breaking bugs in Preview features normal?

View solution in original post

Super User
Super User

Re: App works in editor / preview but not published? - Bugs in Preview features!

Having a similar issue: Unable to consistently ClearCollect a SQL View ON MOBILE DEVICE ONLY. Works fine in IDE Preview Mode and Browser Player on laptop. Super frustrating. Unfortunately, turning off Non-Blocking OnStart and Explicit Column Selection did NOT work for me. Any further suggestions you came accross?

Thanks

BrianHFASPS Post Patron
Post Patron

Re: App works in editor / preview but not published? - Bugs in Preview features!


@seadude wrote:

Having a similar issue: Unable to consistently ClearCollect a SQL View ON MOBILE DEVICE ONLY. Works fine in IDE Preview Mode and Browser Player on laptop. Super frustrating. Unfortunately, turning off Non-Blocking OnStart and Explicit Column Selection did NOT work for me. Any further suggestions you came accross?

Thanks


Sorry I don't have any other advice. For me it mostly works now. I still have problems with buttons inside a gallery stop working occassionlay and require the app be closed and re-opend (within IOS app).

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Top Solution Authors
Top Kudoed Authors
Users online (8,625)