Power Platform Community Forum Thread Details

Hi,

I'm attempting to create a power automate flow for work that moves a file from one sharepoint folder to another based on the first six characters of the file name. Specifically, I want to design one that moves the file to a folder that shares the same first six characters (i.e., AE XXX). If a folder does not exist, then have power automate create a folder with the file name's first six characters and move the file to that folder. Can I do this?

Categories:

Building flows

Yeah, just utilize on modified or created and a Condition that uses starts with (filenamewithextention starts with "your six characters"), then on the yes side move file action. You won't have to do anything in terms of checking the folder and creating it, just put the destination folder with the 6 characters and it will either move it to that folder, or create the folder if it doesn't exist to move the file to built into the action.

For the destination folder, put the path in, then at the / for the folder put an expression that uses

substring(triggerbody(filenamewithextension),0,6) < code isn't exact but use the dynamic content for filename there, that will return the first 6 characters of the file for the folder.

and call it a day.