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:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
Aye3 44 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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 ?

Was this reply helpful? Yes No
Aye3 44 on at

Like (1)

Report
Copy link

Link copied!

I didn't use the compose action, so I will try that. Thanks!

Was this reply helpful? Yes No