Share
Report
2I have a form I use for both adding and editing records. The form is based on a collection that is collected from Azure SQL Server. I recently migrated from SharePoint to Azure in this PowerApp.
When I submit the new record and form it patches the motors as a new record to Azure table and MotorMake field is stored correctly as a number (MotorMakeID).
When I pull up the record in edit mode- the combobox MotorMakeID is displayed- so no combobox record is being pulled up. I have to reselect in the combobox to restore the selection I made in New mode.
I will illustrate below...
Submitted form- Patched new motor record with correct MotorMakeID=6 (numeric) in Azure table .
The collection refreshes to azure table with ClearCollect.
When I open the form in edit- the default value for the motor make combo is the ID number =6.
Here are the combobox settings
I've tried playing around with DefaulSelectedItems but haven't had any luck.
Any ideas out there? I'm very stuck on this.
Thanks!
All responses (
Answers (
