Answered

Default filter on gallery

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a gallery with different work items. I have already created a dropdown list that is connected to my gallery (the dropdown has different status of the current work items). I also want to filter on the specific tagg \Business Tracks\Make by default. so when I am at the page it shows only work items with the tagg Make and then I can filter by status (by choosing the right status in the dropdown list).

Gallery GalleryDropdown list Label Label excel excel

Categories:

Building Power Apps

All responses (15)

Answers (1)

Sort by

Pstork1 69,661 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

How is the default filter set? Is it always the same? If it is then you simply need to add it to the Search() or Filter() formula being used for the Items property of the gallery. I usually do this by adding it as either a variable or a hidden label on the screen. Then set that value and use that in your Search/Filter string.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I have now changed the default to following: Filter(Tickets, isFolder=true && "\Business Tracks\Make" in AccountName)

But it is not working.
Pstork1 69,661 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

What data source is the content coming from? And what is the AccountName field? Shouldn't you be tesing against Path or something similar?
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

It is coming from an Excel file published on onedrive.
Pstork1 69,661 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Try '=' or StartsWith() instead of 'in'. You are trying to check a field value where in checks to see if the value is in the column, not the specific record.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Still error, I have tried with both method '=' and 'StartsWith()'
v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Based on the formula you provided, I think there is something wrong with it. The Default property of the Gallery control is required to provide a record value, but the Filter formula you provided returns a Table value.

As an alternative solution, please consider take a try with the following workaround:

Set the OnVisible property of the Make screen to following:

ClearCollect( InitialCollection, Filter(Tickets, isFolder = true, "\Business Tracks\Make" in AccountName) )

Set the Items property of the Gallery to following:

If( !IsEmpty(InitialCollection), InitialCollection, Filter(Tickets, Status = Dropdown1.Selected.Result) )

Set the OnSelect property and OnChange property of the Dropdown1 to following:

Clear(InitialCollection)

Please consider take a try with above solution, then navigate to another screen, and then navigate back to the Make screen (fire the OnVisible property of the Make screen), check if the issue is solved.

Best regards,
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-xida-msft

Thank you for your help but it didn't work.
v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Based on the screenshot that you provided, it seems that there is something issue with the isFolder column. Please check if there is a column called isFolder in your Tickets Excel table.

If there is no column called isFolder in your Tickets Excel table, please remove the isFolder = true condition from your Filter formula.

Note: Within your Filter function, the filtered column you referenced must be existed in your Tickets Excel table. You could not reference columns from another data source within the Filter function.

Best regards,
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@v-xida-msft
Yes you where right I didn't have a column called isFolder.
I removed the isFolder=true from my code but it stil doesn't work.