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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Filter get items by to...
Power Automate
Unanswered

Filter get items by todays date error

(0) ShareShare
ReportReport
Posted on by 76

Hi everyone,

 

I have been using some other forum posts to build a flow that filters calendar items by todays date and then checks if all values have been received.

 

For example; every day all 5 people need to submit a request. I need my flow to filter by todays date then check that every person name has an event for that day. I have my start date and end date which include time values. However I have created a third column (Date of drive) which is just date to make life easier.

 

Currently I have this in the filter query of get items:

Date_x0020_of_x0020_drive eq @{formatDateTime(utcNow(), 'yyyy-MM-dd')}

 

This is returning an error though. If I run just a get items with no filter query, the Date_x0020_of_x0020_drive column comes back as 2024-05-22 so I am not sure why the above is failing.

 

Your help is much appreciated.

 

Thanks

Categories:
I have the same question (0)
  • creativeopinion Profile Picture
    10,502 Super User 2025 Season 2 on at

    @Georgia12 Is your flow failing or is the Get Items action not returning any items? If you are getting an error, can you share a screenshot of the error?

     

    In the meantime, you might find these YT Tutorials helpful: 

     

    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

     

     

    ---

     

    How to Work with 📆 Dates in Power Automate | Example Scenarios and Tips & Tricks

    Are you easily stumped when working with Dates in Power Automate? In this Power Automate tutorial, I’ll show you how to compose an expression that will return a future date, a past date, how to count the number of days between two dates, how to check for a birthdate and anniversary date as well as tips and tricks when working with dates in Power Automate.

     

    I’ll cover some common use cases and concepts that can help you to build better Power Automate flows. Feel free to skip ahead using the timestamps listed below. I’ve also linked a few other tutorials that you might be interested in as well.

     

    IN THIS VIDEO:

    ✅ 4 Date Functions You Need to Know

    ✅ How to use the Convert Time Zone Action

    ✅ How to Get a Future Date

    ✅ How to Get a Past Date

    ✅ How to Return SharePoint Items Due in a Number of Days

    ✅ How to Return SharePoint Items Due within a Date Range

    ✅ How to write a Filter Query for SharePoint Items Due in 30, 60 and 90 Days

    ✅ How to Calculate the Number of Days between Two Dates

    ✅ How to Check for a Birthdate and Anniversary Date

    ✅ How to work with Dates and Times in Excel

    ✅ How to use a Manual Trigger with Date Input

    ✅ How to Output Dynamic Text with an Expression

    ✅ How to Check if a Date Falls on a Weekend

     

    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

  • GGC21 Profile Picture
    76 on at

    Hi @creativeopinion 

     

    Thank you for your fast response. It's definitely failing, I will add in a screenshot of the error. Also there is definitely values equal to todays date for test purposes 

     

    Thanks

  • Verified answer
    creativeopinion Profile Picture
    10,502 Super User 2025 Season 2 on at

    @Georgia12 You're missing single quotes quotes around your date. Ensure you have wrapped your dynamic date content with single quotes.

    creativeopinion_0-1716341323433.png

     

    Tip: Add a Compose action after the Get Items action to output the number of items returned from your Get Items action. I demonstrate that in this section of a tutorial.

     

    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

     

  • GGC21 Profile Picture
    76 on at

    Amazing thank you!

     

    Of course the easiest solution ever!

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 523 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 406 Moderator

#3
abm abm Profile Picture

abm abm 245 Most Valuable Professional

Last 30 days Overall leaderboard