Filter Gallery

(0) Share

Report

Posted on by MiniMe_83

245

Hi,

I’m looking to filter the items listed in a gallery based on a column in a SharePoint list.

Problem being, there are duplications in the column and I only want to display the first item found.

I’ve tried looking at Distinct but I can’t seem to figure this one out.

Thanks for any help!

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Use the First function on List

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@MiniMe_83 Use the Lookup function. This is delegable whereas the First function is not.

Was this reply helpful? Yes No
MiniMe_83 245 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @zmansuri ,

Thanks for the quick response, unless I’m mistaken though, I’m not looking for the first item in the SP list, I’m after all the items in the list but not to include any items where the value in the column is duplicated.

Hopefully that makes more sense.

Thanks again

Was this reply helpful? Yes No
CU-18081211-6 9,272 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@MiniMe_83 ,

Use this formula on gallery items property:

ForAll( Distinct( YourList, Column ) As distinctByColumn, Last( Filter( Sort( YourList, ID, Descending ), Column = distinctByColumn.Result ) ) )

Hope it helps !

Was this reply helpful? Yes No
MiniMe_83 245 on at

Like
a
(0)

Report
Copy link

Link copied!

Spot on! Thanks @gabibalaban

Was this reply helpful? Yes No
MiniMe_83 245 on at

Like
a
(0)

Report
Copy link

Link copied!

@gabibalaban - Thanks again, quick query, my gallery is now displaying the correct items but there are now blank spaces where the items which don't meet criteria would have been, its like they've been hidden rather than removed......

Was this reply helpful? Yes No