cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
RiannG
Level: Powered On

Azure SQL Query and Form work in Edit/Preview, Fail in Published/Web

An app I'm working with is having some really bizarre behavior and I'm hoping someone can help me figure out what's causing it before I try and re-build the whole thing... 
 
I have an app that is using SQL (Azure SQL Server). It always works in Edit/Preview Mode, yet a SQL query on a (fairly complext) form page is always failing in Published/Web mode with one of the following issues but there's never any on-screen errors: 
1. A white (maybe light grey?) page with blue spinner flashes up and then the app bounces back to the first/home page of the app like it just re-loaded it.
2. The app errors to the blue spinner page and just stays on one of the following URLs:
3. Claim it's complete (by flipping a context variable) but then the data isn't in the collections and a form that's attached to a SQL record only shows about 1/2 of the data from the tables in the associated fields. 
 
I've tried making copies of the app and removing all Experimental and Preview features, including improved rendering, made no difference at all. I've removed all concurrent statements and the app still just won't query the data. Same behavior in Edge and Chrome. Happens with multiple accounts, computers (also tried non-organization PCs) and networks. I've tried changing from using OnVisible to an AutoStart timer, going down even to just one query. 
 
Regarding the fields on the form, if I set default by checking If(IsBlank(ThisItem.Field), "test", ThisItem.Field), It will show "test", so the form is thinking the field is null/blank. But if I do a ClearCollect(SQL, ID = varID) for row, the collection or even variable I pull the row in to does show all the data fields. 
 
Also, this behavior wasn't happening before the Azure crash last week, which is probably a coincidence, but at this point I'm just at a loss on how to what to even try next and I really would like to avoid rebuilding this form or even app if I can help it.
 
Session Details, if MS folks can help: 
Session ID: 0d9313fc-8d8f-4c94-a76a-902e874a378d
PowerApps 3.19045.12
1 ACCEPTED SOLUTION

Accepted Solutions
RiannG
Level: Powered On

Re: Azure SQL Query and Form work in Edit/Preview, Fail in Published/Web

Unfortuantely I wound up just rebuilding the app from scratch and simplfying it quite a bit (it was dealing with a lot of data connections and I wondering if it was just too many collections, etc).

3 REPLIES 3
Community Support Team
Community Support Team

Re: Azure SQL Query and Form work in Edit/Preview, Fail in Published/Web

Hi @RiannG 

 

Is your issue already exisits?

 

Best Regards.

Yumia

Administrator
Administrator

Re: Azure SQL Query and Form work in Edit/Preview, Fail in Published/Web

Hi @RiannG are you still experiencing these issues? 

 

@TopShelf-MSFT 

RiannG
Level: Powered On

Re: Azure SQL Query and Form work in Edit/Preview, Fail in Published/Web

Unfortuantely I wound up just rebuilding the app from scratch and simplfying it quite a bit (it was dealing with a lot of data connections and I wondering if it was just too many collections, etc).

Helpful resources

Announcements
firstImage

PowerApps Monthly Community Call!

Join us next Wednesday for our Demo Extravaganza, October 16, 2019 8am PDT.

firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 4 members 5,094 guests
Please welcome our newest community members: