Sample formula for Associating N:N records and Creating 1:N records in Canvas App (PowerApps / Dataverse)

Nishant RanaDyn365CE2 years ago105 Views

Just sharing the sample formula, we used for associating selected products from the gallery to lead on OnSelect of a button. Here collectionCheckedProducts contains the checked products from the gallery bound to the product data source – varEnquiryIdWithoutCurlyBraces contains the GUID of the Lead record. Here Enquiry is Lead renamed. Enquires(leadproduct_association) is the name of … Continue…

Continue Reading Nishant Rana’s Article on their blog

Sample formula for Associating N:N records and Creating 1:N records in Canvas App (PowerApps / Dataverse)

Just sharing the sample formula, we used for associating selected products from the gallery to lead on OnSelect of a button. Here collectionCheckedProducts contains the checked products from the gallery bound to the product data source – varEnquiryIdWithoutCurlyBraces contains the GUID of the Lead record. Here Enquiry is Lead renamed.

Blog Syndicated with Nishant Rana’s Permission

0 Votes: 0 Upvotes, 0 Downvotes (0 Points)

Leave a reply

Join Us
  • X Network2.1K
  • LinkedIn3.8k
  • Bluesky0.5K
Support The Site
Events
October 2025
MTWTFSS
   1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 31   
« Sep   Nov »
Follow
Search
Loading

Signing-in 3 seconds...

Signing-up 3 seconds...