Answered

Copied flow and not working

(0) Share

Report

Posted on by MSPower12345

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.

Screenshot 2024-05-21 at 1.12.50 PM.png

This is the format of the birthday in list 1

Screenshot 2024-05-21 at 1.13.39 PM.png

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?

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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,

Was this reply helpful? Yes No
MSPower12345 4 on at

Like (0)

Report
Copy link

Link copied!

Hilariously, it was actually simpler than that. Some of the dates (3 to be exact) were converted to strings. That was it!

Was this reply helpful? Yes No