Expected record value error

Like (1) Share

Report

Posted on 30 Mar 2020 14:32:02 by ahhollan

576

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.

All responses (14)

Answers (1)

mpfeng 38 on 15 Feb 2024 at 16:49:05

Like (0)

Report

Re: Expected record value error

Thanks a lot! I got the same error and this fixed the issue!
I already did the same except setting the DefaultSelectedItems to {Value:Parent.Default} for the Combobox. This was the key part!
Verified answer

v-siky-msft on 02 Apr 2020 at 02:45:27

Like (7)

Report

Re: Expected record value error

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
ahhollan 576 on 01 Apr 2020 at 12:02:03

Like (0)

Report

Re: Expected record value error

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.

Location SP colum...
v-siky-msft on 01 Apr 2020 at 02:30:48

Like (0)

Report

Re: Expected record value error

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
ahhollan 576 on 31 Mar 2020 at 12:57:07

Like (0)

Report

Re: Expected record value error

SharePoint list is the data source. Column type is single line of text. Drop down is fed by another SharePoint list.
v-siky-msft on 31 Mar 2020 at 07:51:56

Like (0)

Report

Re: Expected record value error

Hi @ahhollan ，

What is the kind of data source?
What is the type of location column?
Sik
ahhollan 576 on 30 Mar 2020 at 17:18:11

Like (0)

Report

Re: Expected record value error

see attached for field properties.

location3.jpg
ahhollan 576 on 30 Mar 2020 at 16:44:43

Like (0)

Report

Re: Expected record value error

see screenshot. It's actually with both Default and Update. Sorry for the confusion.

location2.jpg
ahhollan 576 on 30 Mar 2020 at 16:41:14

Like (0)

Report

Re: Expected record value error

the problem is actually with the update property and not the default property.
ahhollan 576 on 30 Mar 2020 at 16:40:27

Like (0)

Report

Re: Expected record value error

still not working.

location.jpg