cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Art_Ratta
Resolver I
Resolver I

Sending email if items in SharePoint list not modified

Dear Community

Please help to check my flow  not working as expected after testing flow run success but email not sending

 

Requirement : 

My list have status and modified column (Modified is a defaults in a list)

if items not any modified in 1 days and check with status column --> flow will send email reminder.

 

Thank youFlow1.JPGFlow2.JPGFlow3.JPG

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
jinivthakkar
Super User
Super User

Take two variable - one for created and one for modified format as below(can remove the hh:mm:tt 

formatDateTime(outputs('Get_item')?['body/Created'],'yyyy-MM-dd hh:mm:tt')

OR 

formatDateTime(outputs('Get_item')?['body/Created'],'yyyy-MM-dd') 

 I would prefer second.

 

Compare and then send notification as required.

 

View solution in original post

it's seem look like working , thank you for your suggestions.

View solution in original post

6 REPLIES 6
jinivthakkar
Super User
Super User

What is the condition, please can you share a screenshot of the condition block.

The condition was not satisfied hence it is not sending email.

@jinivthakkar  here is my reply 

I set condition as picture 

1.  Filter Query : Modified date less than addDays(utcNow(),1,'d')

2.  Condition block : Get Value form sharepoint list item

     Flow4.JPG

How Can I fix it, please

Sorry I can't reply in your post

jinivthakkar
Super User
Super User

The condition Modified le 'addDays(utcNow(),1,'d')' is wrong according to me because whenever you run the flow the condition will not be satisfied Modified will always be less than utcNow+1

 

Shouldn't you checking modified gt created+1 ??

 

 

 

 

 

Thank you for your suggestion , Could you please help to share expression or condition?

jinivthakkar
Super User
Super User

Take two variable - one for created and one for modified format as below(can remove the hh:mm:tt 

formatDateTime(outputs('Get_item')?['body/Created'],'yyyy-MM-dd hh:mm:tt')

OR 

formatDateTime(outputs('Get_item')?['body/Created'],'yyyy-MM-dd') 

 I would prefer second.

 

Compare and then send notification as required.

 

View solution in original post

it's seem look like working , thank you for your suggestions.

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,378)