Answered

Problem with a Sort/Filter

(0) Share

Report

Posted on by AngieH

I have a powerapp I want to modify slightly to reuse for a Thanksgiving recipe app. I have the following working in my original app

Search( 
 Sort(
 Filter( 'Share Your Recipe', DropdownRecipeType.Selected.Value = "All" Or 'Type of Dish'.Value = DropdownRecipeType.Selected.Value)
 , Modified, Descending),
 
 searchName.Text, "Tags"
 )

I added a new "number" column in my 'Share Your Recipe' list - "Thanksgiving" -- and when I add a "1" in that column, I want it to be what shows up in my gallery.

I have tried multiple ways to modify my formula, but all of them aren't working.

The logic here is - Gallery will show "All" or what is chosen in the dropdown -- but only when Thanksgiving is "1"

Any ideas how to modify my formula?

Thank you for your time!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

WarrenBelz 155,957 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @AngieH ,

Assuming "1" is textg

Search( Sort( Filter( 'Share Your Recipe', Thanksgiving = "1" && ( DropdownRecipeType.Selected.Value = "All" Or 'Type of Dish'.Value = DropdownRecipeType.Selected.Value ) ), Modified, Descending ), searchName.Text, "Tags" )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
AngieH 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you, this works perfectly!

Was this reply helpful? Yes No