Answered

Filtering duplicatish items

(0) Share

Report

Posted on by Kai Adler

Hi community.

in my app i got a gallery displaying items from a sharepoint list. in my sharepoint list i got columns like MachineType, MachineId and Cycle and want to filter the data that way, that only 1 item of each MachineType-MachineId-Cycle Combination is displayed, ideally the last one added. do you have any idea how to accomplish that?

Help much appreciated, thanks in advance ❤️

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

WarrenBelz 153,737 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @KAdler ,

Try

GroupBy( Sort( SPList, ID, SortOrder.Descending ), MachineType, MachineId, Cycle, Grouped )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Kai Adler 46 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz: Thanks for your quick reply. Looking good so far, but i can't group by Cycle. I guess it's related to it being at selection type column in the SP list. Neither Cycle not Cycle.Value got accepted. Is there any workaround?

Was this reply helpful? Yes No
Kai Adler 46 on at

Like (0)

Report
Copy link

Link copied!

Found a workaround by using AddColumns to add the Value of the choice column to the data. Afterwards i can GroupBy that new column. 🙂

Was this reply helpful? Yes No
WarrenBelz 153,737 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @KAdler ,

Yes that is exactly the workaround - you can only group by Text columns.

Was this reply helpful? Yes No