Blackout dates in Calendar

%3CLINGO-SUB%20id%3D%22lingo-sub-917114%22%20slang%3D%22en-US%22%3EBlackout%20dates%20in%20Calendar%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-917114%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20creating%20a%20work%20order%20submission%20form%20and%20I%20would%20like%20to%20%22gray%20out%22%20today%20and%20tomorrow%20as%20options%20for%20delivery%20(we%20need%202%20days%20to%20complete%20the%20work%2C%20so%20they%20cannot%20choose%20today%2Ftomorrow%20as%20delivery%20dates).%26nbsp%3B%20Is%20this%20possible%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUltimately%20this%20is%20going%20to%20Sharepoint%20via%20Flow%20and%20entering%20an%20approval%20workflow%20so%20I%20could%20check%20the%20date%20then%2C%20but%20it%20would%20be%20better%20if%20the%20user%20is%20told%20right%20away%20that%20they%20must%20choose%20a%20date%20that%20is%20at%20least%202%20days%20in%20the%20future.%26nbsp%3B%20I%20considered%20describing%20that%20in%20the%20question%2C%20but%20no%20one%20will%20adhere%20to%20that%3B%20if%20they%20can%20choose%20same-day%20delivery%20they%20will!!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%20in%20advance!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-917114%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Eforms%20calendar%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

Hello all,

 

I am creating a work order submission form and I would like to "gray out" today and tomorrow as options for delivery (we need 2 days to complete the work, so they cannot choose today/tomorrow as delivery dates).  Is this possible?

 

Ultimately this is going to Sharepoint via Flow and entering an approval workflow so I could check the date then, but it would be better if the user is told right away that they must choose a date that is at least 2 days in the future.  I considered describing that in the question, but no one will adhere to that; if they can choose same-day delivery they will!!

 

thanks in advance!

3 Replies
Highlighted

Hi @DeclanHalpin 

 

I don't believe you can grey out dates in that way.

 

I would suggest to use the written warning anyway and have flow remove any dates less than 2 days into the future.

 

You could also have flow send a reponse email saying that the date they have chosen is less than 2 days notice and the flow has automatically pushed the date out.

 

The other option is to use PowerApps to ensure that you can program the date to be unavailable if less than 2 days out.

 

Cheers and best wishes

Damien

Highlighted

Thanks, @Damien Rosario 

 

Can you clarify the PowerApps solution?  I haven't explored PowerApps because I thought it was only for developing mobile apps.  Hopefully I am incorrect!

 

tx,

 

dh

 

 

Highlighted

Hi @DeclanHalpin 

 

I personally use PowerApps to build apps that we use on SharePoint and whatnot as Desktop type apps. You can adjust the dimensions of the canvas to suit your needs.

 

PowerApps is a bit involved but here's an example of the Date Picker in PowerApps where I have set it to 2 days ahead (see the attributes to the right). With some further conditions it could probably also disallow anything before two days from today but hopefully it gives you an idea.

 

You would need to link this app to something like a SharePoint list to get it going so if your requirements are really simple and nothing else is needed, it may be worthwhile to go down the Flow option I mentioned earlier else this is the first day of your new journey into PowerApps.

 

There's lots of videos and websites around that can help with getting you started as well as a more expert community who can assist at https://powerusers.microsoft.com/t5/PowerApps-Community/ct-p/PowerApps1

 

capture20191018142603483.png

 

See how you go?

 

Cheers

Damien