You’re offline. This is a read only version of the page.
4
I added a new list with the same columns to Sharepoint and created an identical flow, but the new flow is not working.
It's pretty simple—it looks at a list, extracts the birthday, converts it to day/mo, compares that with today, and then, if it's a match, sends an email. The second flow is identical. The only variable that changed was the list, but the list format is the same.
The error is: Unable to process template language expressions in action 'Birthday_Month_Day' inputs at line '0' and column '0': 'In function 'formatDateTime', the value provided for date time string '25639' was not valid. The datetime string must match ISO 8601 format.'.
I don't know where it would have gotten a random 5-digit variable from.
This is the format of the birthday in list 1
This is the format of the birthday in list 2.
I assume it has something to do with the format, but in excel, they were both formatted short date the exact same way, but when I uploaded, they didn't upload the same. Thoughts?
Hilariously, it was actually simpler than that. Some of the dates (3 to be exact) were converted to strings. That was it!
Hi @MSPower12345 ,
Based on my test, you created the new list from excel table but used wrong column type.
Besides, I found a case in SharePoint community, which said that if in Excel table there are more than 4 date columns, the list will create wrong type column. Is it the same situation as yours?
Invalid date format while importing from excel to sharepoint list - Microsoft Community
Best regards,
#1
WarrenBelz
146,635
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,997
Most Valuable Professional
Share
Report
All responses (
Answers (
