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
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

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

Users online (1,396)