Answered

clearing filter

(0) Share

Report

Posted on by sleoxilyne

Hi, I have below formula in my gallery item property.

Sort( If( IsBlank(DatePicker2), Filter( '【FSC】CCDiary', StartsWith( ID, TextInput2.Text ) || StartsWith( customer, TextInput2.Text ) || StartsWith( store, TextInput2.Text ) ), Filter( '【FSC】CCDiary', StartsWith( ID, TextInput2.Text ) || StartsWith( customer, TextInput2.Text ) || StartsWith( store, TextInput2.Text ), ThisRecord.Date >= DatePicker2.SelectedDate, ThisRecord.Date < DateAdd( DatePicker2.SelectedDate, 1 ) ) ), Date, SortOrder.Descending )

I have created two filter which is a date picker and text input box.

Screen OnVisible

UpdateContext({varReset:true});UpdateContext({varReset:false})

Date Picker

Reset property varReset

Default empty

Text Input

Reset property varReset

Default empty

I would like for the gallery to reset and show all items when I move back and forth from screen.

When I don't set any variables in text input reset property, it will show all items.

But If I set reset property to text input, it will return blank.

Grateful for any help you can give me.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @sleoxilyne ,

Please try this:
Set the OnVisible of Screen to:
Reset(TextInput2)

Best regards,
Rimmon Li

Was this reply helpful? Yes No
sleoxilyne 24 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Rimmon,
It didn't work, just returned as blank.
Should I add If(IsBlank(Textinput2.Text) somewhere in my gallery item property?

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @sleoxilyne ,

How are your variables used to reset controls? Have you tried to remove the original reset settings and test my method?

"Should I add If(IsBlank(Textinput2.Text) somewhere in my gallery item property?"
It's not necessary, I tested your formula, when the value of the control is empty, the gallery will return all items by default, in theory, you only need to reset the control to get all items in the gallery when the screen is switched.

Best regards,
Rimmon Li

Was this reply helpful? Yes No
sleoxilyne 24 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Rimmon Li, sorry for the late reply.

I can use your solution after I've set my textinput default to ""
Thanks for the help.

Was this reply helpful? Yes No