web

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Automate Truncate part of a tex...

Power Automate

Unanswered

Truncate part of a text in a SharePoint column with Power Automate

(0) Share

Report

Report

Posted on by Slm75

35

Hello 😊

I want to know how to truncate part of a text in a SharePoint column and copy it to another column with Power automate?

Example : copy everything after "_" and copy it in an other column

Thank you 🙂

Categories:

I have the same question (0)

All responses Img

All responses (5)

Answers Img

Answers (1)

Verified answer

Paulie78 8,422 Moderator on at

Like (1)

Report
Re: Truncate part of a text in a SharePoint column with Power Automate

Here is how to do the truncation:

Expression used is:

substring(outputs('Compose'), 0, indexOf(outputs('Compose'), '_'))

Then you can copy it back to the item using an update item action.

Was this reply helpful? Yes No
Slm75 35 on at

Like (0)

Report

Re: Truncate part of a text in a SharePoint column with Power Automate

Hi @Paulie78
Thank you for your answer but I cannot retrieve the values of the SharePoint column to be truncated ..

Was this reply helpful? Yes No
Slm75 35 on at

Like (0)

Report

Re: Truncate part of a text in a SharePoint column with Power Automate

@Paulie78 Thank you for you solution. It's working very well 🙂

Was this reply helpful? Yes No
Slm75 35 on at

Like (0)

Report
Re: Truncate part of a text in a SharePoint column with Power Automate

Hi @Paulie78 Do you know if its possible to do that :
substring(outputs('Compose'), 0, indexOf(outputs('Compose'), '_') or '/")

Something like that..

Was this reply helpful? Yes No
Paulie78 8,422 Moderator on at

Like (0)

Report
Re: Truncate part of a text in a SharePoint column with Power Automate

You could do something like this instead of indexOf...

max( createArray ( indexOf(outputs('Compose'), '_'), indexOf(outputs('Compose'), '/') ) )

Was this reply helpful? Yes No

Join the conversation