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 Output:
The filter query has the wrong date, it's changed to MM/dd/yyyy so the wrong items are retrieved from the list.
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
