Answered

Multiple filters on 2 lists

(0) Share

Report

Posted on by VineethKN

Hi All,

i have 2 dropdowns, which i need to check if the selected values are equal and based on that populate the 3rd dropdown, also have another level of filter on this 3rd dropdown, how can i achive this

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Sort by

svijay_001 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Can you please elaborate on your requirement ? It is little confusing.

Was this reply helpful? Yes No
svijay_001 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@VineethKN
Can you please elaborate on your requirement ? It is little confusing.

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @VineethKN

To compare the value between two dropdown selections, you can use if statement to achieve your needs:

If(Dropdown1.Selected.Result = Dropdown2.Selected.Result, true- do something , false - do something)
For the filter on third dropdown, you can modify your formula as below:

Filter(DataSource, Condition1 && If(Dropdown1.Selected.Result = Dropdown2.Selected.Result, <<Action if true>> ,<<Action if not true>>) && Condition2 )
Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
VineethKN 33 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Yashag, thanks for the reply,
am getting error which i use Filters inside if condition Invalid Argument Type: expecting one of the following : boolean, number , text
what is that am doin wrong,

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @VineethKN

Can you please share a snippet of the code/ screenshot of the error and the expression so that I can have a better look and assit you with this?

Was this reply helpful? Yes No
VineethKN 33 on at

Like
a
(0)

Report
Copy link

Link copied!

Am very new to Powerapps, so please pardon my syntax if it is wrong 🙂

SortByColumns(Filter (
RoutingMethod,
RecordId in ShowColumns (
Filter (
RoutingLink,
GBERecordId = dd_SbgGbe.Selected.RecordID
),
"RoutingRecordId"
).RoutingRecordId && Text(ActiveStatus) = "true"
) If(OriginCountry = DestCountry, Filter(RoutingMethod, RoutingType = "Both" || RoutingType= "Domestic" ), Filter(RoutingMethod, RoutingType="Both" || RoutingType = "International")), "RoutinfCode" )

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @VineethKN

Can you try:
SortByColumns ( Filter(RoutingMethod, If(OriginCountry = DestCountry,RoutingType = "Both" || RoutingType= "Domestic",RoutingType="Both" || RoutingType = "International") && RecordId in Filter( RoutingLink, GBERecordId = dd_SbgGbe.Selected.RecordID ).RoutingRecordId && Text(ActiveStatus) = "true" )

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @VineethKN ,

Based on the formula that you provided, I think there is something wrong with it.

I have made a test on my side, please consider modify your formula as below:

SortByColumns(
Filter(
RoutingMethod,
RecordId in Filter(RoutingLink, GBERecordId = dd_SbgGbe.Selected.RecordID).RoutingRecordId,
Text(ActiveStatus) = "true",
If( /* <-- Modify your If function as here: */
OriginCountry = DestCountry,
RoutingType = "Both" || RoutingType= "Domestic",
RoutingType="Both" || RoutingType = "International"
)
),
"RoutinfCode",
Descending
)

Please consider take a try with above formula, then check if the issue is solved.

More details about Filter function and If function in PowerApps, please check the following article:

Filter function

If function

Best regards,

Was this reply helpful? Yes No
VineethKN 33 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks a lot, it worked like charm

Was this reply helpful? Yes No