How to Filter out data in power apps using table/list

(0) Share

Report

Posted on by kaushalsahi

Hi Team

I have one table for eg:

City Code Sate

Mumbai 12 MAH

Bangalore 13 KK

Chandigah 14 PB

Now i have created two dropdowns one to choose City and another to choose Code after choosing the same i have placed one button (on clicking the same ) i should get State as result on some different label.

Please address here with query

Categories:

Using Apps Using Formulas

All responses (2)

Answers (1)

kaushalsahi 12 on at

Like (0)

Report

Re: How to Filter out data in power apps using table/list

that's really helped me thanks ...As I am at beginner level ...thanks for supporting appreciated
Verified answer

LuizVicente 984 Super User 2024 Season 1 on at

Like (1)

Report
Re: How to Filter out data in power apps using table/list

I replicated your data in a collection:

ClearCollect( ColCities, { City: "Mumbai", Code: 12, State: "MAH" }, { City: "Bangalore", Code: 13, State: "KK" }, { City: "Chandigah", Code: 14, State: "PB" } )

CityDropdown.Items:

CodeDropdown.Items:
You don't need to filter like this, I just did it this way to return the correct city code.

Button.OnSelect:
Set(gblState, LookUp(ColCities, City = Dropdown1.Selected.City And Code = Dropdown1_1.Selected.Code, State)) // or UpdateContext

Label.Text:

Final result: