News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows Getting a number from ...

Power Automate - Building Flows

Answered

Getting a number from a URL

(0) Share

Report

Report

Posted on by pmwhelan

375

Hi

I have a SharePoint Online list and I am able to loop through each row.

One column URL, has values like this ...

http://myserver/tikitlink/tikitlink.asp?doc=12345&lib=lib1

How can I extract the doc number?

I tried to use this ...

uriPathAndQuery(items('For_each')?['URL'])

which gives me

/tikitlink/tikitlink.asp?doc=12345&lib=lib1

but I get stuck there.

Thanks

P

Categories:

Business Process Flows

All responses Img

All responses (3)

Answers Img

Answers (1)

pmwhelan 375 on at

Like (0)

Report

Re: Getting a number from a URL

Thanks!
Verified answer

v-qiaqi@microsoft.com on at

Like (1)

Report
Re: Getting a number from a URL

Hi @pmwhelan,

Modify as below:

first(split(last(split(uriPathAndQuery(items('For_each')?['URL']),'doc=')),'&'))
pmwhelan 375 on at

Like (0)

Report

Re: Getting a number from a URL

Like this?
first(split(split(item()?['URL'], 'doc='), '&'))
It fails.
InvalidTemplate. Unable to process template language expressions in action 'Set_variable' inputs at line '0' and column '0': 'The template language function 'split' expects its first parameter to be of type string. The provided value is of type 'Array'. Please see https://aka.ms/logicexpressions#split for usage details.'.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 497 Super User 2025 Season 1

#2

David_MA 436 Super User 2025 Season 1

#3

Riyaz_riz11 244 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans