cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bitgalicia
Helper I
Helper I

Filter

How can I filter a table to only show me the repeating field1 records

Products ----------------- filter -------------- Resulting table
field1 field2                                                    field1 field2
1         3                                                            2        4
1         4                                                            5        4
2         4                                                            6        3
3         3
3         4
5         4
6         3

4 ACCEPTED SOLUTIONS

Accepted Solutions
KrishnaV
Community Champion
Community Champion

Hi @bitgalicia ,

 

try this below:

 

ClearCollect(colls1,GroupBy(collSampleData,"Field1","Field2")); // dummy collection for grouping

ClearCollect(colls2,AddColumns(colls1, "Count", CountRows(Field2)) ,GroupBy(collSampleData,"Field1","Field2")); // dummy collection for count the repetation

Clear(collFinal);//Final collection with the desired output
ForAll(Filter(colls2,Count=1),Collect(collFinal,{Field1:Field1,Field2:First(Field2).Field2})); 

Clear(colls1);
Clear(colls2);

 

In the above code, collFinal has the required output.

 

Note: I have tested this thoroughly and it is working seamlessly as expected.


I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.


I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
KrishnaV
Business Applications MVP, Microsoft Certified Trainer
Twitter | Linkedin | YouTube | GitHub
If this post helps you give a and if it solved your issue consider Accept it as the solution to help the other members / new members of the community.

View solution in original post

Hi @bitgalicia ,


I just want to follow up with you on this issue to see is it resolved or still you see any challenges.

If you see any challenge/need further help let me know I am always happy to help.

Regards,
Krishna
If this post helps give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more


I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
KrishnaV
Business Applications MVP, Microsoft Certified Trainer
Twitter | Linkedin | YouTube | GitHub
If this post helps you give a and if it solved your issue consider Accept it as the solution to help the other members / new members of the community.

View solution in original post

Hi @bitgalicia ,

 

I just want to follow up with you on this issue to see is it resolved or still you see any challenges.

If you see any challenge/need further help let me know I am always happy to help.

Regards,
Krishna
If this post helps give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more


I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
KrishnaV
Business Applications MVP, Microsoft Certified Trainer
Twitter | Linkedin | YouTube | GitHub
If this post helps you give a and if it solved your issue consider Accept it as the solution to help the other members / new members of the community.

View solution in original post

Thanks for giving me the solution.It works perfectly. Regards

View solution in original post

4 REPLIES 4
KrishnaV
Community Champion
Community Champion

Hi @bitgalicia ,

 

try this below:

 

ClearCollect(colls1,GroupBy(collSampleData,"Field1","Field2")); // dummy collection for grouping

ClearCollect(colls2,AddColumns(colls1, "Count", CountRows(Field2)) ,GroupBy(collSampleData,"Field1","Field2")); // dummy collection for count the repetation

Clear(collFinal);//Final collection with the desired output
ForAll(Filter(colls2,Count=1),Collect(collFinal,{Field1:Field1,Field2:First(Field2).Field2})); 

Clear(colls1);
Clear(colls2);

 

In the above code, collFinal has the required output.

 

Note: I have tested this thoroughly and it is working seamlessly as expected.


I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.


I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
KrishnaV
Business Applications MVP, Microsoft Certified Trainer
Twitter | Linkedin | YouTube | GitHub
If this post helps you give a and if it solved your issue consider Accept it as the solution to help the other members / new members of the community.

Hi @bitgalicia ,


I just want to follow up with you on this issue to see is it resolved or still you see any challenges.

If you see any challenge/need further help let me know I am always happy to help.

Regards,
Krishna
If this post helps give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more


I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
KrishnaV
Business Applications MVP, Microsoft Certified Trainer
Twitter | Linkedin | YouTube | GitHub
If this post helps you give a and if it solved your issue consider Accept it as the solution to help the other members / new members of the community.

Hi @bitgalicia ,

 

I just want to follow up with you on this issue to see is it resolved or still you see any challenges.

If you see any challenge/need further help let me know I am always happy to help.

Regards,
Krishna
If this post helps give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more


I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
KrishnaV
Business Applications MVP, Microsoft Certified Trainer
Twitter | Linkedin | YouTube | GitHub
If this post helps you give a and if it solved your issue consider Accept it as the solution to help the other members / new members of the community.

Thanks for giving me the solution.It works perfectly. Regards

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

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 Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,924)