Answered

Show Highest Assigned Item of an ID with multiple records

(0) Share

Report

Posted on by MMiranda

Hi Everyone,

So i have this issue: I have a SP List that a employee can have multiple items, one of the columns of the list is a choice column, the choices are A B C D E, and so on. (A being the highest choice one can select and Z the lowest)

Lets move to the app, there I have a gallery (master SP List) that has a list of all the employees, so what I wanna do is to only show the the highest "rated" choice of my secondary gallery (i have them linked with a LookUp column).

This meaning that if an employee has 3 items on the second list, these being B, C, and E, only the item with the B choice shows. And if the employee then adds an item with a choice A, then this new item will show.

Im a newbee in PA, i have tried a few things but nothing has worked so far. Thanks in advance!

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,576 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
HI @MMiranda ,

This is structure only assuming names etc, but you need to add a column and sort by it

LookUp( Sort( AddColumns( SPListName, "Rating", YourChoiceColumn.Value ), Rating ), Employee = YourChosenEmployee )

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.

Visit my blog Practical Power Apps
MMiranda 16 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz ,

That totally worked, thank you so much!