Date Range Limit

%3CLINGO-SUB%20id%3D%22lingo-sub-1380424%22%20slang%3D%22en-US%22%3EDate%20Range%20Limit%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1380424%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Everyone%2C%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20create%20a%20SharePoint%20list%20that%20has%20a%20date%20range%20picker%2C%20but%20limits%20the%20dates%20that%20can%20be%20selected%20(for%20instance%2C%20users%20can%20only%20select%20a%20date%20range%20for%20the%20month%20of%20September.%3C%2FP%3E%3CP%3EIs%20this%20possible%3F%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAdditionally%2C%20is%20it%20possible%20to%20keep%20a%20SharePoint%20list%20active%20for%20a%20certain%20period%20of%20time%3F%26nbsp%3B%20For%20example%2C%20users%20can%20only%20access%20a%20list%20from%206%2F1%2F2020%20to%206%2F21%2F2020%3B%20anytime%20outside%20of%20that%20range%2C%20users%20cannot%20access%20the%20list.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1380424%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPermissions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Server%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1380447%22%20slang%3D%22en-US%22%3ERe%3A%20Date%20Range%20Limit%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1380447%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F638688%22%20target%3D%22_blank%22%3E%40Robbie_P%3C%2FA%3E%26nbsp%3Bit's%20not%20possible%20to%20limit%20the%20dates%20in%20the%20date%20picker%20to%20a%20specific%20range.%20You%20could%20erhaps%20do%20something%20in%20Power%20Apps%20to%20validate%20the%20date%20selected%20-%20see%20April%20Dunnam's%20article%20on%20this%20at%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.sharepointsiren.com%2F2019%2F05%2Fpowerapps-restricting-date-picker-options%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.sharepointsiren.com%2F2019%2F05%2Fpowerapps-restricting-date-picker-options%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can't%20keep%20a%20list%20active%20for%20a%20certain%20period%20of%20time%20other%20than%20to%20manually%20change%20the%20permissions%26nbsp%3B%20after%20a%20particular%20date.%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.%3C%2FFONT%3E%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1380574%22%20slang%3D%22en-US%22%3ERe%3A%20Date%20Range%20Limit%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1380574%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E%26nbsp%3B%20thanks%2C%20Rob.%26nbsp%3B%20Appreciate%20the%20prompt%20response.%26nbsp%3B%20I'll%20check%20the%20article%20out%20and%20will%20utilize%20the%20workflow%20you%20mentioned%20regarding%20the%20changes%20to%20permissions.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Hi Everyone,  

 

I would like to create a SharePoint list that has a date range picker, but limits the dates that can be selected (for instance, users can only select a date range for the month of September.

Is this possible?  

 

Additionally, is it possible to keep a SharePoint list active for a certain period of time?  For example, users can only access a list from 6/1/2020 to 6/21/2020; anytime outside of that range, users cannot access the list.

 

Thanks.

2 Replies
Highlighted

@Robbie_P it's not possible to limit the dates in the date picker to a specific range. You could erhaps do something in Power Apps to validate the date selected - see April Dunnam's article on this at https://www.sharepointsiren.com/2019/05/powerapps-restricting-date-picker-options/

 

You can't keep a list active for a certain period of time other than to manually change the permissions  after a particular date.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User.

Highlighted

@Rob Elliott  thanks, Rob.  Appreciate the prompt response.  I'll check the article out and will utilize the workflow you mentioned regarding the changes to permissions.