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. ☕💖
https://buymeacoffee.com/michaelalex
🪙BTC🪙: 3LpmcBaJB537RweJu2tRjSqT6NhnQDDBWy
⛓️ETH⛓️: 0xbAEb6d6Df7CE5cfC55797B3133342e165B78A444
🐕DOGE🐕: DNKNUduorzBWMJ4XTSRqUSsUKk3ZiehHin
#powerautomate #microsoftflow #flow
