Combobox selection autopopulates other fields - works in preview but not play mode.

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi all - new powerapps user here:

Currently making a canvas type app against an SQL server.

PowerApps version: 3.20082.19

I have a combobox which depending on its selection will populate the proceeding 5 datacards' values with other information from the same row in that SQL database's table. These 5 datacards are linked in their datacardvalue DATA fields using "ComboBox1.Selected.COLUMNNAME". This works fine in the preview mode - I can see the fields have this information entered however when I save, publish and play the app this feature stops working. Nothing is entered into the DB's table from these autopopulated fields in play mode either.

I have checked its the right version published etc. but other than that have no other ideas as to why it works in preview but not play.

Thank you,

Holder1001

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Do you type the whole SQL Table data source within the Items property of the ComboBox?

I assume that you typed the whole SQL Table data source within the Items property of the ComboBox, and you have added a Primary Key in your SQL Table, please try the following workaround:

Set the Items property of the ComboBox to following:

'[dbo].[YOurSQLTable]'

Set the Default property of the Text Input Box in your Edit form to following:

LookUp('[dbo].[YourSQLTable]', 'Primary Key Column' = ComboBox1.Selected.'Primary Key Column').ColumnName

...

Please try above solution, check if the issue is solved.

Regards,

Was this reply helpful? Yes No