cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ahhollan
Post Patron
Post Patron

Expected record value error

I have a datacard on a form that has a dropdown box in the card. I can't resolve the 'Expected record value' error message in the card. My formula for default is thisitem.location.  Any thoughts would be appreciated.

13 REPLIES 13

SharePoint list is the data source. Column type is single line of text. Drop down is fed by another SharePoint list.

Hi @ahhollan ,

 

What does the sentence mean that the dropdown is fed by another SP list? I just found the Items property is not from sharepoint list.

If the Location is single line of Text, I don't think the Default property needs a record. Could you please share some screenshots of location column property in SharePoint list?

 

Sik

I misspoke on the field being fed by another SP list. The choices in the field are defined as shown in the screenshots previously loaded. I've attached a photo of the SP Location column property.

Hi @ahhollan ,

 

OK, I got you. 

I just made a test based on your description and codes, but don't have any issue.

Could you please follow my steps and try again?

1. refresh your SharePoint connection, create a new EditForm 

2. Unlock the Location Data Card, delete the original Text box and add a combobox

3. DataCard.Update: ComboboxName.Selected.Value , DataCard.Default: ThisItem.Location

4. ComboBox.Items: ["-","KOC","COC"], ComboBox.DefaultSelectedItems: {Value:Parent.Default}

5. ErrorMessage.Y: ComboboxName.Y + ComboboxName.Height

Please let me know the test result.

Sik

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (3,150)