Hi PowerApps team
Request
It would be great to be able to enable out-of-the-box a similar lookup form for all Subgrid components with a 1:N relationship, as the one available/displayed by default when you add a Subgrid with a N:N relationship. See the screenshots below.
It would be extremely helpful if you just expose and make accessible the relationship entity when you create a 'native' N:N relationship.
Use Case
I would like to add multiple keywords to each Account record.
There are two entities: Accounts (standard) and Keywords (custom). I have tried to achieve it in two different ways...
* Note to the PowerApps Team:
(a) It sucks that you cannot access the relationship entity when you create an N:N relationship! Otherwise I would just go ahead with approach B and be done!
(b) It also unfortunate that there is no out-of-the-box multi-select drop-down for lookups! It could be a great complement to the Subgrid when you don't need to show much in a view, but only the selected records.
Below is what you get when you try to add a new related record to a Subgrid linked to a custom entity (in this case: Account_Keyword , 'manually' enabling to have the N:N relationship). The form you see is a 'Quick Create' form added to the Account_Keyword custom entity.
I would like to get a similar lookup form to add keywords to Subrid A, like the one you get in Subgrid B (automatic N:N relationship)... See screenshot below.
Would that be possible? Does someone think that would be useful?
Thank you for considering this idea.
P.S. There are some PCF components available to make a multi-select happen in your form. But hey, shouldn't this be out-of-the-box?
https://www.itaintboring.com/dynamics-crm/is-it-a-multiselect-optionset-nope-its-an-nn-lookup/
https://pcf.gallery/categories#multiselect
Best
CEPJC