Unanswered

Combobox multiple selection - error when submitting

(0) Share

Report

Posted on by JohnP

543

I have a canvas app that uses CDS as a data source. I have an entity with a lookup field - "Areas". In one of my forms I have a combobox which I have enabled multiple selection of "Areas". This works well, but when I submit the form I get an error: "Value must be a data entity record"

So it seems it expects a single selection even if multiple selection is enabled? Is this a limitation of CDS? This works fine if I use SharePoint as a data source.

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

v-yutliu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @JohnP ,

The lookup column in CDS is different from lookup column in sharepoint list.

The lookup column in CDS means one-to-many relationship.

And one lookup column can only correspond to one related entity, which means that it is a single selection.

Here's a doc about lookup column in CDS for your reference:

https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/data-platform-entity-lookup

What's more, the formula that is used to update lookup column in CDS is also different from that to update lookup column in sharepoint list.

I've noticed that you've posted a similar issue. I've listed formulas that you should use, plese refer this:

https://powerusers.microsoft.com/t5/Common-Data-Service-for-Apps/Lookup-column-limitations/td-p/352199

Best regards,
JohnP 543 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-yutliu-msft ,

Thanks for your reply/pointers. For my project this is a setback as I'm moving it from SharePoint lists to CDS. I need to figure out a workaround on how I edit/store multiple selections (some other interface/control than comboboxes). I see that you can create all kinds of relations on an entity (many-to-one, one-to-many etc), but they don't seem to help in my case.
There are also issues with forms not retaining default value of comboboxes (single selection), on some screens it works and on others it doesn't. I will make a separate thread about it.
v-yutliu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @JohnP ,

Yes, the lookup field is a little different between Sharepoint list and CDS.

In CDS, the lookup field is mainly used to react relationship.

Only one-to-many and many-to-one relationship will result in a lookup column.

While in your case, I think the two entities' releationship is many-to-many.

This relationship will not result in a lookup column. You just need to add relationship between the two entities.

This can not be populated automatically. You could only add relationship manually.

Best regards,