Using Filter Query to retrieve items within a set date range

[JWhit_7]

I am creating an archiver for a MS List I have set up so the data runs more smoothly. I would like to run this every week and use Filter query in the Get items action retrieves items where the 'Exam start date' is over 45 days ago.

I have tried using the expression formatDateTime(addDays(utcNow(),-45),'dd/MM/yyyy') but I am getting this error message:

The expression "Exam start time lt '02/02/2024'" is not valid. Creating query failed.
clientRequestId: 7eb9dfd2-1a6b-458a-b5ff-2cae9094ee72
serviceRequestId: 7eb9dfd2-1a6b-458a-b5ff-2cae9094ee72

The date is formatted 'dd-MM'yyyy' in the MS List I am asking it to pull from. Can anyone make any suggestions to where I am going wrong?

[creativeopinion · Accepted solution]

 You will need to use the internal column name of your Event Start Time column. Keep in mind that the internal column name may not always match the name displayed in your Sharepoint list. If you aren't sure how to get the Internal Column name, you can refer to this section of one of my YT Tutorials.

You might find my tutorial helpful: Send Emails Based on a 📆 Date Column in SharePoint with Microsoft Power Automate

In this Microsoft Power Automate tutorial, I’ll show you how to build a flow that will send a Happy Birthday email to a user based on a date column in a SharePoint list. The SharePoint list also contains a column with a Manager’s name which we’ll use to send a three-day and day of reminder to the user’s manager.

This automation will use the Filter Array action to filter out all SharePoint list items where the user’s birthday is today or in three days. This flow can apply to a variety of scenarios such as:

📅 Student Birthdays

📅 Project Due Dates

📅 Contract/Membership Renewals

📅 License Expirations

📅 Client Anniversaries

---

IN THIS VIDEO:

✅ How to Send an Email based on a Date Column in SharePoint

✅ Using the Recurrence Trigger in Power Automate

✅How to Use the Filter Array Action with multiple conditions

✅ How to Get Dynamic Content from a Filter Array Action

✅How to Get a Date Three Days from Today

✅ How to Create a Dynamic Date Based on utcNow()

✅ How to Return a Count of Items

✅ How to initialize and set a variable

✅ How to use the Send an Email (V2) action

✅ How to send test emails

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

@JWhit_7

[JWhit_7]

Of course. Thank you