Flow Issue For creating Recurrence Flow.

[SaiKrishna7]

Hello All, 

I tried to create a Power Automate Flow that will execute at 2:30pm EST daily and will check the list for all items in a SharePoint List that have a Loan Status(Field) of "Out on Loan" and a Due Date the same day as today. If true, this should generate an email notification to the Borrower reminding them to return the item to Service Desk by the end of the day. 

My Work:

Is this right? Or am I doing any obvious mistake here. Please Correct me.

Thank you.

[sandeepstw]

Hi There, 

Creating this automation involves several steps. Please follow the instructions given:

1. Navigate to Power Automate and click on "Create".
2. Select "Scheduled cloud flow".
3. Enter a Flow name, set "Starting" to the current date, "Repeat every" to 1, and "Frequency" to "Day".
4. Set "At these hours" to 14 and "At these minutes" to 30 (for 2:30pm).
5. Under "Time Zone", select "Eastern Standard Time".
6. Click "Create" to establish the trigger.

Next, to fetch the list items and filter the data:

1. Add an action by clicking "New Step", then search for "Get items" (SharePoint). Choose the SharePoint site and list.
2. Add another step, select "Condition" from the "Control" category.
3. In the condition, enter the formula in the format `@equals(item()?['Loan_x0020_Status'], 'Out on Loan')` and `@equals(formatDateTime(item()?['Due_x0020_Date'], 'yyyy-MM-dd'), utcNow('yyyy-MM-dd'))`.
4. This formula checks whether the "Loan Status" field is "Out on Loan" and the "Due Date" is today.

If the condition is met, an email will be sent:

1. Inside the "If Yes" branch of the condition, add the "Send an email (V2)" (Office 365 Outlook) action.
2. Enter the "Borrower" email address in the "To" field.
3. Enter a "Subject" like "Return Reminder".
4. Create an "Email Body" that includes the necessary details, e.g. "This is a reminder to return the item you borrowed to the Service Desk by the end of the day."

Finally, save the Flow. Now, it will run at 2:30pm EST each day, checking the SharePoint list and sending reminder emails to borrowers as needed.

Please give me kudos and mark as solution if it helps. 

Thanks, 

Sandeep Mishra