Forum Discussion

Akshadaks's avatar
Akshadaks
Copper Contributor
Feb 17, 2025

Create notification reminder based on date and status

Dear Team,

 

I am trying to create a Power automate flow on sharepoint list based on the below requirements.

Requirement:

      • GIVEN I have created an item in a “Draft Not Submitted” status
      • WHEN the date created column  "Date - Draft entry submitted" for the item is 3 days before today’s date
      • THEN trigger a reminder notification to the creator after 3 days

Details:

  • SharePoint internal column names
    • "Status"
    • "Date_x002d_Draftentrysubmitted"

 

I have created the following flow

  • In "Get Items" > Filter Query I have used - 
    • Date_x002d_Draftentrysubmitted eq '@{formatDateTime(addDays(convertTimeZone(utcNow(), 'UTC', 'New Zealand Standard Time'), -3), 'dd-MM-yyyy')}' and Status eq 'Draft - Not Submitted'
      • This is because the Local setting is set for NZTA and the date format in the SharePoint column is in "dd-MM-yyyy"

  • In "Condition" I have used - 
    • formatDateTime(item()?['Date_x002d_Draftentrysubmitted'],'dd-MM-yyyy')
    • is equal to 

    • formatDateTime(addDays(convertTimeZone(utcNow(), 'UTC', 'New Zealand Standard Time'), -3), 'dd-MM-yyyy')
  • Then there is another condition to check the status
    • Dynamic "Status/Value" is equal to "Draft - Not Submitted"

But the about flow is not working.

Not sure what I am doing wrong. Request for your help.

Regards

No RepliesBe the first to reply

Resources