Power Automate - Copy file from Onedrive to SharePoint specific folder

This video explains how to copy a file from one drive to SharePoint specific folder.
Expression I used this video
formatDateTime(addDays(utcNow(),-30),'MMM-yyyy')
Microsoft Power Automate Community
powerusers.microsoft.com/t5/U...

[@coffeebeans6073]

Thanks for this - Was looking for a method to transfer data from my onedrive to a specific sharepoint folder - I have never used powerautomate, but this was explained well, so I think I am going to replicate this. Thanks!

[@abm4975]

Glad it was helpful!

[@marconeabdala8793]

Thanks for this!

[@abm4975]

Thanks for the support

[@lubeshbehera1993]

This is some good content!!👌

[@abm4975]

Thanks Lubesh for the support.

[@sebastianvaazquez4181]

great content! thanks!

[@abm4975]

Thanks Sebastian

[@imsupriya1999]

Hi, this is great! :) May I know if there is a way to pull the latest file created in OneDrive and save it into SharePoint - overwriting the current file (ie. current file saved in SharePoint is deleted and replaced with latest file pulled from OneDrive)? Thanks!

[@Saturn9177]

Thank you for the video. Very understandable and clearly articulated. My concern is how to move an email with an attachment to various folders in a SharePoint library using Power Automate. We are dealing with 300 different segments (I have accordingly created folders in the library). When we receive emails for these segment-specific cases, we need to convert the emails into PDFs and save them in the respective folders with attachments. Since our subject is always segment-specific, I have been thinking about how to automate this process. Can you provide me with tips on how to achieve this?

[@abm4975]

Apologies for the late reply. I been away for a family emergency. If you still need help in this please let me know. Thanks

[@shubhabratadey]

Thanks. How can we move and not copy files from one place to another if they are lets say more than 30 days old?

[@apple1android]

This content is very useful.. Could you pls also suggest to add a email trigger to this flow. I created tried the similar flow with email trigger after saving the contents to Sharepoint. However, it is sending separate email for each attachment, instead of sending one email with multiple attachment. Pls suggest

[@abm4975]

Hi Vasanth Thanks for your comment and support. Without seeing the flow its difficult to give you an exact answer. Looks like there is a logic issue there. Could you post this in Power Automate Community and tag me as @abm. I will have a look. powerusers.microsoft.com/t5/Forums/ct-p/FL_Comm_Forums Thanks

[@thedoc8338]

My man

[@abm4975]

Thanks for the support

[@HuliyaRaja-uy9fi]

Thank you for the explanation- but I was looking for a method to transfer data folder that is shared to me in shared folder of one drive to specific folder in sharepoint folder, Please do explain as requested it will be very useful and helpful for us in sharing the data folder without downloading and again uploading into the sharepoint, it may save a lot of time and Internet Data too....I will be awaiting for your video

[@abm4975]

Hi Look for the trigger when a file is created. Here map the the Shared Folder of One Drive. Thanks

[@2chandra]

I have a question? How to copy large files say more than 100mb file to sharepoint from OneDrive? Currently my flow is not working for files which size is more than 50 mb. Any suggestion will be appreciated.

[@abm4975]

Hi Chandra Did you tried the copy action method? Thanks

[@anthonymediaz]

Nice video. Bro a question. How can i add an action that when a file is created from onedrive i want that the first 7 number of the file name will create a folder (with the 7 number of the file name) in sharepoint and then move the file into the sharepoint (in the created folder)... so exact the steps u mentioned but with the logic to create a folder

[@abm4975]

Hi I need to look your flow. Happy to look via a screenshare. Check my Channel about section and connect me via teams. Thanks

[@carlosm5591]

Excellent video, but what happen if i have a zip file with 4 or more files. When i uploaded to one drive the flow open but stops the flow because is reading just one file inside. How can i copy/move the entire zip. Thanks!!

[@abm4975]

Hi I need to see your flow. I could offer a screenshare help. If you up for it please contact me via Teams. See my team email under the Channel about section. Thanks

[@kissesrs]

I thought you were going to show how to move an existing file to SharePoint - not a new OneDrive file. I want to move several OneDrive folders in their entirety to SharePoint with the sub folders like how they are in OneDrive.

[@abm4975]

Hi What's the subfolder structure in SharePoint? Are these folders are in a document library? Tahnks

[@susharasj]

