Sharepoint date restriction

Question

Hi Guys,&nbsp;Need a quick help with this one.&nbsp;I need to create a flow that reads from a sharepoint list (this is not an issue)&nbsp;The issue is, On the SharePoint list I want to have 2 date fields. Once for start date and another for End date.&nbsp;Is there any way or any formulae that can restrict the first date field to only allow to select a Monday's date of any month? and then the second date field automatically populated as the Sunday of the week selected on the first date field. or just adds 5days to the first date field.&nbsp;&nbsp;&nbsp;Or maybe any other ways on sharepoint that allows user to Select Start day as Monday and end day as sunday. Or restrict them to select a specific date basically a whole week.&nbsp;Thanks&nbsp;

kalpeshvaghela · Accepted Answer

soloadmin&nbsp;&nbsp;You can assign Column Validation in Date1 column by going to List Settings -&gt; and Click on&nbsp; your column name i.e. Date1&nbsp;=WEEKDAY([Date1])=2&nbsp;&nbsp;&nbsp;&nbsp;Using above validation user will not able to save any other date than Monday.&nbsp;Now for Date2 field, instead of creating column of type Date and Time, you can create Calculated Column with following formula:&nbsp;=[Date1]+6&nbsp;&nbsp;Now it will set Date2 automatically&nbsp;&nbsp;So in this approach, you don't need any Power Automate to achieve your requirementHope it will helpful to you and if so then Please mark my response as Best Response &amp; Like to help others in this community&nbsp;

Forum Discussion

Sharepoint date restriction

2 Replies

Resources