Answered

Remove Duplicate from Gallery

(0) Share

Report

Posted on by wass

how can we remove duplicates from a gallery without using Distinct function because I'm building a 3 nested gallery 1st will show only created by name, the 2nd ID of the request, 3rd details.

Distinct function is limiting the second gallery ?

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @wass :

If you are worried about the loss of other fields after using the Distinct function, I suggest you use these methods.

Method1: ForAll+Distinct+Lookup

ForAll( Distinct( YourDataSource, TheNameColumn ), LookUp( YourDataSource, TheNameColumn= Result ) )

Using this method for deduplication, both in accordance with TheNameColumn this column deduplication can also make the return value maintain the original data structure

Method2:Groupby

GroupBy( YourDataSource, "TheNameColumn", "NewGroup" )

This method is to group according to a certain field. It will change the data structure of the return value, but it can ensure the integrity of the data.

I think these links will help you a lot:

ForAll function in Power Apps

GroupBy and Ungroup functions in Power Apps

Best Regards,

Bof
wass 61 on at

Like
a
(0)

Report
Copy link

Link copied!
it did worked but when I'm using the below formula on the second gallery it doesn't show any data do you know why?
Filter('Purchase Forum',Title=PrimaryGallery.Selected.'Created By'.DisplayName)
@v-bofeng-msft
sonam1996sahoo 143 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank You @v-bofeng-msft 🤗