returning condition for a date 1 year ago from utcNow

(0) Share

Report

Posted on by beginnerMike

My flow is working but it is not returning any true conditions. my date columns are as follows

join date

2023-05-23
2023-12-12
2023-04-29
2023-05-24
2025-05-22
2023-04-25
2024-01-02
2023-05-22
2021-12-23
2023-05-21
2024-01-01
2023-04-05
2022-10-10

My condition functions are:

addDays('1899-12-30',int(items('apply_to_Each')?['join date]))

is equal to

addToTime(utcNow(),-1,'Year','yyyy-MM-dd')

Could you tell me what is wrong? Why are all rows in the excel file returning false?

I have the same question (0)

All responses (1)

Answers (0)

creativeopinion 10,480 Super User 2025 Season 2 on at

Like (0)

Report
Re: returning condition for a date 1 year ago from utcNow

@beginnerMike To troubleshoot your Condition, add Compose actions above your condition action to output the dynamic content you are using in your Condition.

In this case, you need a Compose action to output:

addDays('1899-12-30',int(items('apply_to_Each')?['join date]))

and

addToTime(utcNow(),-1,'Year','yyyy-MM-dd')

Review the outputs from your Compose actions to see if they are in fact equal to each other. If not, you'll need to adjust your expression so they are. The equals to operator is looking for an exact match.

I cover how to troubleshoot a condition action in the first section of this YT Tutorial: 5 Power Automate Troubleshooting FAQs and Helpful Tips for Creating Better Flows

In this Power Automate tutorial, I explore 5 frequently asked questions that pop up when troubleshooting a flow. If you’d like to to level up your Power Automate flow skills and learn how to troubleshoot your Power Automate flow—this tutorial is for you!

IN THIS VIDEO:

✅ How to troubleshoot a false Condition action result

✅ How to get dynamic content when it isn’t selectable from the list of dynamic content

✅ How to troubleshoot an Apply to Each action that isn’t looping through

✅ How to troubleshoot a skipped Apply to Each action

✅ How to troubleshoot a Filter Query

✅ How to use a SharePoint yes/no column in a Filter Query

✅ How to use Compose actions to troubleshoot a Power Automate flow

✅ How to troubleshoot multiple emails being sent

✅ How to troubleshoot multiple Teams messages being sent

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram

Was this reply helpful? Yes No