Clear Gallery on Click on Button

(1) Share

Report

Posted on by Prem4253

652

Hello,

I've 2 buttons i.e. Receipt Date and Status. The OnSelect expressions are set as below:

For Receipt Date:

If(
    locFilterBlankReceiptDate,
    UpdateContext({locFilterBlankReceiptDate: false}),
    UpdateContext({locFilterBlankReceiptDate: true})
);

For Status:

If(
    locFilterStatusInProgress,
    UpdateContext({locFilterStatusInProgress: false}),
    UpdateContext({locFilterStatusInProgress: true})
);

An the Items property for Gallery is set to below:

SortByColumns (
    Filter (
        'SharePoinListName',
        Or(
            !locFilterBlankReceiptDate,
            'Receipt Date' = Blank()
        ),
        Or(
            !locFilterStatusInProgress,
            Status = "In Progress"
        )
    ),
    "Modified",
    SortOrder.Descending
)

In need to have 1 more button to Clear the entire gallery.

Please advise how can this be done?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

WarrenBelz 153,117 Most Valuable Professional on at

Like (0)

Report
Hi @Prem4253,

Firstly, you can shorten the top Variables like this
UpdateContext({locFilterBlankReceiptDate: !locFilterBlankReceiptDate})

If you want to clear the entire gallery (show nothing) set this on a button
UpdateContext({varClear: true})

then the Items of the Gallery
SortByColumns( Filter( 'SharePoinListName !varClear, Or( !locFilterBlankReceiptDate, 'Receipt Date' = Blank() ), Or( !locFilterStatusInProgress, Status = "In Progress" ) ), "Modified", SortOrder.Descending )

Also at Screen OnVisible and anywhere else you need to reset this
UpdateContext({varClear: false})

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 LinkedIn Buy me a coffee

Was this reply helpful? Yes No
Prem4253 652 on at

Like (0)

Report

@WarrenBelz

Thanks! for providing the logic.

But this does not seems working as expected. On Click of clear button, the gallery does not shows any items (is returning blank gallery)

And after clicking the Clear button, when clicked on Receipt Date and Status buttons, this does not shows any records in the gallery.

Also how can we add a Search feature within the Gallery. I have a text input added (TextInput1) for searching within the gallery records.

Appreciate if you can advise with further help.

Thanks! as always for your help.

Was this reply helpful? Yes No
WarrenBelz 153,117 Most Valuable Professional on at

Like (1)

Report
@Prem4253,

That is what I thought you meant by In need to have 1 more button to Clear the entire gallery - what result do you want if not what I supplied ?

You can add a Search as below (I have omitted the Variable for now)
With( { _Data: SortByColumns( Filter( 'SharePoinListName Or( !locFilterBlankReceiptDate, 'Receipt Date' = Blank() ), Or( !locFilterStatusInProgress, Status = "In Progress" ) ), "Modified", SortOrder.Descending ) }, Search( _Data, TextInput1.Text, YourFieldToSearch ) )

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 LinkedIn Buy me a coffee

Was this reply helpful? Yes No
Prem4253 652 on at

Like (0)

Report

@WarrenBelz

Thank you once again for your quick response. I'm able to Filter and Search the gallery using the last logic provided.

Below is the screen shot of my App:

Count that we see in above image, are the 5 buttons, which we're using to filter the gallery

For instance when I click Status button, Gallery filters with 6 records.

Now the gallery is filtered with 6 records, so on click of "Clear Gallery" button, I need to reset the gallery to show all records ( i.e. all 13 records)

Similarly when I click "Receipt Date" button, gallery is filtered with 5 records. Now on click of "Clear Gallery" button, reset the gallery to show all records ( i.e. all 13 records)

My Gallery is named as galInspection.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,117 Most Valuable Professional on at

Like (1)

Report
Hi @Prem4253

You just need to set all the Variables to false on one button
UpdateContext( { locFilterBlankReceiptDate: false, locFilterStatusInProgress: false, . . . . . . } )

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 LinkedIn Buy me a coffee

Was this reply helpful? Yes No
Prem4253 652 on at

Like (0)

Report

Hi @WarrenBelz

You are always there to provide solutions to most of the requirements, which are fulfilled.

Thank you once again for providing the solution on Filtering and Clearing the Gallery.

You Solution helped. Much APPRCIATED.

Thanks,

@Prem4253

Was this reply helpful? Yes No