Send email remainders from excel data and Update excel column value using Power Automate.

Опубликовано: 04 Октябрь 2024
на канале: Onetidbit

15,622

145

Send remainder emails to employees from excel and Update excel Column using Power Automate.

Step 1: Create an excel sheet in OneDrive with columns

1)Sno
2) EmpName
3) EmpEmail
4)Subject
5)RemainderDate
6)Status

Step 2: After entering the data select all the data and convert to Table and name the table as Remainders

Step 3: Create a flow with first step as recurrence and give 1 and Monthly .

Step 4: Add a Compose step and get the Todays date in "MM-DD" format . Flow Expression is: formateDateTime(utcNow(),"MM-dd")

Step 4: Now Get all rows from excel list table.

Step 5: iterate all the rows and get the Date value . Surprisingly it will not generate the date format we desired it will show something like 36541 which is not date formate so we need to convert that using a flow expression in compose statement: addDays('1899-12-30', int(item()['Date']), 'dd-MM-yyyy') or addDays('1899-12-30', int(item()['Date']), 'MM-yyyy')

Step 6: Run the flow and check date format.

Step 7: Add if Condition in flow.

Step 8: If Yes send an email

Step 9: Update Excel table column Status with "Yes".