Answered

How to filter a row in the list, based on 3 dropdown?

(0) Share

Report

Posted on by blabla70

Hi, I need to filter the the row from SP List, based on 3 given columns, that have been chosen via dropdown in the app.

The sharepointList data-source has the following columns: Country, Town, Service and Owner. First 3 columns are connected to dropdown.
I need to pull the value of Owner, based on the selected-dropdown and display it.

Thank you in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

LaurensM 12,516 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @blabla70,

The following code will search your list for a matching record if all dropdowns have a value and display it on a label.

Text property a label:
If( //Check if all dropdowns have a selection !IsBlank(DropdownCountry.Selected) && !IsBlank(DropdownTown.Selected) && !IsBlank(DropdownService.Selected), LookUp( //Change to the correct list name LISTNAME, //Adjust column names and dropdown names where necessary Country = DropdownCountry.Selected && Town = DropdownTown.Selected && Service = DropdownService.Selected ).Owner )
If Dropdown.Selected does not work (comparing value to a record error) try adding the field name as well. For Country this would be Country = DropdownCountry.Selected.Country

If Owner is a person field, you might need to add .DisplayName at the end as well: ...).Owner.DisplayName

If this solves your question, would you be so kind as to accept it as a solution.
Thanks!

Was this reply helpful? Yes No
blabla70 on at

Like (0)

Report
Copy link

Link copied!

The syntax works, thanks for the good explanation. Just one thing, The user has to guess the right combination of the dropdown values, otherwise it doesn't work.
I would need the first dropdown to filter the second, and the second to filter the third. So that it is not possible to select the town that doesn't belong to the country for example.
Can you help me with that?

Was this reply helpful? Yes No