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

Like (0) Share

Report

Posted on 20 Sep 2022 09:20:04 by chandra1

106

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:

General Questions

All responses (1)

Answers (1)

Verified answer

v-xiaochen-msft on 21 Sep 2022 at 02:38:17

Like (0)

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

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