cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Responsive Resident
Responsive Resident

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
Highlighted
Skilled Sharer
Skilled Sharer

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?

Highlighted
Responsive Resident
Responsive Resident

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

Highlighted
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
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (7,431)