Looking at your session, it looks like we do make a blocking OnStart call. I see an error returned by the call to your SQL connection. The SQL service is returning an error status 400 and returns an error message "The column 'Col...tus' of the table wasn't found." Please note that I removed the middle part of your column name.
Can you try refreshing your data source in the authoring experience (View tab in the ribbon -> Data sources button -> '...' next to your SQL data source -> Refresh). This will grab the latest schema of your SQL table, as it seems that the schema your app has may be out of sync.
Thank you for providing the session IDs. I looked at both of the sessions and based on the telemetry, it looks like we are still not blocking on the OnStart rule finishing even though you added a 'Navigate()' function call to the end of the OnStart rule. Rather than going back and forth, it would be great if we can just work directly to investigate the issue. Would you be willing to create a support ticket to make this possible? If so, please go to https://powerapps.microsoft.com/support/ and click on the "Create support ticket" at the bottom of the page to get started. I'll contact the folks that look at the incoming tickets to be sure to route the ticket to me when they see it.
I am investigating why the call to get your items from certain SQL tables is returning errors about columns not being found. Just looking through some past calls to your SQL tables, I can see that there are failed calls as well as successful calls (but the failed calls outweigh the successful ones). If you refresh your SQL tables after the app is loaded, does the data load without errors?
Hi @kyle705, I believe you have a ticket open for the failing SQL calls. I chatted with my colleague who is looking at your ticket and it seems like that is the issue that is blocking your app right now. Can you see if the Explicit Column Selection app setting is enabled for your app? You can find this app setting by opening your app for edit then going to File -> App settings -> Experimental features -> Explicit Column Selection. If it is enabled, can you try disabling this setting, saving, publishing, and opening the app again?
That seems to have done the trick! No errors when starting app & I am seeing what I expect to see
Thanks very much for your help.
I am having a similar problem to yours.
In play mode my dropdowns populate fine. In the published mode the dropdowns are empty.
What did you do to correct the problem?
Read the announcement for more information!
Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.
Features releasing from October 2019 through March 2020
Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications