cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
chandra1
Helper III
Helper III

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

chandra1_1-1663664950948.png 

 

FIGURE 1

 

chandra1_3-1663665455993.png

FIGURE 2

Thanks in advance.

1 ACCEPTED SOLUTION

Accepted Solutions
v-xiaochen-msft
Community Support
Community Support

Hi @chandra1 ,

 

I did a sample for you.

vxiaochenmsft_0-1663727566612.png

vxiaochenmsft_1-1663727608108.png

 

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

View solution in original post

1 REPLY 1
v-xiaochen-msft
Community Support
Community Support

Hi @chandra1 ,

 

I did a sample for you.

vxiaochenmsft_0-1663727566612.png

vxiaochenmsft_1-1663727608108.png

 

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

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Ideas

Check out the New Ideas Site

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (4,335)