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)

Suggested answer

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

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

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,129 Super User 2025 Season 2 on at

Like (0)

Report

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

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

Was this reply helpful? Yes No