You’re offline. This is a read only version of the page.
62
when i try to run my flow, it does not work. i have the column as expiry Date and it is a date and time type column.
it used to work, however, i have not changed anything and now it does not
any help would be great
Hello, @cheers1903
If your SharePoint column is ‘Date Only’, you should use date without time in the filter too. Since SharePoint will provide dates in ISO 8601 format, use the same format also for the ‘Value’. For date only column it means the format year-month-day: ‘yyyy-MM-dd’.
Consider the following example:
Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.
Happy Automating,
Edgar Simões
Unfortunately your filter query will not work properly unless the date you provide is formatted as yyyy-MM-dd as that is how SharePoint stores dates internally regardless of your regional settings.
i changed the format of the date to ddmmyyy as we do not show it the other way around. In the HTML table is put the formate date to
SharePoint expects that all dates will be formatted as yyyy-MM-dd
You can use an expression in your filter query to format the date:
formatDateTime(YourDate,'yyyy-MM-dd')
#1
WarrenBelz
146,524
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,906
Most Valuable Professional
Share
Report
All responses (
Answers (
