Power Platform Community Forum Thread Details

I am extracting some URLs from web that have "_" (underscores) in then and want to replace with "%5F" but this is giving me a syntax error. So basically, for example I have this URL in my datatable

"https://teamsite.deere.com/iw-mount/productinformation/main/sales/en_GB/WORKAREA/workarea/docs/sales/salesmanual/en_GB/tractors/2021/model/5e/5050e_stagev.html"

Which I want to replace with

"https://teamsite.deere.com/iw-cc/command/iw.ccpro.launch_edit_form?full%5fredirect=true&vpath=//teamsite.deere.com/productinformation/main/sales/en%5fGB/WORKAREA/workarea/docs/sales/salesmanual/en%5fGB/tractors/2021/model/5e/5050e%5fstagev.html&done%5fpage=/iw-cc/base/util/refresh.html&locked=true&done%5ftarget=null"

If you see, the start and end have a little extra characters and _ replaced with %5f

Categories:

Power Automate Desktop

Community site session details

Find and replace special characters (_) in a Datatable with another special character.

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to the June Top 10 Community Leaders!

Leaderboard > Power Automate

Featured topics

Product updates