Power Automate - Convert Excel Date Time and Save into SharePoint List Column & Email
ฝัง
- เผยแพร่เมื่อ 13 ต.ค. 2024
- In this video of power automate you will learn how to Convert your excel date time and save into a SharePoint List & send in email body as html table. Excel date time create issues when we try to fetch it with Power Automate in that situation this workaround can be very usefull. I hope you liked this video below is the formatdatetime formula which i have used in the video.
formatDateTime(item()?['Start time'],'MM/dd/yyyy hh:mm:ss tt')
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
Glad it helped!
Hi,
This is to extend my thanks for creating videos like above. It 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
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
Have you overcame this issue?
Solved my problem. You are the best!
YOU SAVED MY LIFE. THANK YOU!
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'."
This is what I was looking for a very long time and it worked perfectly! Thank You!
glad it helped you:)
Thank You!Really helpful
What extension are you using to view JSON in a friendly format?
nothing just my chrome browser
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 :)
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?
are you getting any error there?
Thank you so much for this Video. Helped me a lot :)
Glad it helped.
Thank you. I could not figure out why my flow was failing on the date import
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 :(
Great video
hi bro.. thanks for the video, but your solucion doesnt work in my flow :(, i keep getting the same message, about incorrect format :((
try again may be you might be doing some little mistake
Simplesmente Perfeito!!!
👍
Doesn't work at all. WHy is date time so complex!