Merging SharePoint List Items with same Id into a single Item through Power Apps.

(0) Share

Report

Posted on by chandra1

106 Power Up Champ - 2025

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

FIGURE 1

FIGURE 2

Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @chandra1 ,

I did a sample for you.

Ungroup(ForAll(Filter(AddColumns(GroupBy(Col1,"assessmentID","Test"),"Num",CountRows(Test)),Num=3) As temp,Filter(LIST276,assessmentID=temp.assessmentID)),"Value").InterviewerName

Best Regards,

Wearsky

Was this reply helpful? Yes No