Answered

Filter by user then search by date

(0) Share

Report

Posted on by Ayefz_99

Dear All,

I have gallery with connected to Sharepoint contain Title and Date, then I make another calculated column to separate the month form the date so now I have 3 column , Title, Date and Month

On Power Apps setting

OnVisible : Set(currentuser,User().FullName)

On the gallery Item : Filter("SharepointListname",Title=currentuser)

and this is working load all record based on Title .

My question is after filtered by user and then I need to search by month, How I make this work? ( I tried several time on tutorial but not working)

Thank you

regards

Yefz

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Ayefz_99

What is it that you want to use to determine the search? Is the user going to be selecting from a dropdown, or typing into an input, or are you just hard coding it in?

So, if it hard coded:

Filter("SharepointListname",Title=currentuser && Month=3)

If from a text input:

Filter("SharepointListname",Title=currentuser && Month = Value(TextInput1.Text))

If from a dropdown (items property set to : Sequence(12)):

Filter("SharepointListname",Title=currentuser && Month = Value(Dropdown1.Selected.Value))

Also...be aware that calculated columns are not delegable in PowerApps, so if your data is more than 2000 records (or will grow to such) you will need to consider an alternate approach to the Month in your list.

I hope this is helpful for you.

Was this reply helpful? Yes No
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@Ayefz_99

You could put a dropdown control over the gallery with the Items property

Distinct( Filter( "SharepointListname",Title=currentuser ),Month )

This will filter out only those months that the current user has data for.

Then make the Items property of the gallery

Filter( "SharepointListname",Title=currentuser, Month=Dropdown1.Selected.Result )

Was this reply helpful? Yes No
rubin_boer 4,843 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

hi @Ayefz_99 welcome to the community

On the gallery Items = Filter(SharepointListname, Title - User().FullName, Month('Created') = 3)

This will filter on the logged in user and the items created in the 3rd month. you can expand your month range by adding year(created) = 2021

hope this helps

Was this reply helpful? Yes No
Ayefz_99 13 on at

Like (0)

Report
Copy link

Link copied!

This is working but I got delegable warning
Let say 1 have 10 user and every user have 400 maximum record. How to calculate max delegable is it from total user ( total record at Sharepoint) or only for 1 user ( record after filtering).
And how to eliminate the delegable waning? (

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Ayefz_99

Distinct() is not delegatable but given the size of your table it should not be a problem. You could avoid it by either hard coding the values in the dropdown, creating a list of months that you could use as items for the dropdown or use one of @RandyHayes suggestions.

Mine has the advantage of only using months where data specific for the user has been entered

Was this reply helpful? Yes No