Hello Everyone…
Hope you all are doing well during the Pandemic.
Power Automate is great tool for Productivity improvement. I would like to share one such example with all of you.
Service Now is being used to track Incidents and Production Change Requests. Production Change requests needs to be prepared by every Monday so that it can be approved and prepared for deployment. In order to ensure that Production request goes in the list, we needed a reminder sent to us as a team so that we do not miss the window.
Service now did not provide this capability. Well !! Power Automate can help here.
I wrote following flow…
- This is a recurrence flow that runs every day once.
- We add 5 days to Current date to find out the Thursday since that will be deployment date every week. So in short, when there are 5 days to go to Change request, Flow will remind me.
- We use Service now connector to connect and select the Object. In my case it was Change Request. Note that if you account is set to SSO login, that login wont work. Use Non SSO account from service now with ITIL permission.
- Then we are looping through the list and match the dates by formatting them to MM/dd/yyyy.
- If the dates match, Post a Message to Teams channel. In case you have teams app on mobile, it will send push notification too.
When I ran this flow, it successfully inserted reminder note to my teams channel…
Prasad Athalye 