Hi, This is a great video! But I have a quick query. How about deleting a file from the onedrive folder which in turn deletes the respective file from the document library? Is there any solution for this using Power automate?

[@abm4975]

Hi Use the trigger when a file is deleted then capture the filename. Using this filename filter the SharePoint document library using Get Items filter query to find the Id of the file. One you get the Id then delete the file. Thanks

[@susharasj]

@@abm4975 Hi.. Unfortunately, that particular trigger is not available for 'OneDrive for business' :(

[@abm4975]

Yes you are correct. So what you could do is read the SharePoint files and look for One drive files exists or not. This way you could determine whether you need to keep the file or delete it?

[@diazjubairy1729]

how to make every there is a new email, parse some information from the body, and then every there is a new email, add the new data to the same excel spreadsheet in sharepoint ?

[@abm4975]

Hi There are few videos in my channel about how to extract the body details of email. Please have a look. Thanks

[@prateekkashyap3005]

Hi How can i pull a specific file every week from one folder to sharepoint based on file name(it has date in it)?

[@abm4975]

Hi Prateek Not sure what you really meant by? Say for example you got a file called Report-10-10-2022.docx. Support you want to retrieve the file every week with the right date you can use the expression concat('Report-'), FormatDateTime(utcNow(), 'dd-MM-yyyy')) Thanks

[@CLINKER30]

How can I copy the most recent file from a SharePoint folder?

[@abm4975]

Use the Get Files actions step Set the Order by > Created desc Set Top Count > 1

[@1972Sammy]

What about modifying a files in a subfolder in onedrive and then it should update the file in the subfolder in sharepoint

[@abm4975]

Hi Apologies for the late reply as I was away and busy for last few weeks. Could you try changing the trigger when a file is modified? Thanks

[@gabrieloxobi3343]

I need to create a flow that get triggered when I add an excel file in a folder. In a next step, i need to get the data of that file (get table, or list rows). Is it possible to do it dinamically? I mean, the excel files do not have the same name

[@abm4975]

Hi Please have a look at this video and let me know. kzbin.info/www/bejne/q6O2n5R4a6ySi5Y Thanks

[@gabrieloxobi3343]

@@abm4975 WOW! Thanks a lot!!! It really helped me to solve one of the Flows I was trying to develop! The file identifier and the connector 'Create table' were the solution. The other flow I have is very similar, but in this case there is already a table created in the file. How can I dynamically get that table every time I drop the file in OneDrive or Sharepoint?

[@abm4975]

Hi There is an action step called ' get table names'. Have a look. Let me know if you need any further help in this or not. Thanks

[@gabrieloxobi3343]

@@abm4975 Hi, I´ve tried also using the OneDrive trigger "When a file is created"--> Get tables (Location: OneDrive; Document Library: OneDrive); File: here I used the File Identifier dynamic content) and it shows me this error: "Graph API encountered unsupported features in the workbook and was unable to work with it. Please remove the unsupported content and try again". Do you know what could be the reason of this issue? Thanks!

[@abm4975]

Hi Not sure about this error. Could you please post this in Power Automate community with some screenshots of your flow and errors. powerusers.microsoft.com/t5/Building-Flows/bd-p/BuildingFlows Tag me as @abm. I will have a look. Thanks

[@sathya2870]

what is scripting language used to write an expression

[@abm4975]

There is no script language for Power Automate expression.

[@user-zw6xx4jl6z]

do you have an email in order to disuss ? thnk you

[@abm4975]

Hi Check my channel about section. You can get my email. Connect me via teams or send me an email. Thanks

[@imannayak5839]

Hi all, Power automate flow running is succeed..but some of data is not triggering in SharePoint..what is the solution??

[@abm4975]

Hi I need to see your flow. I could offer a screen share help. Check my channel contact and send me an email. Thanks

[@imannayak5839]

​@@abm4975hi....what is your email id?

[@abm4975]

Check my Channel About section.

[@imannayak5839]

​@@abm4975 hi ....sorry for any inconveniences..in your about section,there is no email address...sorry to say that can you pls send me just hi msg to my email so then I can tell the problem query...thank you for your msg

[@abm4975]

Hi I can't see your email. Click my channel icon > Welcome to my Power Automate tutorial channel. Click here. You can see the about section.

[@natcongreso2763]

Hi, is there a way to automate adding password on the new created file?

[@abm4975]

Hi Not in my knowledge. You could look some third party connectors. Nothing out of the box available for this. Thanks