Hi, PowerApps Team,
I am using the latest PowerApps version 3.18042.20. I have a field "Item_Qty" with data type of int. I would like it to have a default of null deliberately set. Otherwise, the value could be carried over from other records in different form. In the data card for this field, I used "" for the default instead of "ThisItem.Item_Qty".
This setup works out fine in the edit mode, but when I ran the app in the "Play" mode, I encountered two problems; (1) instead of null value in the field, it got a value of zero (0) showing up, and when I tried to enter a value (other than 0), it would not take it. It looked like this field would not take any input from the keyboard. This is a required field, and the form couldn't be submitted as a result.
In summary, the app in Edit mode works, and the app in "Play" mode does not work. This means I can create an app for myself, I can't share it with others. In the past I have had occasions that the behaviors of the app have been different between Edit and Play mode.
Can you offer some help?
Solved! Go to Solution.
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 @Anonymous, 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?
Check out the News & Announcements to learn more.
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Check out our new Discover Your Career Path blog post series and get all the details.