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
Resident Rockstar
Resident Rockstar

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
Resident Rockstar
Resident Rockstar

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
Resident Rockstar
Resident Rockstar

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
Resident Rockstar
Resident Rockstar

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
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,257)