cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
shaneOZ
Level 8

Galley filter not working on 2nd gallery

I have two browse gallerys in one of my apps

 

the code for the inital browsegallery screen is 

FirstN(SortByColumns(Filter(Expenses,StartsWith(Title, TextSearchBox1.Text)),"Created",
        If(SortDescending1, Ascending, Descending)),
    50)

And it works as expected however the 2nd gallery screen i cannot use the same filter?

 

i get the following error? the function "if" has some invalid arguments

 

How do i go about this?

 

3 REPLIES 3
panand99
Level 10

Re: Galley filter not working on 2nd gallery

@shaneOZ 

 

Is this second gallery nested in first gallery?

 

what is your exact formula where you getting error?

shaneOZ
Level 8

Re: Galley filter not working on 2nd gallery

No the 2nd gallery is in a second screen, the second gallery is for a quick display of images and dates.

 

The error is within the formula shown above both formulas are the exact same

Anonymous
Not applicable

Re: Galley filter not working on 2nd gallery

Hello @shaneOZ ,

 

If your formulas are the same that explains your error : 
You try to sort your gallery (SortByColumns function) on Created column.

Does this column exists in your second gallery ? Otherwise, just drop the function, not really usefull on images I think.

 

Regards,

 

Louis 🙂

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (5,446)