cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BrianHFASPS
Continued Contributor
Continued Contributor

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

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
Continued Contributor
Continued Contributor

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?

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?

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
Continued Contributor
Continued Contributor


@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
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,485)