You’re offline. This is a read only version of the page.
74
Hi,
I did a small experiment, through Power Automate Automate I'm getting the Current Date Time and Writing in New Excel Workbook in several different ways to test the format logic.
CurrentDateTime Variable in the format day/month/year (this was standard from the respective action to get Current Date Time):
How it appears in Excel after Writing action:
Column format in Excel is set automatically to Custom:
With the following custom format (day/month/year):
So as far as I can tell:
| Value in Power Automate Desktop | Value in Excel | |
| Day | 09 (ok) | 05 (nok) |
| Month | 05 (ok) | 09 (nok) |
There is a mismatch between PAD and Excel. Any tips? Maybe this is related with some regional settings from the machine I'm running it?
Thanks,
Bernardo
Just a quick update that fixed my problem: add a ' sign before the variable to write:
With this method, Excel assumes the format as text, and it's fine for me.
Cheers
Share
Report
All responses (
Answers (
