Save multiselect combobox value into the lookup column in dataverse

(2) Share

Report

Posted on by Poweruser32490

I am using Appointments table in dataverse where i have created Account Name as the lookup column from the Accounts table.

I am using NewForm in canvas app where Account Name is a combobox which is getting populated from the Accounts table in dataverse

Items Property of Account Name (multiselect enabled)

Choices([@Appointments].'Account')

When i try to save multiple value using below Patch function, it throws error. It works fine when i save single value using the code ComboBox1_3.Selected.

May i know whats the issue here?

Patch code on Save

Patch(Appointments, Defaults(Appointments),{ 'Account': ComboBox1_3.SelectedItems})

Categories:

Microsoft Dataverse

I have the same question (0)

All responses (5)

Answers (0)

Vahid Ghafarpour 291 Super User 2025 Season 2 on at

Like (0)

Report

Save multiselect combobox value into the lookup column in dataverse

Because you’re trying to store multiple records into a single-valued lookup field, ComboBox1_3.SelectedItems returns a table (list of records).

Was this reply helpful? Yes No
Michael E. Gernaey 52,278 Super User 2025 Season 2 on at

Like (0)

Report

Save multiselect combobox value into the lookup column in dataverse

Hi @Poweruser32490

I want to point out, that you either way, (and using batch is possible but in your case you are NOT patching the formatted Task (appointment) you are simply trying to populate a single field (a Lookup of Account))

With Batches you cannot do this aka you cannot patch multiple at the same time unless the schema etc matches perfectly and yours does not.

Also note, that even if it did, you are creating a bunch of blank appointments with a single column populated, regardless of (and it does not) bulk worked this way or not.

Was this reply helpful? Yes No
Ram Prakash 5,520 Super User 2025 Season 2 on at

Like (0)

Report

Save multiselect combobox value into the lookup column in dataverse

Hi @Poweruser32490

In appointment, we are having this regarding field as POLYMORPHIC Field, so please try to pass the values accordingly.

Please mark as answer if my suggestion helps.
Subscribe here for More Useful videos : https://www.youtube.com/@rampprakash3991

Was this reply helpful? Yes No
Poweruser32490 20 on at

Like (0)

Report
Save multiselect combobox value into the lookup column in dataverse

Hi All,

I don't have the option to allow multiselect in the lookup column in D365 unlike sharepoint. When i try to save multiple value using below Patch function, it throws error. It works fine when i save single value using the code ComboBox1_3.Selected instead of ComboBox1_3.SelectedItems

Patch(Appointments, Defaults(Appointments),{ 'Account': ComboBox1_3.SelectedItems})

Was this reply helpful? Yes No
Suggested answer

Michael E. Gernaey 52,278 Super User 2025 Season 2 on at

Like (0)

Report

Save multiselect combobox value into the lookup column in dataverse

Hi @Poweruser32490

As I clearly stated, that is not supported, that is the answer.

If these suggestions help resolve your issue, Please consider Marking the answer as such and also maybe a like.

Thank you!
Sincerely, Michael Gernaey

Was this reply helpful? Yes No