I have files structure like this '123456,Joe Bloggs,5.pdf I have found an expression I can use to extract the first 6 characters.
I really want to extract each value between the commas (not including the file extension) and insert into a column in the SharePoint library where the file is being stored any ideas or help would be greatly received.
Solved! Go to Solution.
Could you please share a screenshot of the configuration of your flow?
Could you please share more details about your sharepoint library column?
I have made a test on my side on my side to create a sharepoint libaray with three single line of text column to save the value from the file name as below:
You could refer to screenshot below to create the flow:
The expression in the Compose as below:
The expression in the Compose 2 as below:
The expression in the Compose 3 as below:
The expression in the Compose 4 as below:
The flow would run successfully as below:
The values would be updated in the sharepoint library as below:
Thanks for the detailed reply. Below is the flow and columns. The file being saved in the library is an attachment from an email. Columns are then updated based on the person that has submitted the file. I have attempted to use the first expression but I get this error...
InvalidTemplate. Unable to process template language expressions in action 'Compose' inputs at line '1' and column '2542': 'The template function 'spilt' is not defined or not valid.'.
I followed your expression but Flow appears to have changed it to
Three Super User rank tiers have been launched!
Features releasing from October 2020 through March 2021
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!