date range filter in sharepoint list

%3CLINGO-SUB%20id%3D%22lingo-sub-1553024%22%20slang%3D%22en-US%22%3Edate%20range%20filter%20in%20sharepoint%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1553024%22%20slang%3D%22en-US%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3EHopefully%20someone%20can%20help%20me.%3C%2FP%3E%3CP%3EI%20have%20created%20a%20sharepoint%20list%20with%20many%20date%20to%20monitor.%20The%20default%20filter%20pane%20allows%20me%20to%20filter%20the%20date%20from%20to%20the%20last%20date%20in%20the%20column.%20I%20need%20to%20have%20a%20filter%20to%20filter%20the%20in%20between%20dates%2C%20for%20example%20starting%20today%20to%20the%20next%203%20months.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20read%20many%20articles%20online%2C%20and%20found%20out%20adding%20a%20date%20filter%20maybe%20a%20solution.%20I%20followed%20the%20instruction%2C%20but%20I%20have%20no%20success.%20The%20webpart%20is%20stucked%20at%20%22sending%20value%20to%20.....%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPls%20help%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222020-07-29_9-07-07.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F208785i3C7A228ED89675DA%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%222020-07-29_9-07-07.png%22%20alt%3D%222020-07-29_9-07-07.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1553024%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1561101%22%20slang%3D%22en-US%22%3ERe%3A%20date%20range%20filter%20in%20sharepoint%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1561101%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F162506%22%20target%3D%22_blank%22%3E%40Jin%20Chen%3C%2FA%3E%26nbsp%3BI%20recommend%20you%20do%20this%20with%20Power%20Apps%20with%20the%20list%20as%20the%20data%20source.%20This%20is%20because%20it%20makes%20it%20very%20easy%20to%20add%20a%20gallery%20of%20your%20dates%20and%20other%20columns%20then%20filter%20that%20by%202%20date%20pickers.%20You%20can%20have%20other%20filters%20as%20well%20and%20it%20can%20be%20as%20complex%20or%20simple%20as%20you%20wish.%20This%20example%20is%20just%20displaying%20items%20from%20my%20list%20between%20the%20%3CEM%3EdpFIlterFrom%3C%2FEM%3E%20date%20picker%20and%20the%3CEM%3E%20dpFilterTo%3C%2FEM%3E%20date%20picker.%20The%20filter%20syntax%20in%20this%20case%20is%3C%2FP%3E%3CP%3E%3CSTRONG%3EFilter(BACS%2C%20ScheduledSubmission%20%26gt%3B%3D%20dpFilterFrom.SelectedDate%20%26amp%3B%26amp%3B%20ScheduledSubmission%26lt%3B%3DdpFilterTo.SelectedDate)%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%220-filterSyntax.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F209707i7818451557F1128B%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%220-filterSyntax.png%22%20alt%3D%220-filterSyntax.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ewhich%20displays%20the%20following%20result.%20You%20can%20then%20have%20other%20screens%20to%20allow%20you%20edit%20or%20view%20the%20rest%20of%20the%20data%20in%20that%20item.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%221-filterResult.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F209708i837ED144FB6156FD%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%221-filterResult.png%22%20alt%3D%221-filterResult.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'd%20probably%20add%20the%20app%20to%20a%20page%20on%20the%20SharePoint%20site%20with%20the%20Power%20Apps%20web%20part%2C%20but%20you%20don't%20have%20to.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECome%20back%20with%20any%20questions%20about%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User.%3CBR%20%2F%3EIf%20I've%20answered%20your%20question%20or%20solved%20your%20problem%2C%20please%20mark%20this%20question%20as%20answered.%20This%20helps%20others%20who%20have%20the%20same%20question%20find%20a%20solution%20quickly%20via%20the%20forum%20search.%20If%20you%20liked%20my%20response%2C%20please%20consider%20giving%20it%20a%20thumbs%20up.%20Thanks.%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

Hello

Hopefully someone can help me.

I have created a sharepoint list with many date to monitor. The default filter pane allows me to filter the date from to the last date in the column. I need to have a filter to filter the in between dates, for example starting today to the next 3 months.  

 

I have read many articles online, and found out adding a date filter maybe a solution. I followed the instruction, but I have no success. The webpart is stucked at "sending value to ....."

 

Pls help

 

 
 

2020-07-29_9-07-07.png

 

 

 

 

1 Reply

@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)

0-filterSyntax.png

 

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.

 

1-filterResult.png

 

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.