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.
substring(split(item()?['Name'],',')[0],0,6)
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.
Hi @Anonymous,
Please refer to screenshot below to create the flow:
The expresssion in the Compose as below:
split(first(split(items('Apply_to_each')?['Name'],'.')),',')
Best regrads,
Alice
Hi @Anonymous,
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:
split(first(split(triggerBody()?['{Name}'],'.')),',')
The expression in the Compose 2 as below:
outputs('Compose')[0]
The expression in the Compose 3 as below:
outputs('Compose')[1]
The expression in the Compose 4 as below:
outputs('Compose')[2]
The flow would run successfully as below:
The values would be updated in the sharepoint library as below:
Best regards,
Alice
Hi Alice,
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
Hi @Anonymous,
Please refer to screenshot below to create the flow:
The expresssion in the Compose as below:
split(first(split(items('Apply_to_each')?['Name'],'.')),',')
Best regrads,
Alice
Perfect, worked like a charm
I am very new to Power Automate so I am sure I am missing something simple here. I have an email with text separated by commas that I would like to parse and add to an excel spreadsheet (existing table in OneDrive), a new row per email. How would I do this since there is no defining text to use the split, just commas separating the content. So far I have only been able to separate the last value (Text7) successfully. I would like to add each Text value into a separate field in an excel table. Here is an example of the email (with sensitive info removed), we have a disclaimer at the top.
CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe. Report suspicious email using the Report Phish button in Outlook.
Text1, Text2, Text3, Text4, Text5, Text6, Text7
Separate between delimiters
This one separates out text from the middle of two delimiters we are expecting to see occur
First(Split(last(Split(CONTENT, 'DELIMITER')), 'DELIMITER2'))
Example "The World is Bright Today"
First(Split(last(Split('The World is Bright Today', 'The ')), ' Today')) #Spaces should be included where needed
Returns World is Bright
User | Count |
---|---|
89 | |
41 | |
22 | |
20 | |
16 |
User | Count |
---|---|
133 | |
50 | |
48 | |
36 | |
26 |