Hi @Karinka ,
About the folder from OneDrive to SP you are correct: Power Automate accepts only the files. However, when moving your files to SP, you do not need to create the folder previously: if the folder does not exists and you pass it as a path in the "Create file" action, it automatically generates the folder. Check the example below 🙂
About the MB limitation, you are correct. Apparently the trigger won't even be called if you have a file larger than it!
Overview:
I have a folder in OneDrive (origin) containing some subfolders with the same name convention as yours (date in format yyyy-MM-dd). Initially, all subfolders are empty, and my goal is to automatically move any file created inside these subfolders from OneDrive to SharePoint, in a folder called "landing folder". Inside "landing folder", I want to keep the same subfolder structure: if I create a file inside the subfolder "2023-06-27" in OneDrive, I want it to be replicated in a subfolder also called "2023-06-27" in SharePoint.
OneDrive:
SharePoint:
Step 1 - Trigger:
As mentioned before, we will use a 'When a file is created' trigger, passing the parent folder as input (in my case, the folder called 'origin') and assigning the 'Include subfolders' option as 'Yes':
Step 2 - Getting new file details
Our trigger does not return the details from the new (full path, file name), so we need to use 'Get file metadata' action from OneDrive connector to get it. Also, to insert the file into SharePoint, we will need to copy the file content, by using the 'Get file content' action. Both actions use the same input: the File Identifier extracted from trigger:
Step 3 - Isolating the subfolder path:
As we want to keep the same subfolder structure, we need to extract it from the file path. To achieve this, we need to use a text expression that will remove either the "file name" and the folder path between OneDrive root and our parent folder.
For example, if I create a file called 'Document.docx' in '2023-06-27" subfolder, the file path returned in 'Get file metadata' action will be '/Community/origin/2023-06-27/Document.docx', and from that I only want to extract the '2023-06-27/':
So we will initialize a string variable (I called it 'relative_path') and use the following expression:
replace(last(split(outputs('Get_file_metadata')?['body/Path'], 'origin/')), outputs('Get_file_metadata')?['body/DisplayName'], '')
For your use case, make sure to replace the highlighted text for:
- Green: File path from 'Get file metadata' action (you can get it dynamically)
- Red: Your parent folder name
- Blue: Display name from 'Get file metadata' action (you can get it dynamically)
Step 4 - Create the file in SharePoint:
Finally, we will use a 'Create file' action from SharePoint connector passing your parent folder in SP as input, and connecting it with 'relative_path' as dynamic content. As file name, we pass the 'File name' dynamic content from 'Get file metadata' action, and as file content we pass the 'File content' dynamic content from 'Get file content' action:
Final result
To test the flow, I created a new file into '2023-06-27' subfolder in OneDrive:
It automatically created the '2023-06-27' subfolder in my 'landing folder' from SharePoint
And stored a copy of the OneDrive file inside it:
This is the complete flow design:
Let me know if it works for you or if you need any additional help!
-------------------------------------------------------------------------
If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.
adsfsasad
