cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BIBC-IT
Helper I
Helper I

DISTINCT FILTER ON DROPDOWN

I tried all sorts of distinct formulas but I can't seem to find the right one. 

 

Any ideas how will I insert the distinct function to this formula?

 

Filter('Coordinators List',Status="Active",'Coordinator Email'=varLoggedInUser).Title
1 ACCEPTED SOLUTION

Accepted Solutions
theapurva
Super User
Super User

Hello,

Here I want distinct value of column 'Manager' where baselocation is Pune,

I used below formula:

Distinct(Filter(TeamDetails,BaseLocation="Pune"),ManagerName)

 So, Your Formula should be

Distinct(Filter('Coordinators List',Status="Active",'Coordinator Email'=varLoggedInUser),Title)

 

----------------------------------------------------------------------------------------------------------------------
Please 'Mark as Solution' if someone's post answered your question and always 'Thumbs Up' the posts you like or that helped you!

View solution in original post

2 REPLIES 2
theapurva
Super User
Super User

Hello,

Here I want distinct value of column 'Manager' where baselocation is Pune,

I used below formula:

Distinct(Filter(TeamDetails,BaseLocation="Pune"),ManagerName)

 So, Your Formula should be

Distinct(Filter('Coordinators List',Status="Active",'Coordinator Email'=varLoggedInUser),Title)

 

----------------------------------------------------------------------------------------------------------------------
Please 'Mark as Solution' if someone's post answered your question and always 'Thumbs Up' the posts you like or that helped you!

Thank you. It is now working. 

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Top Kudoed Authors
Users online (1,340)