Power automate and Excel - How do i grab text in a cell before a delimiter and put that text into another column?

[pennyland]

I am looking for the expression to find the text (not # of characters because it will change) before a specific delimiter.

Then i want to take that text and put it in another column in the spreadsheet.

I want to do this for all records in the spreadsheet and run this daily.

I know how to set up the flow, but i for some reason cannot figure out how to write the 'expression'. That's the part i need help with.

Ex of data...

Col 1: First Name

Col 2: Last Name

Col 3: blah blah blah / text text text

Col 4: This column is empty right now

I want to look at all records and take the text from col 3 from before the "/" symbol.  

Then take that text and place it in the same row in col 4.

So my col 4 would look like this:

Col 4: blah blah blah

Thanks so much for your help!

[v-bacao-msft · Accepted solution]

Hi @pennyland ,

Please try to refer to the following method to configure flow.

Use the split() function to split the value of the column3 field into two parts. And update the previous part to the column4 field.

When updating the row, we need to specify a key column in order to update the specified row. It is recommended that this column has a unique value and is not empty. I choose ID as the key column here.

Image reference:

Spoiler

Hope this helps.

Best Regards,

[pennyland]

This worked perfectly. Thank you so much!

[alejandromende]

Hi @pennyland 

How can I get the column names from my excel table, so I can select it in Compose before to apply the split funtion?