Power Platform Community Forum Thread Details

Gallery items pagination integration with filter

Hi Hello,

OU-Access-Info is my SharePoint List, displaying the items in gallery and implementing the pagination, and filter.

Individually both functions are working, but how to combine them. Could you please help. 

/*LastN(
    FirstN(
        'OU-Access-Info',
        varPage
    ),
    RoundDown(
        GalleryAdmin.Height / GalleryAdmin.TemplateHeight,
        0
    )
)*/
If(
    drpFilterClause.Selected.Value = "Primary Owner",
    Filter(
        'OU-Access-Info',
        Substitute(
            comFilterOptions.Selected.Value,
            "Access",
            ""
        ) in 'Primary Owner'.DisplayName
    ),
    If(
        drpFilterClause.Selected.Value = "AD Account",
        Filter(
            'OU-Access-Info',
            Substitute(
                comFilterOptions.Selected.Value,
                "Access",
                ""
            ) in 'AD-Account'
        ),
        If(
            drpFilterClause.Selected.Value = "OU Path",
            Filter(
                'OU-Access-Info',
                Substitute(
                    comFilterOptions.Selected.Value,
                    "Access",
                    ""
                ) in 'OU Path'
            ),
            If(
                drpFilterClause.Selected.Value = "Secondary Owner",
                Filter(
                    'OU-Access-Info',
                    Substitute(
                        comFilterOptions.Selected.Value,
                        "Access",
                        ""
                    ) in 'Secondary Owner'.DisplayName
                ),
                If(
                    drpFilterClause.Selected.Value = "Reason for Access",
                    Filter(
                        'OU-Access-Info',
                        Substitute(
                            comFilterOptions.Selected.Value,
                            "Access",
                            ""
                        ) in 'Reason for Access'.Value
                    )
                )
            )
        )
    )
)

Categories:

Using Apps Using Formulas

Switch( drpFilterClause.Selected.Value, "AD Account", Filter( 'OU-Access-Info', Substitute( comFilterOptions.Selected.Value, "Access", "" ) in 'AD-Account' ), "OU Path", Filter( 'OU-Access-Info', Substitute( comFilterOptions.Selected.Value, "Access", "" ) in 'OU Path' ), "Secondary Owner", Filter( 'OU-Access-Info', Substitute( comFilterOptions.Selected.Value, "Access", "" ) in 'Secondary Owner'.DisplayName ), "Reason for Access", Filter( 'OU-Access-Info', Substitute( comFilterOptions.Selected.Value, "Access", "" ) in 'Reason for Access'.Value ), 'OU-Access-Info' )

Quick Links

Leaderboard