Forum Discussion
date range filter in sharepoint list
Jin Chen I recommend you do this with Power Apps with the list as the data source. This is because it makes it very easy to add a gallery of your dates and other columns then filter that by 2 date pickers. You can have other filters as well and it can be as complex or simple as you wish. This example is just displaying items from my list between the dpFIlterFrom date picker and the dpFilterTo date picker. The filter syntax in this case is
Filter(BACS, ScheduledSubmission >= dpFilterFrom.SelectedDate && ScheduledSubmission<=dpFilterTo.SelectedDate)
which displays the following result. You can then have other screens to allow you edit or view the rest of the data in that item.
I'd probably add the app to a page on the SharePoint site with the Power Apps web part, but you don't have to.
Come back with any questions about this.
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.