Hello, I already saw a couple of questions about this and I can't seem the right workaround for this, I have a canvas app and a screen with an input Project form, and one of the fields it's a Vehicles lookup field to Vehicles tables and I need to select multiple values from this list and save it as one record in the Project table.
Is the only way to create a many to many relationship and actually add the required fields from project in the new table for this relationship, or also I saw there is a way to select the lookup field and allow multiple select but at the end in the Dataverse table i only have the last value chosen from the lookup field.
What is the best practice for this, how to achieve it?

Report
All responses (
Answers (