Home

Calendering/Time off app

%3CLINGO-SUB%20id%3D%22lingo-sub-1051477%22%20slang%3D%22en-US%22%3ECalendering%2FTime%20off%20app%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1051477%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3ESo%20I%20have%20a%20sort%20of%20a%20project.%20End%20goal%20is%20to%20allow%20people%20to%20book%20time%20on%20a%20group%20calendar%20for%20their%20days%20off.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20was%20thinking%20of%20using%20a%20Form%20or%20a%20PowerApp%20that%20presents%20a%20month%20view%20and%20they%20can%20click%20on%20the%20dates%20they%20want%20off.%20V2.0%20should%20check%20to%20see%20if%20there%20are%20a%20certain%20%23%20of%20people%20that%20have%20already%20requested%20that%20same%20day%20off%20and%20if%20it%20is%20over%20a%20certain%20%23%2C%20deny%20it.%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20UI%20should%20store%20the%20person's%20response%20in%20a%20SPO%20list.%3CBR%20%2F%3E%3CBR%20%2F%3EThen%20Power%20Automate%20can%20block%20out%20a%20date%20on%20a%20group%20calendar%20and%20insert%20the%20person's%20name%20and%20email.%3CBR%20%2F%3E%3CBR%20%2F%3EIs%20this%20doable%3F%20Thanks!%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1051477%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1053803%22%20slang%3D%22en-US%22%3ERe%3A%20Calendering%2FTime%20off%20app%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1053803%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F314501%22%20target%3D%22_blank%22%3E%40Jlee_Prosci%3C%2FA%3E%20I%20have%20made%20a%20simple%20system%20that%20does%20this%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E1.%20Create%20SharePoint%20List%20with%20start%20and%20end%20dates%20for%20leave%2C%20leave%20type%20and%20comment%3C%2FP%3E%0A%3CP%3E2.%20Add%20a%20Flow%20to%20send%20item%20for%20approval%20-%20this%20out%20of%20the%20box%20flow%20looks%20up%20the%20line%20manager%20from%20AAD%20and%20sends%20an%20approval%20request%3C%2FP%3E%0A%3CP%3E3.%20If%20approved%20the%20Flow%20creates%20an%20item%20in%20the%20SharePoint%20calendar%3C%2FP%3E%0A%3CP%3E4.%20email%20person%20to%20say%20leave%20is%20approved%20or%20declined%20and%20email%20the%20payroll%20person%20with%20details%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1054339%22%20slang%3D%22en-US%22%3ERe%3A%20Calendering%2FTime%20off%20app%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1054339%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F43161%22%20target%3D%22_blank%22%3E%40Steve%20Knutson%3C%2FA%3E%26nbsp%3BThat's%20the%20meat%20of%20what%20I%20want%20to%20do.%20I%20want%20to%20build%20a%20UI%20though%20that%20shows%20a%20calendar%20view%20and%20lets%20people%20pick%20dates.%20It%20would%20record%20those%20selections%20into%20the%20SP%20list.%20It%20would%20also%20send%20those%20dates%20to%20a%20group%20calendar%20with%20people's%20names%20and%20email%20addresses.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1054376%22%20slang%3D%22en-US%22%3ERe%3A%20Calendering%2FTime%20off%20app%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1054376%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F314501%22%20target%3D%22_blank%22%3E%40Jlee_Prosci%3C%2FA%3E%20my%20solution%20doesn't%20show%20the%20leave%20calendar%2C%20I've%20done%20that%20in%20SharePoint%20and%20then%20added%20a%20form%20to%20request%20leave%20e.g.%20so%20the%20user%20can%20view%20the%20leave%20calendar%20in%20SharePoint%20and%20then%20request%20leave%20via%20a%20form.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHave%20you%20seen%20this%3F%20It%20explains%20how%20to%20connect%20the%20SharePoint%20Calendar%20to%20a%20PowerApp%20calendar%20view%3C%2FP%3E%0A%3CP%3E%3CFONT%20style%3D%22background-color%3A%20%23ffffff%3B%22%3E%3CA%20href%3D%22https%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FBuilding-Power-Apps-Formerly%2FSharePoint-Calendar-w-PowerApps-Calendar-Template%2Ftd-p%2F191294%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FBuilding-Power-Apps-Formerly%2FSharePoint-Calendar-w-PowerApps-Calendar-Template%2Ftd-p%2F191294%3C%2FA%3E%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1054709%22%20slang%3D%22en-US%22%3ERe%3A%20Calendering%2FTime%20off%20app%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1054709%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F43161%22%20target%3D%22_blank%22%3E%40Steve%20Knutson%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F160591i77AA75C5F3746719%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1056758%22%20slang%3D%22en-US%22%3ERe%3A%20Calendering%2FTime%20off%20app%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1056758%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F43161%22%20target%3D%22_blank%22%3E%40Steve%20Knutson%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20figured%20out%20how%20to%20create%20a%20form%20that%20will%20display%20what%20I%20want%20to%3A%3CBR%20%2F%3EPick%20start%20date%3C%2FP%3E%3CP%3EPick%20end%20date%3C%2FP%3E%3CP%3EAdd%20name%3C%2FP%3E%3CP%3EAdd%20email%3C%2FP%3E%3CP%3ESubmit%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20created%20a%20SPO%20list%20for%20this%20form%2C%20but%20trying%20to%20figure%20out%20how%20to%20send%20the%20data%20in%20the%20fields%20to%20the%20SPO%20list.%20Specifically%2C%20I%20don't%20know%20how%20to%20code%20the%20button%20to%20do%20the%20action%20when%20pressed.%3C%2FP%3E%3CP%3EUltimately%2C%20my%20goal%20would%20be%20for%20the%20app%20to%20automatically%20insert%20the%20name%20and%20email%20so%20the%20user%20doesn't%20have%20to%20do%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOnce%20the%20data%20gets%20put%20into%20a%20SPO%20list%2C%20then%20that%20data%20would%20be%20added%20to%20a%20group%20calendar%20for%20that%20team.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Jlee_Prosci
Contributor

