cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
McBlair
Helper II
Helper II

Split/Extract names from a delimiter string in Flow

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. 

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @McBlair,

 

Please refer to screenshot below to create the flow:

Capture.PNG

 

The expresssion in the Compose as below:

split(first(split(items('Apply_to_each')?['Name'],'.')),',')

 

Best regrads,

Alice

 

View solution in original post

6 REPLIES 6
v-yuazh-msft
Community Support
Community Support

Hi @McBlair,

 

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:

Capture.PNG

 

You could refer to screenshot below to create the flow:

Capture.PNG

 

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:

Capture.PNG

 

The values would be updated in the sharepoint library as below:

Capture.PNG

 

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

 

split(first(spilt(body('Create_file')?['Name'],'.')),',')

 

 

 

1.png3.png2.png

Hi @McBlair,

 

Please refer to screenshot below to create the flow:

Capture.PNG

 

The expresssion in the Compose as below:

split(first(split(items('Apply_to_each')?['Name'],'.')),',')

 

Best regrads,

Alice

 

View solution in original post

Perfect, worked like a charm Smiley Happy

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, Text7TableExample.JPG

 

brenan2000
Frequent Visitor

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

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (2,788)