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!!!
@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!
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?
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...
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
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 ?
![CAMPปลิ้น | รวม Highlight 2024! PART [1/2]](http://i.ytimg.com/vi/6hnvNnvYloU/mqdefault.jpg)
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!!!
THANK YOU FOR THIS
Thank you sooooo very much. This was sooooo helpful. Been struggling for days! Wish I could hit "like" 1,000 times.
Worked like a charm. Thanks for this video, you saved me a lot of headaches!
You're welcome!
Thanks Bro
@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!
Thanks for the info. Usually when the first row isn't filled with a date either it doesn't work. I'll have to try your way
Perfect. Good explanation thanks
Thank you so much for the formula.
You are so welcome!
Wow!! SUPER!!! Thank you.
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?
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...
Glad it was helpful!
how to change format to dd-MM-yyyy when i'm change flow will be error
thank you!
You're welcome!
Is this working in update item in Sharepoint list?
Yeah, it could work for that
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
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 ?
Sure, check out my latest video.
@@michaelalex2322 thanks for the video update on renaming teams recordings from longdate to shortdate
Np, thanks for the idea!
Usefull
Glad to hear that