You’re offline. This is a read only version of the page.
22
Hi,
I have a flow which is working which will auto send email for Due Date within 30 days.
But when I replaced with the a different excel file. The date format is not ISO 8601 so the rest of my flow does not works.
Anyone could advise how to get the Due Date to become ISO 8601
Hi @Sundeep_Malik ,
I have tried the code with the empty date. But it failed at row 5, which the cell contains '-'.
May I know how to handle '-' and blank date as well ?
Also after the Due Date is converted from the string, I would like to use filter array to filter out those with blank and cell with '-' and Due date within 30days.
Can i know if the converted dates can be apply using the below filter array expression.
@if( not(or(equals(item()?['DueDate'],'-'),equals(item()?['DueDate'], ''))), less(item()?['DueDate'],formatDateTime(addDays(utcNow(),30),'yyyy-MM-dd')), false )
Hey @Wolfie82
I will suggest the following post whenever you are using excel data with dates:
https://www.shanebart.com/ms-flow-excel-dates/
Video tutorial(Empty dates not handles so follow above link for it):
https://www.youtube.com/watch?v=uFZxXMuLj-E
I hope this helps 🙂
#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 (
