How to Convert a Serial Number to ISO 8601 Date in Power Automate | 2022 Tutorial

Hi Everyone,

In this video, I demonstrate how to convert a Serial Number into a ISO 8601 usable date in Power Automate. I was running into an issue using an Excel connector where it didn't wanna convert and wrote a custom expression to do it.

Custom Expression (Replace Birthday if using an Apply to each else enter into dynamic content):

if(equals(items('Apply_to_each')?['Birthday'],''),null,formatDateTime(addDays('1899-12-30',int(items('Apply_to_each')?['Birthday'])),'yyyy-MM-dd'))

If you enjoy the video feel free to like, comment, and subscribe!

✨Support My Channel✨

If you enjoy my content and would like to support my work, consider buying me a coffee! Your support helps me create more videos and keep the channel going. ☕💖

🪙BTC🪙: 3LpmcBaJB537RweJu2tRjSqT6NhnQDDBWy
⛓️ETH⛓️: 0xbAEb6d6Df7CE5cfC55797B3133342e165B78A444
🐕DOGE🐕: DNKNUduorzBWMJ4XTSRqUSsUKk3ZiehHin

#powerautomate #microsoftflow #flow

[PauloNeto-sd]

This worked for me and I am super glad that you showed this to us. I was smashing my head against the table to try to format date info from Excel to be resued within the action in my automation flow, but nothing was working. This worked perfectly.

Thank you!!!

[BP_RoadRunner]

Thank you very much. This was helpful. Been struggling for days! Wish I could hit "like" 1, 000 times.

[Sploits]

Worked like a charm. Thanks for this video, you saved me a lot of headaches!

[amoskrahn]

@michaelalex2322 Power Automate can get the date from Excel in ISO 8601 format - if the Date column is the first column in your table. If it is not the first column, then it has sometimes worked and other times not in my experience. I recommend moving your date column to be the first column in your table when you can, but this expression is great for when you need it!

[thomasboeve]

Hey super clear video thank you so much! I was trying to create events from in my outlook calendar from two excel dates, and i was wondering how the formula would change if we added hours and minutes. My own tries have failed so far...

[Nils_m]

For some reason I have the same problem where Excel always reads in the data in Serial Number format.... in certrain workflows hvae you figured out a different fix by now?

[sreejithkayes]

I tried this inside a condition with no luck. Is there a way to do it inside a condition. I want to send an email if one condition is met, but unable to cinvert the date inside the condition

[luwk]

I have noticed when recording microsoft teams and it saves to onedrive it save the date in long date format instead of iso 8601 format.

Is there any chance of showing how to setup power automation to convert long date format to iso 8601 and keep title of the recording ?

[igauntarathorn]

how to change format to dd-MM-yyyy when i'm change flow will be error

[johnarkdelossantos]

Is this working in update item in Sharepoint list?