Power Platform Community Forum Thread Details

I have an enitity with a lookup column. In my canvas app I have a form with a combo box that let's the user select multiple items, but when I try to submit the form the following error occurs: "Value must be a data entity record"

Is this a limitation of CDS? It works well with SharePoint lists.

Categories:

Microsoft Dataverse with Power Apps

Hi @JohnP ,

Could you show me your formula about updating looup column?

The formula is different when updating lookup column of sharepoint list and CDS.

1)update lookup column of sharepoint list

Patch(listname,Defaults(listname),Lookup(Choices(listname.lookupcolumn),fieldname in combo box1.SelectedItems.fieldname)

Here's a similar issue about this for your reference:

https://powerusers.microsoft.com/t5/Creating-Apps/Patching-to-Sharepoint-Lookup-Column/m-p/312727

2)update lookup column of CDS

Patch(entityname,Defaults(entityname),LookUp(entity2,fieldname in combo box1.SelectedItems.fieldname))

Here's a similar issue about this for your reference:

https://powerusers.microsoft.com/t5/General-Discussion/Patch-a-CDS-Lookup-column-within-PowerApps/m-p/174190

Best regards,

Community site session details

Lookup column limitations???

Helpful resources

News and Announcements

Quick Links

Introducing the 2026 Season 1 community Super Users

Kudos to our 2025 Community Spotlight Honorees

Congratulations to the February Top 10 Community Leaders!

Leaderboard > Power Apps

Featured topics

Product updates