I need to move a specific files with name "Rack_SKU_##_DD_MMM_YYYY_HH_MM_SS" pick the files from a shared drive location and move to SharePoint folders. This folder has other files as well. While moving this to the destination sharepoint,
Month_Year based on current date should be picked and uploaded to sharepoint location.
Year and Month sub-folders to be created in the sharepoint if not already available
(Calculation should be based on month Present in file name minus 1)
> If Current Month is April 2022, the folder created should be 2022/Mar
> If Current Month is January 2022, the folder created should be 2021/Dec
Appreciate all your help here.
Solved! Go to Solution.
@abm A little tweak in the ask, it doesn't have to read the dates from file name, we can simply take current date and minus 30 days from it while creating the folder in sharepoint.
Say, the file was extracted today, 20th Apr, it needs to get copied in Mar 2022 folder on the sharepoint.
Thanks for your assistance here.
I will be picking up the file from shared drive and not one drive.
Also, there are other files on the shared drive, i want the flow to specifically pick "Rack_SKU_##_DD_MMM_YYYY_HH_MM_SS" files. Can you please help me further on this one?
Thanks in Advance.
So after the trigger add an IF condition action step to check the file name contains Rack_SKU_##. Here you can't check the full filename because of different date and time.
The above solution worked, thank you very much
but i'm running into a problem while creating folder in the sharepoint.
it is throwing "Invalid Character in Create File in Sharepoint Document Library" error.
below is the error
Without seeing the data its difficult to predict what's causing this. Could you expand your run history steps and post a screenshot.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.