Using left function to extract filepath dynamically in onedrive for business

[KUNGFUPANDA559]

I'm attempting to recreate functionality we're currently using in excel.  The file path contains path+file name and extension.  I'd like to replicate the following using flows:

DynamicFolder=left(filepath,len(filepath)-((len(filename)-1)

DynamicFolder would be the location that new files would be relocated  

Thanks!

[v-yamao-msft · Accepted solution]

Hi @KUNGFUPANDA559 ,

Do you want to extract the path and file name from a string?

There is no left/right/middle function could be used in Microsoft Flow, please consider using the function take and skip instead.

More details about the functions, please check it at here:

https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#t...

I have made the following test for your reference.

Path + file name and extension are stored in an Excel file likes below:

Attachment/tabletest.xlsx

To get the File path, use the following function:

take(items('Apply_to_each')?['path'],10)

To get the File name with extension, use the following code:

skip(items('Apply_to_each')?['path'],10)

Please take it for a reference and try it on your side.

Best regards,

Mabel