Compose "Disconnect" / First expression

(1) Share

Report

Posted on by PatrickSched

212

Hello everyone,

How can I separate everything before the "/" in the following expression
Test Timber Regulation Libary/Fileupload/Dehner_01.08.2024 (ID 12)/.

I would like to have only "Test Holzverordnung Libary/Dateiupload/Dehner_01.08.2024 (ID 12)" without "/". I can do that with the Compose function, but what is the expression called?

Thank you and best regards

patrick

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Suggested answer

AnthonyAmador 2,553 Moderator on at

Like (1)

Report

You can use the substring and lastIndexOf functions in Power Automate to achieve this. Here’s how you can do it:

Get the position of the last “/”: lastIndexOf('Test Timber Regulation Libary/Fileupload/Dehner_01.08.2024 (ID 12)/', '/')

Extract the substring up to the last “/”: substring('Test Timber Regulation Libary/Fileupload/Dehner_01.08.2024 (ID 12)/', 0, lastIndexOf('Test Timber Regulation Libary/Fileupload/Dehner_01.08.2024 (ID 12)/', '/'))

Putting it all together, the expression would look like this:

substring('Test Timber Regulation Libary/Fileupload/Dehner_01.08.2024 (ID 12)/', 0, lastIndexOf('Test Timber Regulation Libary/Fileupload/Dehner_01.08.2024 (ID 12)/', '/'))

Hope this helps.

Anthony.

If my reply answers your question, please like and mark it as verified. This helps me stay motivated to assist others and makes it easier for users with similar questions to find the answer. Thanks!
Feel free to connect with me on LinkedIn!

Was this reply helpful? Yes No
Verified answer

WillPage 2,307 Super User 2025 Season 2 on at

Like (0)

Report

If it's as simple as removing the last character (all the input strings will have a trailing / character), then you can strip it off simply like substring(outputs('Compose'),0,sub(length(outputs('Compose')),1))

Was this reply helpful? Yes No