cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Bitofanoob
New Member

String was not recognized as a valid DateTime.

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

Bitofanoob_0-1668729565633.png

 

Event information

Bitofanoob_1-1668729565640.png

 

Flow build

Bitofanoob_2-1668729565641.png

 

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

Bitofanoob_3-1668729565642.png

 

Any advice would be greatly appreciated 🙂

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-bofeng-msft
Community Support
Community Support

Hi @Bitofanoob ,

 

Please set the datetime format to ISO 8601

vbofengmsft_0-1668738551672.png


Best Regards,

Bof

 

View solution in original post

1 REPLY 1
v-bofeng-msft
Community Support
Community Support

Hi @Bitofanoob ,

 

Please set the datetime format to ISO 8601

vbofengmsft_0-1668738551672.png


Best Regards,

Bof

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (3,201)