web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Getting a number from ...

Power Automate

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:

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

pmwhelan 375 on at

Like (0)

Report

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.'.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com on at

Like (1)

Report
Hi @pmwhelan,

Modify as below:

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

Was this reply helpful? Yes No
pmwhelan 375 on at

Like (0)

Report

Thanks!

Was this reply helpful? Yes No

Join the conversation