News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows I need to extrapolate ...

Power Automate - Building Flows

Answered

I need to extrapolate the last fourteen or less characters from the end of a string but after a forward slash

(0) Share

Report

Report

Posted on by golfnutt82

1,360

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?

All responses Img

All responses (5)

Answers Img

Answers (1)

abm abm 32,472 Most Valuable Professional on at

Like (0)

Report

Re: I need to extrapolate the last fourteen or less characters from the end of a string but after a forward slash

Hi @golfnutt82

Another way to do this is as follows:

Above expressions are:

last(split(outputs('Compose'),'/'))

substring(outputs('Compose_3'),0,if(greaterOrEquals(length(outputs('Compose_3')),14),14,length(outputs('Compose_3'))))

Thanks
abm abm 32,472 Most Valuable Professional on at

Like (1)

Report

Re: I need to extrapolate the last fourteen or less characters from the end of a string but after a forward slash

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

last(split(outputs('Compose'),'/'))

The above expression will give you the string

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'),'/'))

Thanks
golfnutt82 1,360 on at

Like (0)

Report

Re: I need to extrapolate the last fourteen or less characters from the end of a string but after a forward slash

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?
Verified answer

abm abm 32,472 Most Valuable Professional on at

Like (1)

Report

Re: I need to extrapolate the last fourteen or less characters from the end of a string but after a forward slash

Hi @golfnutt82

Here it is

Expression for the above is as follows:

substring(last(split(outputs('Compose'),'/')),0,14)
abm abm 32,472 Most Valuable Professional on at

Like (0)

Report

Re: I need to extrapolate the last fourteen or less characters from the end of a string but after a forward slash

Hi @golfnutt82

Here it is

Expression for the above is as follows:

substring(last(split(outputs('Compose'),'/')),0,14)

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Check out the New Agent Creator Community

Quick Links

Leaderboard >

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans