Answered

using filters for expense app

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi guys,

Making an expense app and try to have three buttons that, when pressed, will filter between pending, approved, and both pending and approved (see photo below).

my code is the following:

ClearCollect(
FilteredItems,
Filter(
LineItems,
Approval = "Pending" && Text(Title) = ApprovalGallerytext.Text Or Approval = "Approved" && Text(Title) = ApprovalGallerytext.Text
)
);
GallerySubmitted.AllItems = FilteredItems

It's sadly not working. the chocies in the sharepoint list (which it's connected to) are "rejected", "approved", and "Pending". Ignore rejected as i dont want a filter for that.

Where am I going wrong? any help would be greatly appreciated. Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

WarrenBelz 154,399 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

I think all you need is this

ClearCollect( FilteredItems, Filter( LineItems, Title = ApprovalGallerytext.Text && ( Approval = "Pending" || Approval = "Approved" ) ) );

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz ,

Thanks for your quick response. I think I initially tried this but arrived at an error of 'Incompatable types for this comparison. These types cant be compared: Record, Text.' Let me know what you think!

Was this reply helpful? Yes No
WarrenBelz 154,399 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@Anonymous ,

I was simply using your values assuming them to be correct - I suspect Approval is a Choice field, so you need Approval.Value - unless ApprovalGallerytext is in a Gallery so you would need

YourGalleryName.Selected.ApprovalGallerytext

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz ,

Sorry for me misunderstanding. The following has no errors but doesnt seem to filter how I'd like:
ClearCollect(
FilteredItems,
Filter(
LineItems,
Title = ApprovalGallerytext.Text &&
(
Approval.Value = "Pending" ||
Approval.Value = "Approved"
)
)
)

The approvalgallerytext is a part of the gallery as sen in the photo below.

Was this reply helpful? Yes No
WarrenBelz 154,399 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Anonymous ,

How do you want it to filter differently from what it is doing now ?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz ,

Sorry for the late response. Currently, Approved items are not in fact being shown in the gallery which confuses me. If i manually change the items in the sharepoint list, only rejected and pending items will show. ThereforeI think the filter does indeed work but the 'approved' items are not being displayed.

These two items arent showing up in gallery

Was this reply helpful? Yes No
WarrenBelz 154,399 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @Anonymous ,

You also have this additional filter

Title = ApprovalGallerytext.Text

so maybe that is taking out some items. The code should certainly otherwise show records with an Approval of Approved

Was this reply helpful? Yes No