@@ShanesCows sorry no slight on you! I was saying MS should have an easier way to set recurring OOO in Outlook! Especially with remote working what it is now.
I am using a flow that looks at my calendar appointments to set out of office automatically. It checks if I have appointments that are setup to show as out of office and have a title starting with "Free -". If it finds one, it will schedule an out of office for a period based on the start and end date/time from the appointment. It uses the body text from the appointment as text to send in out of office message.
You did it again Shane! great tip to make the workflow simpler, wow the avoid one loop one:) I really like viva insights guiding me through setting up automated replies and all the rest with it like cancelling meeting and stuff but always love a good button flow, your use case makes absolutely sense , thanks!
@@ShanesCows 👋 How are you doing today if i may ask? I pray this day brings more happiness,joy,prosperity love and peace 💞❤️🕊️🕊️ all over the world today 🙏🌍 I'm originally from Canada currently living in Key West Florida☀️☀️☀️☀️and you where are you from if i may ask?
you can also use the first() function to get the first item in an array/table, if you prefer having nested functions and then have a ?[attribute] after the closing bracket for the first function
Thanks for this tutorial. I like the way it checks your current automatic reply before setting a new one. I do have some feedback though. You've built your flow with a manual trigger which could create a little confusion. Your time logic with the "set up automatic replies" starts at utcnow() so viewers could be left wondering where you tell the flow when it shoud run and thereby apply the automatic reply. I'd suggest instead that you set it up with a recurrence trigger which is probably what viewers are looking to replicate. I appreciate you are showing people how to use the function builder and that you are looking to avoid the foreach, but if you wanted to just paste it all in: outputs('Get_mail_tips_for_a_mailbox_(V2)')?['body/value']?[0]?['automaticReplies/message'] Your compose isn't really necessary but will help with learning and troubleshooting. Its great to show us how to click onto the action after running a test to check inputs and outputs. Your condition doesn't check for a zero-length autoreply which is probably what happend at 16:12. I turned my condition to OR and added this new line: length(outputs('Get_mail_tips_for_a_mailbox_(V2)')?['body/value']?[0]?['automaticReplies/message']) = 0 To find the timezone "phrase" you can send this command line: tzutil /g I use www.timeanddate.com/date/timeduration.html to calculate the number of hours between your start and stop for the autoreply. You can use the html-style or in the message if you want newlines in the autoreply. It's better to leave the "false" condition blank or you will turn off an automatic reply you set through the outlook client. I know you are only demonstrating but this isn't what viewers are trying to replicate. The plan for this flow is to respect a user's manually-created autoreply in case they are on a 3 week vacation. What you've written will take down their autoreply while they are still away. Here's what mine looks like: Recurrence Trigger Interval: 1 Frequency: Week Timezone: On these days: at these hours: Get mail tips for a mailbox v2 email address: condition OR value (expression): outputs('Get_mail_tips_for_a_mailbox_(V2)')?['body/value']?[0]?['automaticReplies/message'] is equal to value (expression): null new item > add row value (expression): length(outputs('Get_mail_tips_for_a_mailbox_(V2)')?['body/value']?[0]?['automaticReplies/message']) is equal to value: 0 true: set up automatic replies v2 start datetime (function): utcnow() start time timezone: the # in the below line is the number of hours you want the automatic reply displayed, calculated from www.timeanddate.com/date/timeduration.html end time (function): addhours(utcnow(),#) end time timezone: internal reply message: false: blank Hope this helps someone.
@@ShanesCows any concrete example of this? For now I just wrote it in html straight up, although it can be tedious sometimes considering email does not support full HTML.
Great stuff as always Shane! Question about the automatic reply message table - if you have internal and external replies, would there be two entries in that table? Internal [0] and external [1]?
Thank you for this concise tutorial. Is there a way to set up a recurring out of office for an outlook group or for multiple inboxes? Our office closes early on Fridays and I need to set up *everyone's* email to start out of office replies at noon on Friday, ending 730am on Monday. Hoping there's a way to do this without having to set up on each account individually!
@@ShanesCows I have the same requirement... to change the autoresponse for all the people in the office that is on vacation and forgot to setup their auto-reply. It would be very helpfull if you found something about it.
Is possible to make a flow where you automatically send an reply when you receive an email when you are scheduled as "out of office" in outlook calendar? Also this mail should contain the date when you are back in office.
I know it would be a permissions nightmare, but it would be cool if there was someway to tie this into a department PTO calendar to auto turn on everyone's auto-reply
Hi Shane! You make this really easy :) I have one question regarding this, Is it possible to get the status of the employees (Out of the office, Working elsewhere..)? I need to create a flow that cancel a booking if the employee marks that day in the calendar like "Working elsewhere". I hope you can help me. Thanks in advance! :)
How can I manage it to run on daily basis after working hours 18:00 PM and stop next day at 9:00 without need to manually trigger or change values of End DateTime? Also, to make weekend if Friday 18:00 set OOF then stop next Monday 9:00?
I would use two flows for that. One that runs daily monday-thursday at 1800 and sets an autoreply for 15 hours. Second flow would run friday at 1800 and sets an autoreply for 63 hours.
Hi! Is there a similar way to automatically set your Teams Status Message? With hybrid work, it would be helpful to automatically set whether you are In Office or Teleworking on 'Available'. Thanks!
hi, flow works great, but i test with my private email and send a email to my company adress and he doesnt reply ? must i change the triger to when a new email arrives and reply then if the auto reply is on ?
@@jimwalsh7376 Yes, i biold a srcond flow with the trigger when a Email arrives and the of Statement for a auto reply record, this isnt the eight solution or?
Hi Shane, thanks for your insights. Is it anyway possible to format the OoO text in HTML? Or at least enter some line breaks so that it remains readable?
@@ShanesCows apparantly you can add line breaks by adding in your Power Automate message, it will be passed as a line break in your Outlook message. If you try the same directly in Outlook it's not working though, it will be changed to plain text and you will see in your email
Can Out-of-office be triggered by certain calendar events? Example - whenever I put in events in my calendar titled "HOLIDAY" PowerAutomate enables out-of-office with an already pre-defined text and includes the day after my holiday ends as the return date. Is that possible?
I am not sure Robert, I haven't tried that before. Maybe add their connection to the flow and go that route? Or you might have to use the Graph API. Not sure.
What Shane said, but you won't be able to get the "item details" because the item is deleted. Trust me, I've tried. You need to remember that the data returned from the trigger action is basically just a signal that the trigger event has occurred and some very basic info on the relevant item (in the case of SharePoint, it'll be item ID and not too much else).
Hi , its working very well for the internal reply but when i tried to send an email by my external mail , nothing happen ; Can you help for that i did the same as you for the manipulation..
This is great stuff and I love your videos. I had SharePoint forms integrated with PowerApps question if you don’t mind me asking. Is there a way to limit form view of an item based on if the current user exists in a person field, a multiuser person field or they are part of a specific SharePoint user group?
Wow 20 minutes to learn how to set a recurring out of Office. Good Job Microsoft!
Sorry, I guess it could have been quicker but I try to help explain the details along the way.
@@ShanesCows sorry no slight on you! I was saying MS should have an easier way to set recurring OOO in Outlook! Especially with remote working what it is now.
I am using a flow that looks at my calendar appointments to set out of office automatically. It checks if I have appointments that are setup to show as out of office and have a title starting with "Free -". If it finds one, it will schedule an out of office for a period based on the start and end date/time from the appointment. It uses the body text from the appointment as text to send in out of office message.
Can you explain to us how that was done?
You did it again Shane! great tip to make the workflow simpler, wow the avoid one loop one:) I really like viva insights guiding me through setting up automated replies and all the rest with it like cancelling meeting and stuff but always love a good button flow, your use case makes absolutely sense , thanks!
Glad it was helpful! 🐶
@@ShanesCows 👋 How are you doing today if i may ask? I pray this day brings more happiness,joy,prosperity love and peace 💞❤️🕊️🕊️ all over the world today 🙏🌍
I'm originally from Canada currently living in Key West Florida☀️☀️☀️☀️and you where are you from if i may ask?
you can also use the first() function to get the first item in an array/table, if you prefer having nested functions and then have a ?[attribute] after the closing bracket for the first function
You are correct Benjy! I don't ever do it that way, I should. 😊
The exact formula for anyone curious is: first(outputs('Get_mail_tips_for_a_mailbox_(V2)')?['body/value'])?['automaticReplies/message']
Thanks for this tutorial. I like the way it checks your current automatic reply before setting a new one. I do have some feedback though.
You've built your flow with a manual trigger which could create a little confusion. Your time logic with the "set up automatic replies" starts at utcnow() so viewers could be left wondering
where you tell the flow when it shoud run and thereby apply the automatic reply. I'd suggest instead that you set it up with a recurrence trigger which is probably what viewers are looking to replicate.
I appreciate you are showing people how to use the function builder and that you are looking to avoid the foreach, but if you wanted to just paste it all in: outputs('Get_mail_tips_for_a_mailbox_(V2)')?['body/value']?[0]?['automaticReplies/message']
Your compose isn't really necessary but will help with learning and troubleshooting. Its great to show us how to click onto the action after running a test to check inputs and outputs.
Your condition doesn't check for a zero-length autoreply which is probably what happend at 16:12. I turned my condition to OR and added this new line:
length(outputs('Get_mail_tips_for_a_mailbox_(V2)')?['body/value']?[0]?['automaticReplies/message']) = 0
To find the timezone "phrase" you can send this command line: tzutil /g
I use www.timeanddate.com/date/timeduration.html to calculate the number of hours between your start and stop for the autoreply.
You can use the html-style or in the message if you want newlines in the autoreply.
It's better to leave the "false" condition blank or you will turn off an automatic reply you set through the outlook client. I know you are only demonstrating but this isn't what viewers are trying to replicate. The plan for this flow is to respect a user's manually-created autoreply in case they are on a 3 week vacation. What you've written will take down their autoreply while they are still away.
Here's what mine looks like:
Recurrence Trigger
Interval: 1
Frequency: Week
Timezone:
On these days:
at these hours:
Get mail tips for a mailbox v2
email address:
condition
OR
value (expression): outputs('Get_mail_tips_for_a_mailbox_(V2)')?['body/value']?[0]?['automaticReplies/message']
is equal to
value (expression): null
new item > add row
value (expression): length(outputs('Get_mail_tips_for_a_mailbox_(V2)')?['body/value']?[0]?['automaticReplies/message'])
is equal to
value: 0
true:
set up automatic replies v2
start datetime (function): utcnow()
start time timezone:
the # in the below line is the number of hours you want the automatic reply displayed, calculated from www.timeanddate.com/date/timeduration.html
end time (function): addhours(utcnow(),#)
end time timezone:
internal reply message:
false:
blank
Hope this helps someone.
Shane, you put the Power into Power Automate! thanks man👍
Thank you 🐶
💡Great tip, thanks Shane 👍
You bet!
It is INSANE that they do not have a WYSIWYG editor for the email body.
You can add a Rich Text Editor, make it all pretty, and then use a label to capture that html. Kind of a work around. 😎
@@ShanesCows any concrete example of this? For now I just wrote it in html straight up, although it can be tedious sometimes considering email does not support full HTML.
Great stuff as always Shane! Question about the automatic reply message table - if you have internal and external replies, would there be two entries in that table? Internal [0] and external [1]?
Yes, but my thought is if there is one or more we know they are on.
Thank you for this video. New knowledge gained
Glad to hear it!
Thank you for this concise tutorial. Is there a way to set up a recurring out of office for an outlook group or for multiple inboxes? Our office closes early on Fridays and I need to set up *everyone's* email to start out of office replies at noon on Friday, ending 730am on Monday. Hoping there's a way to do this without having to set up on each account individually!
Not that I have done. Maybe but not that I know. I would look at the Graph API and hunt a bit. Good luck
@@ShanesCows I have the same requirement... to change the autoresponse for all the people in the office that is on vacation and forgot to setup their auto-reply. It would be very helpfull if you found something about it.
Is possible to make a flow where you automatically send an reply when you receive an email when you are scheduled as "out of office" in outlook calendar? Also this mail should contain the date when you are back in office.
I know it would be a permissions nightmare, but it would be cool if there was someway to tie this into a department PTO calendar to auto turn on everyone's auto-reply
That is an interesting place to ponder. Hmmm
Hi Shane! You make this really easy :)
I have one question regarding this, Is it possible to get the status of the employees (Out of the office, Working elsewhere..)? I need to create a flow that cancel a booking if the employee marks that day in the calendar like "Working elsewhere". I hope you can help me. Thanks in advance! :)
How can I manage it to run on daily basis after working hours 18:00 PM and stop next day at 9:00 without need to manually trigger or change values of End DateTime? Also, to make weekend if Friday 18:00 set OOF then stop next Monday 9:00?
Same question
I would use two flows for that. One that runs daily monday-thursday at 1800 and sets an autoreply for 15 hours. Second flow would run friday at 1800 and sets an autoreply for 63 hours.
Hi! Is there a similar way to automatically set your Teams Status Message? With hybrid work, it would be helpful to automatically set whether you are In Office or Teleworking on 'Available'. Thanks!
hi, flow works great, but i test with my private email and send a email to my company adress and he doesnt reply ?
must i change the triger to when a new email arrives and reply then if the auto reply is on ?
Do you have the auto reply turned on for external emails?
@@jimwalsh7376 Yes, i biold a srcond flow with the trigger when a Email arrives and the of Statement for a auto reply record, this isnt the eight solution or?
In the Set Up Automatic Replies (v2) you might need to click the button "show all" and populate the External Reply field with what you want.
Do you know how to set up an out of office to direct only at certain people in outlook?
Sorry, I don't
Hi Shane, thanks for your insights. Is it anyway possible to format the OoO text in HTML? Or at least enter some line breaks so that it remains readable?
I am not sure. I haven’t tried. 🤔 try Char(13) to see if that creates a line break would be my first guess.
@@ShanesCows apparantly you can add line breaks by adding in your Power Automate message, it will be passed as a line break in your Outlook message. If you try the same directly in Outlook it's not working though, it will be changed to plain text and you will see in your email
Can Out-of-office be triggered by certain calendar events? Example - whenever I put in events in my calendar titled "HOLIDAY" PowerAutomate enables out-of-office with an already pre-defined text and includes the day after my holiday ends as the return date. Is that possible?
How can I do this for another user if I have the correct roles and permissions
I am not sure Robert, I haven't tried that before. Maybe add their connection to the flow and go that route? Or you might have to use the Graph API. Not sure.
Can you please give a solution How to transfer data from one environment to another environment in power automate. Thanks in advance
I haven't done that one but I thought the pieces are there. Sorry, I am no help.
How to create a flow for sending an email notification and item details when an item is deleted from a SharePoint list?
Use the SharePoint Trigger "when an item is deleted" and then pull they dynamic content.
What Shane said, but you won't be able to get the "item details" because the item is deleted. Trust me, I've tried. You need to remember that the data returned from the trigger action is basically just a signal that the trigger event has occurred and some very basic info on the relevant item (in the case of SharePoint, it'll be item ID and not too much else).
Hi Shane.
Can we get triggers / email notification when employee leave the company?
From AZ AD?
I don't know if that is possible. Sorry
@@ShanesCows no problem.
Hi , its working very well for the internal reply but when i tried to send an email by my external mail , nothing happen ; Can you help for that i did the same as you for the manipulation..
seems like it was a bug , everything is working now , thank you
This is great stuff and I love your videos. I had SharePoint forms integrated with PowerApps question if you don’t mind me asking. Is there a way to limit form view of an item based on if the current user exists in a person field, a multiuser person field or they are part of a specific SharePoint user group?
Jonathan I would apply the concept from this video ruclips.net/video/0MB-z9cyFCQ/видео.html.
Can you run it on a 365 Group?
Not sure, I haven't tried.
Tried to follow this.. No luck. Do one for dummies 🤣🤣