Thank your for choosing Power Platform Community.
Take a look at the following flow overview:
Trigger: When a SharePoint item is created or modified → Only proceed if Sent = 0
Main Steps
Get Items from SharePoint where Sent = 0
Loop through each employee:
Get card.gif from OneDrive (/congratulations/card.gif)
Send email to employee with:
Personalized greeting using their name
Attached animated card
Update SharePoint item to set Sent = 1
Reliability Tips
Check if email field is populated before sending
Use UTC for accurate date matching
Add logging for audit trail
Use dynamic paths or environment variables for portability
Check out these resources too:
🏷️ Please tag me @Robu1 if you still have any queries related to the solution or issue persists.
✅ Please click Accept as solution if my post helped you solve your issue and help others who will face the similar issue in future.
❤️ Please consider giving it a Like, If the solution was useful in other ways.
If this fixes the issue, please mark as resolved to help others with find it.
