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 🙂
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.
Hi @Paulie78
Thank you for your answer but I cannot retrieve the values ​​of the SharePoint column to be truncated ..
@Paulie78 Thank you for you solution. It's working very well 🙂
Hi @Paulie78 Do you know if its possible to do that :
substring(outputs('Compose'), 0, indexOf(outputs('Compose'), '_') or '/")
Something like that..
You could do something like this instead of indexOf...
max( createArray ( indexOf(outputs('Compose'), '_'), indexOf(outputs('Compose'), '/') ) )
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Chiara Carbone as our Community Spotlight for November…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Michael E. Gernaey 722 Super User 2025 Season 2
Tomac 461 Moderator
developerAJ 283
