Hi @StephenM,
Do you want to keep everything before “Folder”?
Please take the following code for a reference.
In Compose, use the function lastIndexOf to return the ending position of the string.
lastIndexOf(triggerBody()['text'],'Folder')
In Compose2, use the following code to remove the characters after the “Folder”.
substring(triggerBody()['text'],0,add(outputs('Compose'),6))
The Output of Compose 2 is:
https://mysharepount.sharepoint.com/sites/SA/SalesOrders/015300%20to%20015399/015328/Folder
Please take it for a reference and try it on your side.
Best regards,
Mabel Mao
