Unanswered

Bi-Weekly reminder from excel spreadsheet

(0) Share

Report

Posted on by PALewis

I have a spreadsheet with a list of vehicles and when they have checks due, I would like to have a check every other week to see if any of these vehicles will need checks within the next two weeks and send an email with the details of which vehicle has upcoming checks. I just can't seem to get it to recognise the dates which I believe is because one is a string value and the other is integer. Screenshots attached

Categories:

Building flows

Screenshot 2023-1...

I have the same question (0)

All responses (2)

Answers (1)

David_MA 12,966 Super User 2025 Season 2 on at

Like (0)

Report

The issue you are most likely having is that the dates are not in ISO 8610 date format. All of the dates need to be in this format to use it in a condition. You can use the formatDateTime function to transform your dates into this format, which is yyyy-MM-dd.

Was this reply helpful? Yes No
Verified answer

efialttes 14,756 on at

Like (0)

Report

Hi @PALewis
How do you represent dates in your Excel file? Can you share an exemple?
In the meantime, my two cents
-Either there is an issue with TimeZones, i.e. TimeZone provided by 'Get current time' by default is UTC, Zulu Time but Excel stored dates refer to local timezone that is not UTC; or...
-there is an incompatibility between 'Get current time' format (wich is ISO 8601 format, for example 2023-10-23T15:00:44T) and the way you store dates in your excel.

If you just set your excel column of type date, you can instruct 'List rows present in a table' to represent such dates in ISO 8601 format also (click on Show advanced options-> select ISO 8601 as Datetime format)
If not, you will need to add some formatting steps to your flow
You will find good stuff here
https://tomriha.com/how-to-get-date-from-excel-as-a-date-in-power-automate-flow/
Hope this helps
===========

Was this reply helpful? Yes No