Adding search and sort function into my gallery

(0) Share

Report

Posted on by iknownothing

Hi Guys,

Any help of advice would be greatly appreciated.

Within the items function for my gallery I'm currently using the below formula

Switch(

varTabSelected,

'Signal Prep Sheet',

Filter(

'Signal Prep Sheet',

'Is another prep shift required?'.Value = "Yes"

Filter(

'Signal Prep Sheet',

'Is another prep shift required?'.Value = "No - Fully Prepped"

)

I would like to create the ability for users to sort and also search within the same gallery by using the below

SortByColumns(Filter([@'Signal Prep Sheet'],StartsWith('Signal ID',TextInputSearch_1.Text)),"Title",If(varSortOrder,Descending,Ascending))

My question is can I combine these functions without breaking my app or do I need to create a separate gallery to be be able to sort ascending/descending?

If it's possible to combine these functions how would I go about writing this?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

C-Papa 1,836 on at

Like (0)

Report
Copy link

Link copied!

Hi, you should be able to combine it, does this work?

SortByColumns(

Switch(

    varTabSelected,

    1,

    'Signal Prep Sheet',

    2,

    Filter(

        'Signal Prep Sheet',

        'Is another prep shift required?'.Value = "Yes"

    ),

    3,

    Filter(

        'Signal Prep Sheet',

        'Is another prep shift required?'.Value = "No - Fully Prepped"

    )

)

,"Title",If(varSortOrder,Descending,Ascending))

Was this reply helpful? Yes No
Verified answer

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Switch(

    varTabSelected,

    1,

SortByColumns(Filter([@'Signal Prep Sheet'],StartsWith('Signal ID', TextInputSearch_1.Text)),"Title",If(varSortOrder,Descending,Ascending)),

    2,

SortByColumns(Filter([@'Signal Prep Sheet'],StartsWith('Signal ID',TextInputSearch_1.Text), 'Is another prep shift required?'.Value = "Yes"),"Title",If(varSortOrder,Descending,Ascending)),

    3,

SortByColumns(Filter([@'Signal Prep Sheet'],StartsWith('Signal ID',TextInputSearch_1.Text), 'Is another prep shift required?'.Value = "No - Fully Prepped"),"Title",If(varSortOrder,Descending,Ascending))

)

Try something like that

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,

Gonçalo Nogueira

Check my LinkedIn!

Buy me a coffee!

Check my User Group (pt-PT)!

Last Post on Community

My website!

Was this reply helpful? Yes No
zmorek 3,272 on at

Like (2)

Report
Copy link

Link copied!
Might be able to tighten up the formula a bit too:

With({wDataSource: SortByColumns( Filter( ['@Signal Prep Sheet'], StartsWith( 'Signal ID', TextInputSearch_1.Text ) ), "Title",If( varSortOrder, Descending,Ascending ) ) }, Swich(varTabSelected, 1, wDataSource, 2, Filter(wDataSource,'Is another prep shift required?'.Value = "Yes"), 3, Filter(wDataSource, 'Is another prep shift required?'.Value = "No - Fully Prepped") ) )

Was this reply helpful? Yes No
iknownothing 31 on at

Like (0)

Report
Copy link

Link copied!

Thanks this worked perfect for what I'm currently doing, I really appreciate it.

Was this reply helpful? Yes No