Forum Discussion
Akshadaks
Feb 17, 2025Copper Contributor
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"
- Date_x002d_Draftentrysubmitted eq '@{formatDateTime(addDays(convertTimeZone(utcNow(), 'UTC', 'New Zealand Standard Time'), -3), 'dd-MM-yyyy')}' and Status eq 'Draft - Not Submitted'
- 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