cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

The PowerApps app works in edit mode, but not in "Play" mode, I can't share the app

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?

 

 

66 REPLIES 66
Highlighted

CC: @AllenKim who was investigating the issue.

Highlighted

Hi @Anonymous,

 

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.

 

Thanks,

Allen

Highlighted

Hi @Jswanson

 

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.

 

Thanks,

Allen

Highlighted

I opened a ticket #118050118099541

Highlighted
Anonymous
Not applicable

Hi

 

I did what was suggested in term of updating SQL schema.

 

Still not working unfortuntely.

 

Kind regards,

Kyle

Highlighted

Hi @Anonymous,

 

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?

 

Thanks,

Allen

Highlighted

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?

Highlighted
Anonymous
Not applicable

Hi

 

That seems to have done the trick! No errors when starting app & I am seeing what I expect to see Smiley Happy

 

Thanks very much for your help.

 

Kind regards,

Kyle

Highlighted
Advocate II
Advocate II

App is working now!

Thank to the Team @Microsoft for working with me to take care of the issue.

Highlighted

@Jswanson

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?

 

Thanks!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (12,919)