Handling Duplicates and Multiple Datasources in Power Apps using Distinct and First Functions

Is handling duplicates giving you an issues with your galleries or datatables? In this video we go over using the distinct function and merging two datasources and pulling out the first set of rows with the first function, if there are duplicates. We simply merge the two tables into one large collection and then if there is a duplicate we display the first choice. We also go over a second way to merge tables which is shared by Michel Mendes: https://michelcarlo.com/2021/04/28/power-apps-merge-tables-collections-and-get-distinct-records-without-using-collect/ OnVisible of Screen Formulas: ClearCollect(colProjectList,ProjectList,ProjectList_1); ClearCollect(colDistinct,Distinct(colProjectList,Title)); First Filter Formula: First(Filter(colProjectList,Title=ThisItem.Result)).ActualWork1 Chapters: 0:00 Introduction 1:20 Adding Power App datasource 2:47 Collect multiple datasources 3:57 _x0020x replaces spaces 5:10 Using a Distinct Collection 6:01 Formula to pull in First from a Duplicate datasource 8:40 Testing the multiple datasources 10:20 Another way to handle duplication 12:39 Conclusion