cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Terje
Regular Visitor

Filter Drop Down Box

I am working on making a time reporting app where the idea is that workers will be able to report their daily working hours linked to a specific project.  The datasource that the dropdown should collect data from is a list in Sharepoint that is called "Projectlist" and the value that must be displayed comes from the field "Title". So far I manage to retrieve the data in the drop down menu.  But, I want to filter so that the only projects the worker can choose from in the drop down menu are the projects with the status "Yes" from the field "Active" and only those projects that are assigned to the userId from the field "ProjectManager".

1 ACCEPTED SOLUTION

Accepted Solutions
hpkeong
Community Champion
Community Champion

Hi

 

DropDown.Items = Distinct(DS, Field).

DS can always be filtered using FILTER.

 

1. DropDown. Items = Distinct(Projectlist, Title).

- this show dropdown of Title from Projectlist

 

2. Modify the DS to

Filter(Projectlist, Active = "Yes" && ProjectManager = userid)

 

3. Finally, DropDown.Items = Distinct(Filter(Projectlist, Active = "Yes" && ProjectManager = userid), Title)

 

Hope this helps if I understand your fields correctly.

 

TQ

 

hpkeong

View solution in original post

6 REPLIES 6
hpkeong
Community Champion
Community Champion

Hi

 

DropDown.Items = Distinct(DS, Field).

DS can always be filtered using FILTER.

 

1. DropDown. Items = Distinct(Projectlist, Title).

- this show dropdown of Title from Projectlist

 

2. Modify the DS to

Filter(Projectlist, Active = "Yes" && ProjectManager = userid)

 

3. Finally, DropDown.Items = Distinct(Filter(Projectlist, Active = "Yes" && ProjectManager = userid), Title)

 

Hope this helps if I understand your fields correctly.

 

TQ

 

hpkeong
Terje
Regular Visitor

Thx, I understand the formula you have made.  But, I still can not make it work.  I am OK on step one, but once I start using the filter it does not work.

hpkeong
Community Champion
Community Champion

Hi

 

It is OK. Maybe my explanation and example is not user-friendly.

May you share with me your sample database and I will write exactly to solve it out, if you are OK!

 

TQ

hpkeong
Terje
Regular Visitor

OK, what e-mail address to share to?

 

Terje
Regular Visitor

I am not able to share outside the organisation.

hpkeong
Community Champion
Community Champion

Hi

 

Understood.

I can't really do much unless you make a sample table here, and put it here for me to simulate for you.

 

Thanks

hpkeong

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events that are happening this month - don't miss out!

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 Solution Authors
Top Kudoed Authors
Users online (1,837)