So I have a sort of a project. End goal is to allow people to book time on a group calendar for their days off.

I was thinking of using a Form or a PowerApp that presents a month view and they can click on the dates they want off. V2.0 should check to see if there are a certain # of people that have already requested that same day off and if it is over a certain #, deny it.

The UI should store the person's response in a SPO list.

Then Power Automate can block out a date on a group calendar and insert the person's name and email.

Is this doable? Thanks!

5 Replies

@Jlee_Prosci I have made a simple system that does this:

 

1. Create SharePoint List with start and end dates for leave, leave type and comment

2. Add a Flow to send item for approval - this out of the box flow looks up the line manager from AAD and sends an approval request

3. If approved the Flow creates an item in the SharePoint calendar

4. email person to say leave is approved or declined and email the payroll person with details

 

 

@Steve Knutson That's the meat of what I want to do. I want to build a UI though that shows a calendar view and lets people pick dates. It would record those selections into the SP list. It would also send those dates to a group calendar with people's names and email addresses.

@Jlee_Prosci my solution doesn't show the leave calendar, I've done that in SharePoint and then added a form to request leave e.g. so the user can view the leave calendar in SharePoint and then request leave via a form.

 

Have you seen this? It explains how to connect the SharePoint Calendar to a PowerApp calendar view

https://powerusers.microsoft.com/t5/Building-Power-Apps-Formerly/SharePoint-Calendar-w-PowerApps-Cal...

 

@Steve Knutson 

I figured out how to create a form that will display what I want to:
Pick start date

Pick end date

Add name

Add email

Submit 

 

I created a SPO list for this form, but trying to figure out how to send the data in the fields to the SPO list. Specifically, I don't know how to code the button to do the action when pressed.

Ultimately, my goal would be for the app to automatically insert the name and email so the user doesn't have to do it.

 

Once the data gets put into a SPO list, then that data would be added to a group calendar for that team. 

Related Conversations
Create survey in Yammer
Deleted in Yammer on
9 Replies
Modify SharePoint app: from App-catalog to AppSource
mterra in SharePoint on
3 Replies
Check-In and Check-Out on mobile apps
Rob O'Keefe in SharePoint on
2 Replies
Time range auto fill colour
Francesc B. in Excel on
2 Replies