cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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 @Anonymous,

 

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 @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:

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

 

 

 

 

Anonymous
Not applicable

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 @Anonymous,

 

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

 

Anonymous
Not applicable

Perfect, worked like a charm Smiley Happy

Anonymous
Not applicable

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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Users online (1,912)