ComboBox.Selected.'value' Works in Preview but not in Live Play Mode

[grock]

I ran into an interesting issue this morning where displaying the contents of a column on a selected row works in preview mode, but not in live Play mode.  The source data is from a simple two-column table in an Azure SQL database with approximately 100 rows.  Column A is selected using a combo box.  Column B is returned into a view only text box.  The Default for the view only text box for column B is set to: 

ComboBox.Selected.'B'

 I can select a value for A in the combo box, and it runs the corresponding value for B while in preview mode.  However, I get nothing in Live play mode.  The Text Box for B remains blank for any value of A selected in the Combo Box.  There are no null or blank cells in the database for columns A or B.  I tried the PowerApps Desktop App, Android Mobile App, Chrome, and Edge.  I've cleared cache and cookies.  I can work around this with a Lookup statement, but does any know why referencing ComboBox.Selected.B doesn't work in live play?

[PowerAddict · Accepted solution]

So a couple of things that you can try: 

1. If you have the Explicit Column Setting turned on, turn it off and see if it makes a diff. This can be found in FIle->Settings->Advanced Settings->Preview
2. Add a gallery somewhere in the app and set its data source to the SQL table. Add two labels in the gallery - one with the Text property set to ThisItem.A and the other one with ThisItem.B

I believe the 2nd suggestion above will help you but let me know if it doesn't. 

---
If you like this reply, please give kudos (Thumbs Up). And if this solves your problem, please mark this reply as a solution by selecting Accept as Solution. This makes it easier for others to find answers to similar questions. 

Thanks!

Hardit Bhatia

Microsoft Business Applications MVP

Blog | Twitter | LinkedIn | Facebook | YouTube  |  Email

[snaefellnes]

Hello @grock ,

Have you found a solution to your problem? I have the same issue and ran out of things to check,

Regards,

Eric

[snaefellnes]

Thank you @PowerAddict , just found out that your first suggestion solve my case of the problem!

[PowerAddict]

Glad I could help! Good luck with the rest of the app! Feel free to reach out in case of any questions!

Thanks!

Hardit Bhatia

Microsoft Business Applications MVP

Microsoft Certified Trainer MCT

Blog | Twitter | LinkedIn | Facebook | YouTube  |  Email

[grock]

@snaefellnes I stuck with using a LOOKUP statement to return the values.