Filter gallery by status

(0) Share

Report

Posted on by mthiru

Hello community,

Need your help please. I am new to powerapps with limited technical skills.

I'd like to filter the Browse screen (i.eBrowseGallery1) by the Status of items called by Onboarding Progress Status where the status is equal to Submitted or In Progress only.

Categories:

Building Power Apps

All responses (7)

Answers (1)

Sort by

WarrenBelz 156,532 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @mthiru ,
Using
Onboarding as the data source
OnboardingStatus as the field
The Items property of BrowseGallery1 would be
Filter( Onboarding, OnboardingStatus = "Submitted" || OnboardingStatus = "In Progress" )

Please click Accept as solution 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 Thumbs Up.
mthiru 78 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz
I started with a sharepoint list and subsequently went to powerapps to create an app and linked to this same list. As a result powerapps has created a browsescreen1, detailscreen1 and editscreen1.

Within the browescreen1, we have the BrowseGallery1 where under items there an existing expression:

SortByColumns(Filter([@'Onboarding App'], StartsWith(Title, TextSearchBox1.Text)), "Title", If(SortDescending1, Descending, Ascending)).

I tried using your expression however It is not working and i received a bunch of errors.
I have a feeling i may not be referring to correct columns and values.

Existing expression for Items in BrowseGallery1:

Also, if this would help. Column name "Onboarding Progress Status" is a Choice Dropdown with the following options: Submitted, In Progress, Cancelled, and Complete.
mthiru 78 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz

I made this change to Filter('Onboarding Progress Status'.Value="Submitted") and it worked. I guess if want to include only, In Progress and "Submitted" in the Gallery, I can futher add by using Or statement?

Is this an acceptable solution?
Verified answer

WarrenBelz 156,532 Most Valuable Professional on at

Like
a
(6)

Report
Copy link

Link copied!
Hi @mthiru ,
Yes, I answered your broad question with more the structure required than the exact code as you had not mentioned where you were getting the values from (if a variable, my original post would have worked, but if a control, you would need .Text / .Value / .Result etc in your case a drop down was .Value. )
You are also correct with the Or statement , which can be written as || and mentioned below. So your filter code should be

Filter( Onboarding, 'Onboarding Progress Status'.Value = "Submitted" || 'Onboarding Progress Status'.Value = "In Progress" )

Please click Accept as solution 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 Thumbs Up.
WendeReisss 253 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz
I need to use search filter (textinput) joined in this fórmula to search ALL information (columns) in my gallery. Is there anyway to do It?
WarrenBelz 156,532 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

@WendeReisss ,

You would need to list all the columns in the Search filter (note only Text columns can be searched)
WendeReisss 253 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you @WarrenBelz .