cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Rob_CTL
Level: Powered On

SharePoint Get Items Filter Query Date format issues

Hi,

 

What I though would be simple thing to do is causing me to pull my hair out! 🙂

 

Flow Requirement:

 

- Run against a SharePoint list once a week and return all the items that are newer than a predetermined date.  The SharePoint list column is a standard "Date" column, and this regional settings are UK (dd/mm/yyyy) format

 

Flow Configuration:

 

- Get Items looks up in list with the following filter query configuration

-- Get items that have a date newer than 1st October 2019

-- In an attempt to ensure that the date is read in the right format I've created the express as below

 

flow-spdate1.png

 

Flow Output:

 

The filter query has the wrong date, it's changed to MM/dd/yyyy so the wrong items are retrieved from the list.

 

flow-spdate2.png

 

I've played around with query filter and it constantly changes the date to MM/dd/yyyy format when the flow runs.....argh!

 

Any help gratefully received....or I might need to go hat shopping very soon 🙂

 

Rob

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: SharePoint Get Items Filter Query Date format issues

formatdatetime expects the input mm-dd-yyyy so when you convert it, that is why it is flipped because it thinks you have entered the 10th of January. Just switch the date format around in the first part of your express

View solution in original post

2 REPLIES 2
Super User
Super User

Re: SharePoint Get Items Filter Query Date format issues

formatdatetime expects the input mm-dd-yyyy so when you convert it, that is why it is flipped because it thinks you have entered the 10th of January. Just switch the date format around in the first part of your express

View solution in original post

Rob_CTL
Level: Powered On

Re: SharePoint Get Items Filter Query Date format issues

@Gristy thanks for that, I thought I had tried that already and making the changes as you suggested has changed the output value

 

flow-spdate3.png

 

However it looks like the formatting wasn't my issue, as the flow is seems to be ignoring this filter query completely and is still returning the wrong items.  Remember when IT used to be straightforward.....

 

Rob

 

Edit: go this working by clearing out the formula, saving the flow then re-inserting the formula

 

Helpful resources

Announcements
firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors
Users online (5,968)