Power Apps

Reset Gallery but unselect item

(2) Share

Report

Posted on by Tanners_PP

Hi!

I have a display gallery with the following Items property:

With({_items:AddColumns('PSMC Cover Pods',"dname",Name.DisplayName)},

SortByColumns(
Filter(_items,Len(TextInput2.Text)=0 ||
TextInput2.Text in dname
),"dname", SortOrder.Ascending))

I have a button with Reset(Gallery1). However when I reset the Gallery it goes back and selects the first record.

To solve this, I put {} in the Gallery Default Property. Now it no longer selects the first record when I navigate to the Gallery. However, it also doesn't reset the Gallery any more!

How can I solve this?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

JohnM86 590 on at

Like (0)

Report
Copy link

Link copied!

To reset the gallery and ensure that it doesn't select the first record when you navigate to the gallery, you can use the following formula for the gallery Items property:

If(IsBlank(TextInput2.Text), {}, With({_items:AddColumns('PSMC Cover Pods',"dname",Name.DisplayName)}, SortByColumns( Filter(_items,TextInput2.Text in dname), "dname", SortOrder.Ascending ) ) )

This formula uses the IsBlank() function to check if the TextInput2 control is blank. If it is, it returns an empty collection {}, which will clear the gallery. If it's not, it will filter and sort the items as before.
By using this formula, you can still reset the gallery with Reset(Gallery1), and it won't select the first record when you navigate to it.

Was this reply helpful? Yes No
Tanners_PP 10 on at

Like (0)

Report
Copy link

Link copied!

Thanks @JohnM86 - however I get an error saying "Expected Table Value".

Was this reply helpful? Yes No
JohnM86 590 on at

Like (0)

Report
Copy link

Link copied!

Could you try with :

If(IsBlank(TextInput2.Text), {}, With({_items:AddColumns('PSMC Cover Pods',"dname",Name.DisplayName)}, SortByColumns(Filter(_items,TextInput2.Text in dname), "dname", SortOrder.Ascending)).dname)

Was this reply helpful? Yes No
Suggested answer

CodeAvenue 104 on at

Like (1)

Report
Copy link

Link copied!

Hi @Tanners_PP,
A no fail solution that has worked for me is to set the gallery default to a variable example varGallery1

On the OnVisible of the Screen on which you've the gallery, set that the variable to blank, Set(varGallery1,Blank());

Now, you will want to collect the current selected gallery item into the variable Set(varGallery1,ThisItem);

Then finally, anywhere (this can be a button or icon) you want the OnSelect property to clear the gallery selection, Set(varGallery1, {});

Hope this helps anyone looking for this powerful solution!

Cheers

Was this reply helpful? Yes No