Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

General question about solution.

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.

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. 



















Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (4,100)