How to Receive Automated Emails for Upcoming Events Using Power Automate | 2023 Tutorial

Опубликовано: 24 Январь 2023
на канале: Michael Alex

4,251

Hi Everyone,

In this video I demonstrate how to create an automated weekly email for the upcoming events for the week. If you utilize SharePoint Lists for events/dates this can be helpful.

Make sure to run this Flow on Sunday to get all events for the week.

Get Items Action Filter Query Full Statement:
(Date ge 'convertFromUtc(utcnow(),'Eastern Standard Time','yyyy-MM-dd')') and (Date le 'addDays(convertFromUtc(utcNow(),'Eastern Standard Time','yyyy-MM-dd'),7,'yyyy-MM-dd')')

First Expression:
convertFromUtc(utcnow(),'Eastern Standard Time','yyyy-MM-dd')'

Second Expression:
addDays(convertFromUtc(utcNow(),'Eastern Standard Time','yyyy-MM-dd'),7,'yyyy-MM-dd')

If you enjoy my videos feel free to like, comment, and subscribe!

✨Support My Channel✨

If you enjoy my content and would like to support my work, consider buying me a coffee! Your support helps me create more videos and keep the channel going. ☕💖
https://buymeacoffee.com/michaelalex

🪙BTC🪙: 3LpmcBaJB537RweJu2tRjSqT6NhnQDDBWy
⛓️ETH⛓️: 0xbAEb6d6Df7CE5cfC55797B3133342e165B78A444
🐕DOGE🐕: DNKNUduorzBWMJ4XTSRqUSsUKk3ZiehHin

#powerautomate #sharepointlist #automation