Filter with two dropdown

(0) Share

Report

Posted on by venkatvedavyas

Hi,

I'm trying to filter item from SP list based on two dropdowns in powerapps.

First drop down is with months.

Second dropdown is with employee name.

Both the items are dropdown entries in the SP list

SP list name is Data

First dropdown is created using below formula in the powerapps dropdown item

Distinct(Data,Month.Value)

On the second dropdown. I want only the employee name having the month selected from the first dropdown. So I used below formula. But the formula is showing error.

Filter('Data','Engineer Name'.Value,(Month.Value=MonthDropdown.Selected.Result))

I need help in rectifying this.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

SkiDK 1,016 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @venkatvedavyas

Can you try it like this:
Filter('Data', Month.Value = MonthDropdown.Selected.Result).'Engineer Name'.Value

Was this reply helpful? Yes No
BCLS776 8,994 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@venkatvedavyas wrote:

Filter('Data','Engineer Name'.Value,(Month.Value=MonthDropdown.Selected.Result))

I need help in rectifying this.

We need to edit your Filter() function to work better. The 2nd and 3rd arguments need to be formulas that evaluate to true or false on specific columns for records from your table. The 2nd argument is not a formula and the 3rd argument doesn't refer to a column. Instead, try something like:
Filter(Data, 'Engineer Name' = EmployeeDropdown.Selected.Value, // Assuming Engineer Name is a text column Month(myDateColumn) = MonthDropdown.Selected.Value // Change myDateColumn to your column )

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @venkatvedavyas,

Have you solved your problem

Do you want to populate the Combo Box with the employee name based on the month selected?

Could you please tell me if a same month has different Engineer names?

1). If each month has its unique engineer, you could achieve this using 2 Dropdown box.

Set the second Dropdown Box Default property as below:

LookUp(Data,Month.Value=MonthDropdown.Selected.Result).'Engineer Name'.Value

2).If a same month may have different engineers, you should use Combo Boxes.

Set the second Combo Box DefaultSelectedItems property as below:

ForAll(Filter(Data,Month.Value=MonthDropdown.Selected.Result).'Engineer Name','Engineer Name')

Was this reply helpful? Yes No