Tech Battle Field

One of my Project got a requirement to combine two Collections and Remove the Duplicates while Combining in to a single collection. For Example i have two Collections, StudentDetails - Columns StudentID, Name, Age, DateOfBirth StudentMarks - Columns StudentID, Subject1Marks, Subject2Marks, Subject3Marks Now I want to merge these two collections without having the Duplicate data. I have used following formulae to combine the two collections into new collection StudentsCollections With(    {       StudentInfo1:       ShowColumns(          'StudentDetails',           "Name",          "Age",          "DateOfBirth"       ),       StudentInfo1:       ShowColumns(          'StudentMarks',           "StudentID",          ...

In PowerApps, we can merge two collections in to one collection based on the unique value in the two collection. I had a requirement to merge two collections format as below, Employee Unplanned Leaves Data List - Collection 1 Employee ID  Employee Name  Employee Leave Date Employee Leave Applied Date Employee Unplanned Leaves Employee Planned Leaves Data List - Collection 2 Employee ID  Employee Name  Employee Leave Date Employee Leave Applied Date Employee Planed Leaves These are two different collection and we need to merge these two items based on the employee id. I have used following formula to merge the collections ClearCollect(     OutputCollection,     Collect(              AddColumns(                                       collection1,                       ...