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)
Example:
> 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.
Hi @AK007
Without seeing the data its difficult to predict what's causing this. Could you expand your run history steps and post a screenshot.
Thanks
@abm Thanks for the reply, I ran a test run with file name "Taxation" and it still wasn't working.
Hi @AK007
Thanks for your reply. Check your filename. Looks like you have some invalid characters.
Thanks
Hi @abm
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
Hi @AK007
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.
Thanks
Hi @abm
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.
Hi @AK007
Please have a look at my tutorial video.
If you need any further help please let me know.
Thanks
Michael E. Gernaey
566
Super User 2025 Season 1
David_MA
516
Super User 2025 Season 1
stampcoin
492