Selecting Multiple values from lookup fields

[Anonymous]

Hi Experts,

I am new to the Power Apps Portal. I have a requirement where I need to select multiple values from a lookup field. I tried rendering the lookup as a dropdown using Entityform metadata and then using some jQuery plugins, I was able to add multiple selection to the dropdown. I have used the lookup field on a form and I am able to select multiple values from the lookup field. But on submitting the form, multiple values are not added to the data-value of the lookup field on the entity list. Instead only the first selected value from the lookup field gets added.

Could anyone please help me out on how this could be achieved?

Thanks in advance

[chleverenz]

Hi @Anonymous ,

I'm afraid, this can not be achieved.

When i got it right, you have a lookup on your form. This lookup in the crm points to one entry in another entity.

To add more than one entity you need an m-n relation between the entities.

In Portal, this would a kind of subgrid.

But as far as i know, there is no out of the box way to add more than one entry to a subgrid at a time.

As this is a frequent request also from our customers, i usually make a (yes dirty) workaround: i have an additional textfield which is on the form (and set to display=none) where i put a list of the ids to be linked to in. Then i have a plugin, which reads the field and relates the entities.

If somebody has a better approach, please comment 🙂

Have fun,

  Christian

[Anonymous]

Hi,

Thank you for the reply. I can share my exact requirement, if anyone could help me achieve this, I would be really grateful.

The requirement is to bind the values from organization entity list displayed in one web page, as a dropdown with multiple selection in another web page to allow users to select multiple organizations. As shown below, I have an Organization web page which displays the entity list from a custom entity called "Organization".

I have used lookup field for Organization entity list and have rendered it as a dropdown using the EntityForm Metadata and using some jQuery Plugin I was able to add multiple selection for the lookup in a web page called Add Account in the "Contact" entity as shown below.

 

I am able to select multiple organizations in the form. But after form submission, in the entity list only the first selected option from the dropdown gets added.

I would be grateful if anyone could suggest me if there is any other ways to achieve this requirement.

Thanks

[Anonymous]

Hi @Anonymous, 

I also have the same requirement and am also new to Portal. Could you pls share the steps and jquery code to show the lookup fields where we can do multiselect?

Any help would be appreciated.

Thanks in advance. 

[Anonymous]

Hi @Anonymous could you pls share the JQuery sample code using which u were able to get the lookup field as multiselect . I have the same requirement which am struggling to get it done as am new to the portal and UI stuff.

Thanks

Geetha