If I have a URL string that looks as follows
can I extrapolate all characters (but no longer than 14) to the right of the last forward slash.
Is this possible?
Solved! Go to Solution.
So in the URL there is only 8 characters but I need the system to allow for up to 14 characters.
When I saw you expression I was very excited because I had not thought of using what you did!
Awesome, you did a test on your end and didnt receive an error like I show?
You didn't mentioned earlier that you could have less than 14 characters length as well.
First find the last string after the last slash
Then add an If condition to check the length is less than 14 by comparing the above value.
If its more than 14 then use the expression which I mentioned earlier substring(last(split(outputs('Compose'),'/')),0,14) else use the expression last(split(outputs('Compose'),'/'))
Another way to do this is as follows:
Above expressions are:
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Join us on June 28 for our monthly User Group leader call!
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!