Imagine a case where you have two tables/collections in a Power Apps canvas app, and you want to merge those tables in a single one to be used somewhere else. The common practice is to use collections and to collect all data from those tables in a new collection.
The problem of this approach
If this collection is used in a single place, with no data editing need, an additional third…
Continue Reading Michel Mendes’s Article on their blog
Power Apps: Merge tables/collections and get distinct records (without using Collect) – michelcarlo
Imagine a case where you have two tables/collections in a Power Apps canvas app, and you want to merge those tables in a single one to be used somewhere else. The common practice is to use collections and to collect all data from those tables in a new collection.
Blog Syndicated with Michel Mendes’s Permission
More About This Author

-
SharePoint and Office 365 Consultant/Developer always trying to get the best from Microsoft stack (Microsoft 365/Azure/Power Platform and related stuff).
Living in Ireland since 2018, I had previously worked in Brazil as a consultant/developer for Office 365, SharePoint and related technologies for almost 10 years.
Array
ModernWorkplace2022.07.16Moving a Canvas app into a solution and keeping the associated URL and ID in different environments
ModernWorkplace2022.06.08Updating list views JSON formatters for a SharePoint list using Power Automate
ModernWorkplace2022.05.19SharePoint lists custom View and Edit Buttons using JSON Formatting
ModernWorkplace2022.05.14Power Apps: Patch data from the Office 365 Users connector to a SharePoint multi-user field without using collect