cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MarioOne
Helper I
Helper I

Reminders to be send on number of workday days from initial date

I am working on SharePoint List solution that acts on date trigger.

The base date is a date of parcel receipt. This date is my Initial date.

I need a set of reminders that stop once Picked field is turned "yes".

 

Reminder_List1.png

Idea here is:

  • Notification mail info on "New Item" - done and work fine
  • Flow to send reminders on 2nd, 4th and 7th working day from the initial date (parcel receipt) 
  • Fields Reminder 1, 2 and 3 to be updated by the flow accordingly with the date of reminder

After numerous tries with various flow parameters, my reminders are still failing to execute as required. Most common failure is related to the date the Reminder puts on the list. The dates, are not following the designated standard, but their chronology is mixed. 

 

MarioOne_0-1654064311007.png

 

MarioOne_1-1654064378061.png

 

MarioOne_2-1654064463253.png

 

MarioOne_3-1654064532744.png

My flow for Reminder 1:

MarioOne_4-1654064645661.png

 

MarioOne_5-1654064704455.png

Function there is: and(greater(dayOfWeek(utcNow()),0),less(dayOfWeek(utcNow()),7))

 

MarioOne_8-1654064932846.png

 

My condition is:

MarioOne_9-1654065034724.png

 

I am struggling to create a flow that will meet above criteria and execute on each record respectively.

Solution I believe will solve that would need to be constructed with following elements:

  1. Schedule run every 1 week on workdays (Mo-Fri) as Initial trigger
  2. Get items filtered ODATA Picked eq No
  3. Condition on Arrival if greater or equal Today -X (X a number of days for reminder)
  4. Send reminder email to Parcel Recipient
  5. Update List for Reminder 1 Field

My biggest concern is step 3 as I am lacking at the moment formula writing skills. Can you suggest a formula that can fix this issue?

I come across Add Days function but not sure on how to use it. I would love to hear from you. 

0 REPLIES 0

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,036)