Answered

How to filter my gallery list to the current month and also filter by the current user?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hiii everyone,

I am new to powerapps and im having trouble with the filtering part. I want to filter my gallery list based on the claim type(All,Transportation,Phone Bill, Medical) as button click and I want it to display the claim request of the current month and also by the current user when i click on each of the claim type button click. I have successfully filtered the gallery list based on the claim type using update context on each button on the onselect property but im having problem in filtering it to the current month and by the current user. I have attached the neccesary screenshot with the formulas. Apparently, the filtering work fine for the Transportation, Phone Bill and Medical but not in All. How do I get this work? All help will be really appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

K-A-R-L 715 on at

Like
a
(2)

Report
Copy link

Link copied!

Hi @Anonymous ,

You probably need to set up a global variable for the current month and the user profile on the App Property:

On App Property:

Set(CurrentMonth, Text( Now(), "[$-en-US]mmmm" )); //Makes current Month a global variable
Set(
MyProfileDisplayName,
Office365Users.MyProfile().DisplayName
) //Makes current user profile a global variable

On your Gallery Items: (Just try to play with the codes below)

Filter('Enfrasys Claims', Month = CurrentMonth && CreatedBy.DisplayName = MyProfileDisplayName && ClaimType.Value =varSelection)

Cheers

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(3)

Report
Copy link

Link copied!

I just had to change the formula in the gallery item property and it works fine now.

I manage to modify the formula to this:
If(varSelection="All",Sort(Filter('Enfrasys Claims',Month(ClaimDate)=Month(Now()),CreatedBy.DisplayName=User().FullName),Description),Sort(Filter(Filter(Filter('Enfrasys Claims',Month(ClaimDate)=Month(Now())),CreatedBy.DisplayName=User().FullName),ClaimType.Value=varSelection),Description))
Finally the filtering works. Thank you for the assist.

Was this reply helpful? Yes No
genarich 318 on at

Like
a
(0)

Report
Copy link

Link copied!

I have tried your solution but it is throwing me a delegation warning. More so, it is throwing the current month regardless of the current year. For example, it throws all years ie Aug 2019, 2020, 2021. If you could help me with this, it would be really great!

Was this reply helpful? Yes No