date time format P. Automate

%3CLINGO-SUB%20id%3D%22lingo-sub-2153729%22%20slang%3D%22en-US%22%3Edate%20time%20format%20P.%20Automate%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2153729%22%20slang%3D%22en-US%22%3E%3CDIV%3EHi!%20I've%20a%20question%20regarding%20date%2Ftime%20format%20in%20power%20automate.%20I%20have%20created%20a%20flow%20that%20starting%20from%20an%20excel%20it%20sends%20directly%20different%20invitations%20to%20people%20in%20the%20excel%20list.%20Everything%20work%20fine%2C%20but%20the%20data%20format%20in%20p.%20Automate%20is%20not%20the%20one%20we%20usually%20use%2C%20its%20like%20date%2Btime%20in%20the%20same%20field%2C%20like%20%3A%20%222021-08-29T04%3A00%3A00%22.%20So%20the%20flow%20only%20works%20if%20i%20use%20that%20format%20in%20the%20excel..%20but%20the%20excel%20exist%20already%20with%20one%20column%20for%20date%20and%20one%20for%20time%20(date%3A%202021-12-1%2C%20time%20in%20another%20column%2018%3A30%20)..%20it%20would%20be%20a%20big%20effort%20change%20all%20the%20dates%20in%20the%20excel%20in%20order%20to%20be%20in%20the%20correct%20form%20for%20power%20automate%20(and%20there%20would%20be%20no%20benefit%20for%20the%20automation..%20the%20time%20i%20save%20is%20the%20time%20needed%20to%20change%20date%20time%20format%20in%20excel).%20Is%20there%20a%20way%20to%20convert%20the%20date%20time%20whithin%20power%20automate%3F%20Thanks%20in%20advance.%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2153729%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor
Hi! I've a question regarding date/time format in power automate. I have created a flow that starting from an excel it sends directly different invitations to people in the excel list. Everything work fine, but the data format in p. Automate is not the one we usually use, its like date+time in the same field, like : "2021-08-29T04:00:00". So the flow only works if i use that format in the excel.. but the excel exist already with one column for date and one for time (date: 2021-12-1, time in another column 18:30 ).. it would be a big effort change all the dates in the excel in order to be in the correct form for power automate (and there would be no benefit for the automation.. the time i save is the time needed to change date time format in excel). Is there a way to convert the date time whithin power automate? Thanks in advance.
0 Replies