I am trying to set up a power automate flow to move a file from one directory to another. The file that I am moving has a naming convention that is consistent with the exception of the date attached for each day the file is generated.
In theory this is fairly simple, here are the steps I am taking.
1. Get current date and time - Variable result = 11/24/2022 12:00:00 (I suspect Power Automate is adding the time but should not be since I am only asking for the date to be retrieved)
2. convert datetime to text - Variable result = 11/24/2022
3. format date - Variable result = 20220024 which is incorrect(YYYYMMDD)
The same result occurs when I change the format to MMDDYYYY or MM/DD/YYYY
I am sure I am missing something simple but Any help to a fix would be greatly appreciated
Thank You,
Demuris