cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
sahilk
Level: Power Up

Daily Reminder on Teams on Days Left to an Event

Hello,

 

My company is has a huge industry event coming up in January for which a large team is working together to get ready and has a team on Microsoft Teams to help coordinate for this event.

 

My team leader wants to send a daily reminder on the team to let everyone know how many days are left to the event so that everybody is aligned.

 

I tried to do the following, shown in this screenshot (https://i.imgur.com/SsVYwma.png) - I was trying to use an if statement that if the date is 18th January 2020, it should display zero else it should display 18th Jan minus DateNow. However, I quickly realised that I have no idea how to do this.

 

Any help would be great.

1 REPLY 1
PowerBack19
Level 8

Re: Daily Reminder on Teams on Days Left to an Event

I would suggest you have a 3 variables for StartDate, EndDate, and CalculatedDate. Then, leverage the information provided in this post to calculate the number of days difference.

 

https://powerusers.microsoft.com/t5/General-Power-Automate/Subtract-dates/td-p/126119

Helpful resources

Announcements
firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (5,700)