I am new with Power Automate Desktop and to this community. I am developing in a test environment my first complex bot consisting of about 70 activities. The process involves activities like signing-in to the websites, downloading docs, filling forms and logging data to Excel... I am near to the end since yesterday, but I am unable to finish due to a "text to DateTime conversion" 😞
The bot has copied from the web the DateTime string "Jan 24 11:31:35 2021" and is trying the action "Convert text to DateTime" ("Converti testo in DateTime", in the Italian language) to convert it to DateTime; therefore, I have set up the custom format "MMM dd HH:mm:ss yyyy" for the conversion. Unfortunately, it doesn't work: where am I wrong?
Might it depend on the language? My environment is in "Italian" and maybe this impacts on the bot that is unable to understand that "Jan" is the abbreviation of "Gennaio" in Italian in order to convert it to the month MM = 01. Any suggestions in order to solve?
I hope this issue is not too trivial 😉 anyway, I am learning.
Kind regards,
Roberto

Report
All responses (
Answers (