Move a file within OneDrive for Business

[m-s]

I'm trying to create a flow that will move every new file in the Pictures folder that contains the text part "-WA" to a subfolder "WhatsApp".
What I don't succeed in is putting the new path together, because I can't find a value that only represents the path. I only see the path including the file name as a value.

[eric-cheng]

Hi @m-s ,

The filepath from the trigger looks like the below which contains a bunch of additional information like the drive as well as the filename.

Looks like you may need to use expressions to extract the portion between 'root:' and the filename to get the path.

I tried using the Get File Metadata action and it doesnt have the information either.

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

[m-s]

Thanks for the reply.

Once again it shows me that Power Automate is not as easy as Microsoft likes to claim.

Maybe I'll take the time again and make a path for myself.

[eric-cheng]

Hi @m-s ,

Is SharePoint an option for you? You can accomplish that alot easier.

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

[m-s]

Hi @eric-cheng,

What do you mean? Should I use the SharePoint Connector instead of the OneDrive Connector?

[eric-cheng]

Hi @m-s ,

With the OneDrive connector, you don't get as much of the details as you would with the SharePoint connector.  In the example above, to get the file path, you would need to extract it out of what is returned in the header.

However, it depends on your requirements.

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn