Filter Date Range

[eenochs]

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. 

[sudeep22169]

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

This might help you.

[v-micsh-msft · Accepted solution]

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

[llacefield]

@v-micsh-msft 

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

[PowerAnalytics]

@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