Recently, while working with the Power Apps ComboBox control, I encountered a challenging issue: the ExpectedRecord value. I researched and found a very tricky solution that I will share with you.
In this tutorial, I will explain how to fix the ‘Expected Record Value’ error in Power Apps, which usually occurs when working with a Combobox control.
Refer to the image below:
Expected Record Value in Power Apps [Error]
Let’s discuss how I got this error while working with the combo box control in Power Apps.
- I have a SharePoint list [Product Issue Tracker], which has different columns like:
| Fields Name | Data type |
|---|---|
| Product ID | Title |
| Issue Type | Choice [“Washing Machine”, “Television”, “Oven”, “Refrigerator”] |
| Issue Assigned To | Person/group |
| Is Still Issue is Active | Yes/no |
| Issue Start Date | Date and time |
| Issue Resolved Date | Date and time |
- In Power Apps, there are an Edit form and a Gallery control, both connected to the SharePoint list above.
- Whenever the user clicks on an item in the gallery control, that item is displayed in the edit form.
- The edit form contains an Issue Assigned To field [SharePoint list person type column].
- In the combo box control, I tried to display the user name based on the item selected by a gallery control. I have set the combo box Default property as:
Default = varIssue.'Issue Assigned To'.DisplayNameWhere,
- varIssue = Variable name
- Issue Assigned To = SharePoint list person or group type column name
- Once I applied the code, I faced an error as “Expected Record Value” [It clearly says that it is an unexpected value; to overcome this, provide the expected value] as shown below:
Expected Record Value in Power Apps [Solved]
To overcome the error of “Expected Record Value,” follow the instructions below:
On the Power Apps edit form, select the Combo box control -> Set its DefaultSelectedItems to:
DefaultSelectedItems = Gallery1.Selected.'Issue Assigned To'Where,
- Gallery1: Gallery control name
- Issue Assigned To: SharePoint list Person/group type column name
Save, Publish, and Preview the app. When the user selects an item from the gallery control, the combo box displays the user’s name based on the selection.
This way, we will overcome this Power Apps issue.
Conclusion
I hope this Power Apps tutorial helped resolve the “Expected Record Value” error while working with the combo box control.
Additionally, you may like some more Power Apps tutorials:
- Power Apps Dropdown Values Not Showing
- Filter Power Apps Gallery Based On Combo Box Selection
- Set Combo Box Default Value in Power Apps
- Populate Distinct Values in Power Apps Combo Box
After working for more than 18 years in Microsoft technologies like SharePoint, Microsoft 365, and Power Platform (Power Apps, Power Automate, and Power BI), I thought will share my SharePoint expertise knowledge with the world. Our audiences are from the United States, Canada, the United Kingdom, Australia, New Zealand, etc. For my expertise knowledge and SharePoint tutorials, Microsoft has been awarded a Microsoft SharePoint MVP (12 times). I have also worked in companies like HP, TCS, KPIT, etc.
