Comparing two columns in a SharePoint list

(1) Share

Report

Posted on by Aye3

Hello!

I want to send a reminder email if the status of quote status hasn't been changed to in progress in three days. In my flow, I am using the following columns: Quote status, last modified and reminder date (when the item is created + 3) in a condition statement. However, comparing last modified and reminder date is making the condition come out as false. How can I fix that?

Categories:

Business Process Flows

All responses (4)

Answers (0)

Aye3 44 on at

Like (1)

Report

Comparing two columns in a SharePoint list

I didn't use the compose action, so I will try that. Thanks!
Nived_Nambiar 17,786 Super User 2025 Season 1 on at

Like (0)

Report

Comparing two columns in a SharePoint list

So once you execute flow run, did you check what are values of Last Modified date and reminder date used in condition ?

Use compose action to see what is the value of both dynamic contents ?
Aye3 44 on at

Like (0)

Report

Comparing two columns in a SharePoint list

Hi @Nived_Nambiar

It depends because the person who submitted the quote or the person managing the quote may edit the item on the list.
Suggested answer

Nived_Nambiar 17,786 Super User 2025 Season 1 on at

Like (0)

Report

Comparing two columns in a SharePoint list

Hi,

looking at some values as shared in screenshot, Last modified date is not seems to be equal to reminder date for every item - is that true ?

Thanks & Regards,
Nived N
LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs
Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you!