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

View solution in original post

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

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 269 members 6,525 guests
Please welcome our newest community members: