You’re offline. This is a read only version of the page.
Announcements
15
Good morning, all! I need your help overcoming the coding aspect of PowerAutomate! I have an extensive time off flow that starts with a form response, goes through the approval process, adds the dates to a SharePoint calendar with a modern calendar view, and then notifies the employee and HR of the time off request.
The SP modern calendar view is great, but it doesn't show all of the employees off at a quick glance, just the first two, I also cannot find a way to print the modern calendar view to PDF or the printer (bonus points if you know!!) and a couple of the people in our office want the paper copy or a quick way to see who all is off, especially the owner of the company.
So -- I added a step to create an event, however, I am running into an issue with the date and time. In the form, an employee can select a calendar date to start and a calendar date to end. I also added to field to select a start time and an end time (choices are currently 07:00:00 and 15:00:00 to get through testing).
I need a way to combine those into one data field so that the start time and end time in Outlook recognizes that it is two days off not one --- as of this morning I attempted taking off from a start date of 8/10/2023 and an end date of 8/11/2023 -- outlook added the event to the calendar but is only displaying it on 8/10/2023 (start time 12AM 8/10 through end time 12AM 8/11). CAn anyone help me with this?
(i had start date and start time in the *start time field but took it out to try and add an expression)
Hi There,
After trigger response add a "Compose" action to concatenate the start date and start time. User expression -
'concat(outputs('Start_Date'), 'T', outputs('Start_Time'), ':00')'.
Add another "Compose" action to concatenate the end date and end time-
'concat(outputs('End_Date'), 'T', outputs('End_Time'), ':00')'
In 'Create event' replace start and end date by compose response.
Please give kudos and mark as solution if it helps.
Thanks,
Sandeep Mishra
Share
Report
All responses (
Answers (
