web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / returning condition fo...
Power Automate
Unanswered

returning condition for a date 1 year ago from utcNow

(0) ShareShare
ReportReport
Posted on by

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?
Categories:
I have the same question (0)
  • creativeopinion Profile Picture
    10,502 Super User 2025 Season 2 on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard