Answered

Remove Duplicate Rows Based on a Single Column for a Gallery

(0) Share

Report

Posted on by Ephezius

Hi Power Community - I've done a lot of searching and I'm close to my solution, but I need your help to remove duplicate values. Here's my current code, which is in the items property of a gallery:

Sort(Filter(Search(Cards, SearchInput1.Text, "crd23_card", "crd23_card","crd23_controltype","crd23_data","crd23_displaytext"), ControlType = "Button"), DisplayText)

This allows a user to search for a value, and it filters to the rows I want (buttons only). It also sorts it alphabetically.

The problem is that I have a lot of duplicate values. I want to remove duplicates based on one column only (the column is called DisplayText), but every combination I use either removes duplicates based on all columns (e.g., using the ForAll command) OR it only returns one column (e.g., the Distinct command).

Can someone help me put this last step together? Thanks!

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report
@Ephezius - use GroupBy to remove duplicates. Note this function is not delegable.

With( { _grouped_data: DropColumns( AddColumns( GroupBy( Cards, "DisplayText", "GroupedItems" ), "Card", First(GroupedItems).crd23_card, "Control Type", First(GroupedItems).crd23_controltype, "data", First(GroupedItems).crd23_data ), "GroupedItems" ) }, Sort( Filter( Search( _grouped_data, SearchInput1.Text, "Card", "Control Type", "data" ), ControlType = "Button" ), Nominee, SortOrder.Ascending ) )

Was this reply helpful? Yes No
Ephezius 16 on at

Like (1)

Report

Thank you Amik! I had to make some of the column names case sensitive, but it worked! I never would have figured that out. Thanks again 🙂

Was this reply helpful? Yes No