Dynamic AND/OR in filter

(0) Share

Report

Posted on by Gradyd

I have multiple dropdowns that I am using to filter a gallery. The problem I am having is that I can either do an && or || which limits how my users will be able to view the data. What I would like to do, and currently failing at, is create a dropdown that contains the value "And, Or" so end users can adjust how they view the data.

SortByColumns(Filter('Contoso List', Dropdown1.Selected.Value in Field1.Value Selector1.Selected.Value Dropdown2.Selected.Value in Field2.Value), "Title")

Where Selector1 is a dropdown that has the items property set to ["And", "Or"]. The error that is thrown: We expect an operator such as +, *, or & at this point in the formula.

Is it possible to create a complex dynamic query like this or is there a better/alternative method to accomplishing this?

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Rivius 269 on at

Like
a
(1)

Report
Copy link

Link copied!
It's probably getting hung up on having a variable instead of a reserved name at that point of the formula. You could achieve what you're doing by having some Switch() statements in there but it could get really hairy depending on how many fields you're dealing with.

Switch(Selector1.Selected.Value, "And",SortByColumns(Filter('Contoso List', Dropdown1.Selected.Value in Field1.Value && Dropdown2.Selected.Value in Field2.Value), "Title"), "Or",SortByColumns(Filter('Contoso List', Dropdown1.Selected.Value in Field1.Value || Dropdown2.Selected.Value in Field2.Value), "Title") )

Was this reply helpful? Yes No