cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
FVL1
New Member

Folder automate SharePoint

Hello all, I have a question about a flow. I would like to create a folder in which documents can be inserted, which then move the document to the relevant SharePoint order based on the name of document, which consists of numbers and letters. The folder does not have the same name as the file. Currently I have not found a solution in this forum that works for me. Therefore, I would like to know if there is a possibility to create such an order and if so, how? Thank you for the answers.
1 REPLY 1
fchopo
Super User
Super User

Hi @FVL1 

If your files look like those samples: ABC_123.txt, ZXY_999.txt, AAA_56789.txt, you could do something like this:

 

1) When a file is added or modified

2) Get first part of the filename using the expression:

split(triggerOutputs()?['body/Name'],"_")[0]

3) Depending on the prefix, create an item in a SharePoint site or another.

files-folders.png

 

Hope it helps!

Ferran

 

Did I answer your question? Please consider to mark my post as a solution to help others.
Proud to be a Flownaut!

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (4,882)