web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps I want to filter the l...

Power Apps

Answered

I want to filter the lowest data in Sharepoint List based on employee ID.

(0) Share

Report

Report

Posted on by simplequestion

16

Hello everyone,

I have a request for help and hope to receive an answer.

I want to filters for yellow Highlight data (multiple records are recorded)
The value to be Filtered is Highlight in red (want to show the lowest value)

Datasource from Sharepoint List.

You can see the information in the attached file.

Thank you.

Screenshot 2023-11-20 093219.png

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-mengmli-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @simplequestion ,

Do you want to filter records with same employee ID which have lowest red highlight data?
Does yellow highlight data and red highlight data in two columns?
I assume yellow highlight data is employee ID column which is text type and red highlight data is saved in another ColumnB which is also text type.
Please try this:
The items of gallery:

Ungroup(ForAll(Distinct(ListName,EmployeeID) As C,Filter(Filter(ListName,EmployeeID=C.Value),Value(ColumnB)=Min(Filter(ListName,EmployeeID=C.Value),ColumnB))),"Value")

Best regards,
Rimmon
simplequestion 16 on at

Like
a
(0)

Report
Copy link

Link copied!

Great result.

Thank you Rimmon

Join the conversation