Sending email if items in SharePoint list not modified

(0) Share

Report

Posted on by Art_Ratta

154

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 you

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (2)

jinivthakkar 4,187 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Art_Ratta 154 on at

Like (0)

Report
Copy link

Link copied!

@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

How Can I fix it, please
Sorry I can't reply in your post

Was this reply helpful? Yes No
jinivthakkar 4,187 on at

Like (0)

Report
Copy link

Link copied!

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 ??

Was this reply helpful? Yes No
Art_Ratta 154 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

jinivthakkar 4,187 on at

Like (0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
Verified answer

Art_Ratta 154 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No