Lookup column limitations???

(0) Share

Report

Posted on by JohnP

543

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.

I have the same question (0)

All responses (1)

Answers (0)

v-yutliu-msft on at

Like (0)

Report
Re: Lookup column limitations???

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,

Was this reply helpful? Yes No