cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
eenochs
Helper III
Helper III

Filter Date Range

I have a SharePoint list that i'm using to track support tickets.  I want to create a gallery that will show the last 30 days of items submitted using a specific incident type. 

 

Example would be you click from a drop down a specific icident type called Printers.  Then the gallery will show any items submitted to the list with that incident type.  Having challenges coming up with the filter formula. 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-micsh-msft
Community Support
Community Support

Agreed with @sudeep22169 here.

The formula should be written as:

 

Filter(TicketList, Type=Dropdown.Selected.value && CreatedDate>=DateAdd(Today(),-30,Days))

More information, see:

Filter function

DateAdd function

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
sudeep22169
Frequent Visitor

Filter(datasource, items = dropdown.selected.value && date = Today()-30 )

This might help you.

v-micsh-msft
Community Support
Community Support

Agreed with @sudeep22169 here.

The formula should be written as:

 

Filter(TicketList, Type=Dropdown.Selected.value && CreatedDate>=DateAdd(Today(),-30,Days))

More information, see:

Filter function

DateAdd function

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@v-micsh-msft 

What would be the best approach to avoid the "Delegation Warning" you would receive with this line of code?

@llacefield 

To avoid the "Delegation Warning" you can use use the FirstN() when you collecting your items.

 

For example:

 

ClearCollect(collectionName,FirstN(data source;500);
Filter(collectionName, SharePointColumn >= DatePicker1.SelectedDate && SharePointColumn <= DatePicker2.SelectedDate)

 

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-first-last 

 

I hope this will help you.

 

Best regards,

 

PA

mdevaney
Super User
Super User

@llacefield 

To show the last 30 days and avoid delegation warnings put this code in the OnVisible property of the screen.

 

Set(var30DaysAgo, DateAdd(Today(),-30,Days))

 

 

Then use this code in the Items dropdown of the gallery.

 

Filter(TicketList, Type=Dropdown.Selected.Value && CreatedDate>=var30DaysAgo)

 

 
Note: the code supplied by @PowerAnalytics cannot be delegated.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Top Solution Authors
Users online (3,135)