Multi-select drop down for an entity whose values are fetched from other entities

[summitb]

I want to have multi-select drop down for an entity whose values are fetched from other entities in Model-based PowerApps.

[Drrickryp]

Dropdown controls cannot be multselect. You need to use a combobox control. Ref https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/controls/control-combo-box

[summitb]

I need it for the model-based PowerApps. Do you recommend anything?

[AbeSaldana]

summitb

The multi-select options is a new control in the Dynamics 365 CE and have new features,  however, the control is an option set, only a list of items that you can select more than one option. 

the following is the documentation, I have not tested, but I think this could be applicable to the CDS and Modal Driven apps. 

Documentation for Multi-Select OptionSet

hope this helps

abe.

[summitb]

Is there a way, where multi-select values are fetched from entities rather than optionset?

[AbeSaldana]

Out of the box the Multi select field type in the CDS and Dynamics 365 CE are only working with Option Sets, and your escenario will be creating a entity with the values related or not related to the source entity, that will just list the options and make the relationships. 

hope this help. 

Abe

[testasdfasfsafa]

This is crazy??  Model-Driven app don't support lookup control that allows multiple selection?? That can't be true...  If it is, yet another example of failed low-code approach that don't meet real life requirements. 😞

[Satish-Reddy]

@testasdfasfsafa  Lookup is nothing but a foreign key, so it can only store one value. 

If you want to select multiple values in lookup, then you need a sub-grid control (create many to many relationship which creates subgrids on both entity sides)

[summitb · Accepted solution]

I've figured that it can be achieved using PCF which is now available at PCF Gallery.
https://pcf.gallery/n-to-n-multiselect/

This solves my issue.

Thanks, everyone for responding.

[RadhaSamak]

Can you share the steps how to download & install NtoNMultiselect control from "https://github.com/ashlega/ITAintBoring.PCFControls/tree/master/Controls/NToNMultiSelect". I don't see any solution related files there.

Can you please share how to do this.