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!
Solved! Go to 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:
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
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:
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
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
40 | |
31 | |
28 | |
27 | |
27 |