I have a PONo as lookup column in project master dataverse table as 1 project can have multiple po no so in model driven app form and view I want that po lookup filed as multiselect option.
A Lookup field type is the child in a 1 to many relationship and can only hold 1 value. You would need to create a many-to-many relationship between your Project and the table with PONo, and then use a subgrid to capture the multiple records (you could improve the 'clunkyness' of associating them by applying a Code Component you can see some examples in the PCF Gallery).
note: the link in the previous response by someone else refers to having a lookup that can hold different record types (but is still limited to 1 value) to give functionality like the Customer Lookup where it can hold a Contact or a Account record but for tables of your choice.
If I have answered your question, please mark your post as Solved. If you like my response, please give it a Thumbs Up. You can accept more than one post as a solution Follow me on Linkedin, I talk about Power Platform www.linkedin.com/in/jonathan-manrique-rios
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
6
Share
Report
All responses (
Answers (
