Announcements
Hello guys!I have a gallery and I want to identify in the CC column if it has duplicate data in the same way it is done in excel. Is there a way to do this?
I need this function to fix the duplicate item.
Hi,
You might be able to leverage the fill property.
If ( CountRows ( Filter( Datasource, CC = ThisItem.CC ) > 1, Red, White )
I didn't test it but see how it goes.
Regards.
@jcfDaniel
In the Items property of the gallery, use this formula to add a number of duplicates column to your data source.
Ungroup( AddColumns( GroupBy( Datasource, "CC", "dupname" ), "dup", CountRows(dupname) ), "dupname" )
Then in the TemplateFill property of the gallery: If(ThisItem.dup>1,Red,White)
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 382 Super User 2026 Season 2
Mohsin Ali 329
WarrenBelz 187 Most Valuable Professional
