Filter Gallery and DropDown OnStart App

(0) Share

Report

Posted on by _kikilalaaa

353

Hi all,

I have a page called Maintenance Page. Inside this page, there is 2 dropdown, Dept and Unit.

I also have gallery to display Dept, Unit and other columns related. When user first land to this page, I want to set by default, the items that they will see is Dept = Admin, and Unit = 100.

Currently, I have done this:

App.Onstart = ClearCollect(ColCC,ShowColumns(Filter(database, dept = "Admin", Ynit = "100", "dept","unit","xxxx"));

gal.Items = ColCC

When I play in the app it works, but when I publish, the gallery showed all items instead of filtered ones. How do I fix this? Appreciate your help 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (3)

Verified answer

v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @_kikilalaaa ,

I suggest you set the code on the On Visible property of screen to test.

Best regards,
Rimmon Li

Was this reply helpful? Yes No
_kikilalaaa 353 on at

Like (0)

Report
Copy link

Link copied!

To give you some context, I only have total 480 rows on this table in databse

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

Like (0)

Report
Copy link

Link copied!

Hi @_kikilalaaa ,

How's it going? If my answer solves your problem, please accept it as a solution to help more people stuck on the same problem find it.

Best regards,
Rimmon Li

Was this reply helpful? Yes No
Verified answer

_kikilalaaa 353 on at

Like (0)

Report
Copy link

Link copied!

Hi, here's an update! It did work but I tweak a bit!

To give more context, actually I have 2 collection, colCC and colCCRecord.

colCC is the items to be shown in gallery, meanwhile colccrecord is just a filter of database, i have many columns in the database and i use this collection to fetch desired columns only onapp start.

At first I use ColCCRecord in ClearCollect filter. But I have changed it to database path instead, and it works (not sure why tho, it is basically the same thing).

The problem now is with the dropdown.if i select something in this page, and go back to previous page, and come again to this page, the dropdown is showing the items that i selected previously, but the items gallery displayed the default items (in this case, Dept = Admin, and Unit = 100). How do I reset the dropdown selected to its default if i go to other screen?

Kindly share your ideas!

Love,
kiki

Was this reply helpful? Yes No
Verified answer

_kikilalaaa 353 on at

Like (0)

Report
Copy link

Link copied!

Hi all. i have resolved this issue too.

To reset the selection to default it is very easy. Basically, in your dropdown, there is properties called "reset".

What you can do is, in user "Cancel" or "Back" icon, you can Set OnSelect:
Set(varResetInput, true)

And then, in you dropdown "Reset" properties:
varResetInput

this will reset the dropdown to it default selection whenever you select Back or Cancel.

Hope this helps!

Was this reply helpful? Yes No