String was not recognized as a valid DateTime.

[Bitofanoob]

Hello

Pretty new to PA and wanting to automate an update a calendar from an Excel sheet. These could contain anything from 100-400 rows of events.

I've been trying to get the format correct in Excel as I'm not sure how to do this in PA. But seem to but having trouble. Im assuming its the mm (instead of MM) in month.

Pics to help i hope.

Excel date format

Event information

Flow build

(possible issue) lower case MM in date format maybe reading as Minutes and not months in pull over to PA?

Any advice would be greatly appreciated 🙂

[v-bofeng-msft · Accepted solution]

Hi @Bitofanoob ,

Please set the datetime format to ISO 8601

Best Regards,

Bof