Sharepoint date restriction

Hi Guys, Need a quick help with this one. I need to create a flow that reads from a sharepoint list (this is not an issue) The issue is, On the SharePoint list I want to have 2 date fields. O...

SharePoint Online

kalpeshvaghela
Feb 16, 2023
soloadmin

You can assign Column Validation in Date1 column by going to List Settings -> and Click on your column name i.e. Date1

=WEEKDAY([Date1])=2

Using above validation user will not able to save any other date than Monday.

Now for Date2 field, instead of creating column of type Date and Time, you can create Calculated Column with following formula:

=[Date1]+6

Now it will set Date2 automatically

So in this approach, you don't need any Power Automate to achieve your requirement
Hope it will helpful to you and if so then Please mark my response as Best Response & Like to help others in this community

kalpeshvaghela

Iron Contributor

Feb 16, 2023

soloadmin

You can assign Column Validation in Date1 column by going to List Settings -> and Click on your column name i.e. Date1

=WEEKDAY([Date1])=2

Using above validation user will not able to save any other date than Monday.

Now for Date2 field, instead of creating column of type Date and Time, you can create Calculated Column with following formula:

=[Date1]+6

Now it will set Date2 automatically

So in this approach, you don't need any Power Automate to achieve your requirement

Hope it will helpful to you and if so then Please mark my response as Best Response & Like to help others in this community

soloadmin
Copper Contributor
Feb 16, 2023
Too good.
Worked like a charm.
Thanks mate.

Forum Discussion

Sharepoint date restriction

Resources