[Problem Solved] How to write date with right format in Excel using Microsoft Power Automate Desktop
[Problem Solved!] How to write the date with correct formatting in Excel using Microsoft Power Automate for Desktop
In this video, we are going to teach you how to write the date with correct formatting to Excel using the Write from Excel worksheet action. There are 2 possible scenarios - the date field in Excel can be formatted as dd/mm/yyyy or mm/dd/yyyy. In the first case, you will use the Convert datetime to text action to convert the datetime to the custom format yyyy-MM-dd 00:00:00. Whereas for the second case, you will use the custom format yyyy-dd-MM 00:00:00.
00:00 Introduction
00:13 The scenario
02:15 Case 1 - Write to Excel as dd/mm/yyyy
03:40 Case 2 - Write to Excel as mm/dd/yyyy
Related videos of concepts used in this video:
• Excel automation playlist: • Power Automate Desktop Excel Automati...
Keep in touch!
Website https://mspowerautomate.com/
Twitter / msautomate
Facebook / ms-power-aut. .
LinkedIn / power-aut. .
#RPA #PowerAutomateDesktop #RoboticProcessAutomation #PowerAutomate #ExcelAutomation
Смотрите видео [Problem Solved] How to write date with right format in Excel using Microsoft Power Automate Desktop онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь MS Power Automate 25 Август 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 3,876 раз и оно понравилось 34 людям.