How to parse QueryString in Power Automate

Power Automate has changed the way we looked at automations and integrations. Things which used to take weeks if not months can now be achieved using in days/ hours.

This is because of the huge number of functions available in Power Automate. To be honest, exploring all these at one go is kind of improbable if not impossible.

Here in this blog I am going to explain on how can we parse QueryString from a URL in Power Automate. Quite expected, Power Automate has expressions and functions for the same as well.

So let’s explore. To test this I have used a variable – Url with the following value – https://bing.com?id=1&text=123

As you can observe, the URL contains couple of QueryString parameters. But how to get the QueryString value?

Well, there is a function for that also. And that function is uriQuery.

Parse QueryString in PowerAutomate
uriQuery(variables('Url'))

And below is the output.

Parse QueryString in PowerAutomate

As you can see, we can extract the query string without any string manipulations. If you are thinking on how to can get the query string parameters, we have to do little more effort.

Parse QueryString in PowerAutomate
split(substring(outputs('QueryString'),1),'&')

As you can see above, I am taking the output inside an Array variable. And below is the output.

Parse QueryString in PowerAutomate

Hope this helped!

You may also like the below posts

Debajit Dutta
Business Solutions MVP