Unanswered

Combobox is displaying ID when editing a record on a form.

(0) Share

Report

Posted on by Andrew311

I have a combobox with a Collection record source with fields: MotorMakeID and MotorMakeDescr. MotorMakeID is what gets stored and later patched to SQL Server.

If I click into the combobox while creating a new record, the description fields display and are selectable. After making a selection, the description field shows as selected in the combobox. And the ID field is stored. Cool.

However, If I save the form and enter the same form to do an edit on the same record- the ID field is displayed in the combo box after form load. If I click into the combobox, description is displayed and is selectable.

How can I get the combobox to display the record's description field when it loads?!

Datacard settings

Combobox settings

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

WarrenBelz 154,399 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Andrew311 ,'

Change the Default to

{Value:ThisItem.MotorMakeDescr}

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Arowe3111 2 on at

Like (0)

Report
Copy link

Link copied!

Good idea. But it says the identifier isn't recognized.
MotorMakeId is both the name of the primary key in MotorMake table and the name of the foreign key in a Motors table.

What I'm truly after is ThisItem.MotorMakeID.MotorMakeDescr However default does not like the second '.' in that formula.

Was this reply helpful? Yes No
WarrenBelz 154,399 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Arowe3111 ,

Are you using SQL here (you did not say and I assumed SharePoint)

Was this reply helpful? Yes No
Andrew311 7 on at

Like (0)

Report
Copy link

Link copied!

Yes. I recently migrated my data from SharePoint to Azure SQL database.
This app was existing and I changed the data source to Azure... now it's like I have to relearn PowerApps all over again...

Was this reply helpful? Yes No
WarrenBelz 154,399 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Andrew311 ,

Sorry, I am a SharePoint user and (as you probably suspected) the code discussed would work on SharePoint. I also just noticed you mentioned SQL in your first post. It is a matter I guess of finding the correct reference to the field.

Was this reply helpful? Yes No