Answered

Filter Gallery

(1) Share

Report

Posted on by CU28081555-1

Hi Hello,
 
SAD is my SharePoint List, displaying the items in gallery and implementing the pagination, search and filter.
Individually both functions are working, but how to combine them. Could you please help. 
 
Pagination code
-------------------
//LastN(
//FirstN(
//SAD,
//varPage
//),
//RoundDown(
//Gallery4.Height / Gallery4.TemplateHeight,
//0
//)
//)
 
//Filter and search code
Filter(
    SAD,
    Substitute(
        drp_Status.Selected.Value,
        "ALL Items",
        ""
    ) in Status.Value,
    Or(
        txt_Search.Text in 'Service Account',
        txt_Search.Text in 'App ID'
    )
)

Categories:

Using Apps Using Formulas

All responses (2)

Answers (1)

CU28081555-1 39 on at

Like (1)

Report

Filter Gallery

Hi WarrenBelz,

Thanks a lot for the information, it resolved my issue.
Verified answer

WarrenBelz 146,695 Most Valuable Professional on at

Like (2)

Report
Filter Gallery

Hi CU28081555-1

Probably something like this
LastN( FirstN( Filter( SAD, Substitute( drp_Status.Selected.Value, "ALL Items", "" ) in Status.Value, Or( txt_Search.Text in 'Service Account', txt_Search.Text in 'App ID' ) ), varPage ), RoundDown( Gallery4.Height / Gallery4.TemplateHeight, 0 ) )

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee