web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / replace text with null...
Power Automate
Suggested Answer

replace text with null and blank with the in power automate desktop

(0) ShareShare
ReportReport
Posted on by 45
I'm trying to change a text that is originally like this: COMPANY COUNTRY S.A. (blank spaces between words and periods) to COMPANY%20COUNTRY%20SA ​​but it doesn't work for me, including using %''% for the period and how to put the % as text
Thanks for the help
I have the same question (0)
  • Suggested answer
    rcardenasb Profile Picture
    45 on at
    I resolve the problem using two actions
     
     
     
    Now is working
  • Suggested answer
    eetuRobo Profile Picture
    4,378 Super User 2025 Season 2 on at
    Great that you found a solution already. You could also do it with replace text %%20 or %'%20'%

    With Power Automate Desktop if you only use one % -sign it will give syntax error since it always expects two %-signs. It thinks that you have started a reference for variable but don't have the ending % -sign. 
    So if you want to replace %20 then you can just add another % sign so: %%20 Then PAD will not give syntax error and it will read that as %20. 


    Or you could use: %'%20'%
    In that you tell PAD that you are giving it string of text inside the percent signs and apostrophes %'string of text here'%


     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

Liquid error: Object of type 'Adxstudio.Xrm.Web.Mvc.Liquid.EntityReferenceDrop' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. trice602 392 Super User 2025 Season 2

#2
David_MA Profile Picture

Liquid error: Object of type 'Adxstudio.Xrm.Web.Mvc.Liquid.EntityReferenceDrop' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. David_MA 270 Super User 2025 Season 2

#3
Expiscornovus Profile Picture

Liquid error: Object of type 'Adxstudio.Xrm.Web.Mvc.Liquid.EntityReferenceDrop' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Expiscornovus 210 Most Valuable Professional

Last 30 days Overall leaderboard