Announcements
I am creating a Canvas app with Dataverse as a data source. In the table, I have a lookup column. I am able to select the multiple values from Combobox in the Canvas app but in the table, only one value is getting stored. What is the workaround for this issue?
@SharePointDev12 - I assume you're using a Patch function? Could you share your code.
Hi @SharePointDev12,
You can use the following formula to patch your Dataverse table with the selected combo box items.
Patch( TableName, Defaults(TableName), // If You Want To Create A New Record Else It Is Not Required { FieldName: FieldValue, // Other Field To Update Or Add ChoicesColumnName: ChoicesDataCardName.SelectedItems } )
If you found my answer helpful, please consider giving it a thumbs-up or a like. Your feedback is greatly appreciated!
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Talha_Dar
I wrote the same formula In the dataverse table, the column is the lookup column, and when I select multiple values only one value is getting saved into the table columnthanks
The lookup column creates a many-to-one relationship, which means you cannot save multiple records in a single lookup column. Each value in the lookup column can reference only one item from the target list or data source. If you need to associate multiple records, you would need to create multiple lookup columns or use a different approach like using a multi-value choice column or creating a separate junction table to handle the relationship.
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 337 Most Valuable Professional
11manish 173
Valantis 86
