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.

 

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

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

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

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (4,360)