I have constructed a URL, Called "StartingURL" from several variables, If I paste this URL into Chrome it navigates correctly

https://miamidade.realforeclose.com/index.cfm?zaction=user&zmethod=calendar&selCalDate=%7Bts%20%272016-2-01%2000%3A00%3A00%27%7D .

However if I use this variable when I launch Chrome, Chrome converts it to:

https://miamidade.realforeclose.com/index.cfm?zaction=user&zmethod=calendar&selCalDate={ts%20%272016-2-01%2000%3A00%3A00%27} which is an error. The end part is "corrupted"

Do I have to escape my variable before using it in Chrome?

This is how I am constructing my URL:

%StartingYearMonthPart1%%StartingYear%-%StartingMonth%-%StartingYearMonthPart2%

Where

StartingYearPart1= https://miamidade.realforeclose.com/index.cfm?zaction=user&zmethod=calendar&selCalDate=%7Bts%20%27

StartingYear=2016

StartingMonth=5

and

StartingYearPart2=01%2000%3A00%3A00%27%7D

TIA

Hi @Steve48 I hope you are doing well.

I'm happy to see that is finally working on your end.

Now, it seems that I help you with the correct string and usage oif the Percentage sign %, so kindly consider marking my response as the preferred solution and if you found my assistance helpful, a 'Thumbs Up' would be greatly appreciated.

If there is anything else that I can help you with, please feel free to reach out.

Kind regards,

Will SG

Managing Director & Automation Lead

RAMS CR (Recruitment & Automation)

LinkedIn Profile

Hi @WillSG

I took this URL which works in the browser

https://miamidade.realforeclose.com/index.cfm?zaction=user&zmethod=calendar&selCalDate=%7Bts%20%272016-5-01%2000%3A00%3A00%27%7D

And  did a Replace % with %’%’% to arrive at

Hi @Steve48 , I hope you are doing well

I was not able to open those URLs (at tleast they didn’t work on my compuiter, however,
I was looking at the variables that you are defining and maybe, this is the reason why they are not working OR Chrome is changing the output.

To include a percentage sign (%) within a variable or string, use double percentage signs around it and an apostrophe, like %''%. This ensures proper handling and avoids potential errors in your code or scripting environment.

As a result, the variable %StartingYearMonthPart2% should be as follow:

01%’%’%2000%’%’%3A00%’%’%3A00%’%’%27%’%’%7D

The same will happen with the URL if it contains Percentage sign %, you will have to use the same approach to avoid issues when using Chrome.

Hope this helps,

~[0_0]~ ~[0_0]~ ~[0_0]~ ~[0_0]~ ~[0_0]~ ~[0_0]~ ~[0_0]~ ~[0_0]~ ~[0_0]~ ~[0_0]~ ~[0_0]~ ~[0_0]~ ~[0_0]~


If I have addressed your inquiry successfully, kindly consider marking my response as the preferred solution. If you found my assistance helpful, a 'Thumbs Up' would be greatly appreciated.

Additionally, I offer specialized consultancy and development services leveraging Power Automate Desktop. If you're interested in exploring these services further, feel free to DM me, and we can initiate a discussion. Thank you for your engagement!

Kind regards,

Will SG

Managing Director & Automation Lead

RAMS CR (Recruitment & Automation)

LinkedIn Profile

Hi @CristinaValdes & @Nived_Nambiar I'm not sure what you (Cristina) mean by putting the url in a variable and then put the variable in Chrome. I think I am already doing that

In response to your previous suggestion about escaping, i hardcoded the parts of the URL that are constant, escaping the % signs which resulted in this url which works if i paste it into the browser.

https://miamidade.realforeclose.com/index.cfm?zaction=user&zmethod=calendar&selCalDate=%7Bts%20%272016-5-01%2000%3A00%3A00%27%7D

The url in the browser after Chrome Launch  that didnt work is this:

https://miamidade.realforeclose.com/index.cfm?zaction=user&zmethod=calendar&selCalDate={ts%20%272016-5-01%2000%3A00%3A00%27}

It seems to be having a problem with the %7Bts at the beginning of the last part and the 7D at the end

Hi @Nived_Nambiar I am only constructing one URL. When the browser is launched with this URL I get an error page. However if I copy the value of the URL variable and paste it into the browser, it works. Apparently PAD is not able to interpret the URL string correctly, maybe because of the % signs. I made a short video which demonstrates the problem

https://youtu.be/FCrpAlXPH3o

Subscribe to

Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.