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. 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