cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RiannG Advocate II
Advocate II

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 Advocate II
Advocate II

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).

View solution in original post

3 REPLIES 3
Community Support
Community Support

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

Hi @RiannG 

 

Is your issue already exisits?

 

Best Regards.

Yumia

TopShelf-MSFT Community Champion
Community Champion

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 Advocate II
Advocate II

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).

View solution in original post

Helpful resources

Announcements
secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

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,066)