Power Automate - Convert Excel Date Time and Save into SharePoint List Column & Email 

I never usually comment or like videos, but just saved me soooo much time instead of converting columns into text in the excel...

Perfectly explained, thx for saving me more hours of frustration trying to solve the format issue.

Thank you! I was fighting the date problem quite some time before I found this video.

OMG. I've been looking for this information for two hours now. That simple. It was just to change in the flow "list rows present in a table" Thank you very much

Hi, This is to extend my thanks for creating videos like above. It helped me a lot.

Hi Bro, thanks for the video. In the List rows present in a table, I have selected the DateTime Format is ISO 8601, but after that also, I am getting the date as a decimal number only. Actually, I also have several empty columns in my date column. Thanks

YOU SAVED MY LIFE. THANK YOU!

Solved my problem. You are the best!

This is what I was looking for a very long time and it worked perfectly! Thank You!

I am using my list time as IST time which is UTC +5:30 in case you need same result in your list you can change your site regional setting to UTC 0 or convert it to your timezone specific requirement :)

Thank You!Really helpful

Thank you. I could not figure out why my flow was failing on the date import

Great video! Only an error for me and don't know how to fix it: "The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/field_3' is required to be of type 'String/date-time'. The runtime value '""' to be converted doesn't have the expected format 'String/date-time'."

Thank you so much for this Video. Helped me a lot :)

Hello, Thanks for the beautiful video! I need to get clarity for a question from you. I have an Excel file with a couple of columns, kept the file in SharePoint location, and with the help of list rows present in a table operation trying to read data from the Excel file with date format as "ISO 061", the output looks like "Joining Date": "2021-01-18T00:00:00.000Z" but I need only the date and month from above value Expected output - "01-18". How do I need to specify the condition in ''Enter custom Value" to get the desired output

Great video

What extension are you using to view JSON in a friendly format?

whatever i do i always getting this error: is required to be of type 'String/date-time'. The runtime value '"45333.9166666667"' to be converted doesn't have the expected format 'String/date-time'. i made it with ISO 8601 and without, nothing worked :(

👍

Hi Lernen Tech, thanks for this video. I have a similar case but who to over come the same scenario if few rows contains blank? Could you pls help here?

Simplesmente Perfeito!!!

hi bro.. thanks for the video, but your solucion doesnt work in my flow :(, i keep getting the same message, about incorrect format :((

Doesn't work at all. WHy is date time so complex!