Merging SharePoint List Items with same Id into a single Item through Power Apps.
Hello Wonderful community,
I am working on a solution where we have multiple items in SharePoint with ID(default ID), AssessmentID, Name,
Now have taken this into Power Apps collection and All I am trying to achieve is loop through all items and take the items with same assessmentID and if there are three assessment ID's take their Interviewer name and added the name to ID 1 row under InterviewerName2 column.
Please have a look at the Figure 1 and want to achieve as Figure 2