web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / General question about...
Power Automate
Unanswered

General question about solution.

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi Team :),

I have my first task in my company. I have some basic solution, but I want to ask if I thinking good.
So, I was delegate to create flow or other solution for this scenario:

Flow should send each 1 st day of month email with congratulations of specific anniversary(3 options of anniversary: 1 year, 5 years or 10 years) to those people who are going to have one of this specific anniversary in this month.
Emails should include specific 3 options to choose as a gift, for specific anniversary: 
1 year anniversary:
Option 1
Option 2
Option 3
5 years anniversary:
Option 4
Option 5
Option 6
10 years anniversary:
Option 7
Option 8
Option 9
When employee choose option, I need to save this information on sharepoint list for HR department to overview.
When employee don't choose any option, I should save first option as a default. 

Second case is that I probably need another flow which will be updating sharepoint list with employees from 2 excel files. 
HR department wants to give me one excel file with 300 employees, and delivering 2 different excel file with new hire employees and employees which are leaving our company at specific month, before when month ends. So first I need to create main sharepoint list from excel file and updating this list each 25 th day in each month before I send email to specific employee which have anniversary.

Sources:
Excel file with 300 employees
Excel file with new hire employees 
Excel file with employee who are leaving 

What I did:
Sharepoint list with employees and hire date, 1 year, 5 years, 10 years anniversary date
Sharepoint list with full name and choosed option form email
Basic flow for sending anniversary email
Basic flow for updating sharepoint list with employees

Question is what will be the best tool for give employee options to choose specific gift in email and save this info somewhere?
Is impossible to create one flow for this scenario?
What should I care about? Some specific validation? Some corner cases like what if first of month will be at Sunday?

I uploaded screen of this what I made. 
Right now I have problem with:
-delete leaving employee from sharepoint list(when received excel file with leaving employee),
-send email to specific employees for specific anniversary(right now flow sending email in exactly day when employee have anniversary)
-don't find solution to receive answer from employee or default option when specific time gone(for example 1 week)

Sorry for very long questions. 

konradsiekacz_0-1656425259718.png

konradsiekacz_2-1656425338952.png

 

 

konradsiekacz_3-1656425380770.png

konradsiekacz_5-1656425489903.png

konradsiekacz_7-1656425541174.png

konradsiekacz_9-1656425635570.png

konradsiekacz_10-1656425669999.png

konradsiekacz_11-1656425763129.png

 

konradsiekacz_12-1656425808630.png

konradsiekacz_14-1656425858922.png

konradsiekacz_16-1656425894751.png

konradsiekacz_18-1656426028850.png

 

 

Categories:

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 307 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 289

#3
Henil Profile Picture

Henil 127

Last 30 days Overall leaderboard