Skip to main content

Notifications

Community site session details

Community site session details

Session Id : yTRbCWJrKmkJWpRgT14xIc
Power Automate - Power Automate Desktop
Unanswered

Escape special character '&' (ampersand)

Like (0) ShareShare
ReportReport
Posted on 16 Sep 2022 05:23:04 by 73

Hello,

I do have value with special character ('&').

Value : 'D&E_Transactions'

 

I'm using action : 'Invoke web service" parsing the above value. 

Niraj466_0-1663304736952.png

As the '&' symbol within the value is considered as special character, it is generating status code 400 with webservice response as long HTML format error.

How can I escape '&' to parse here?

I already tried with the action 'Escape text for regular expression'  and action 'Replace text' by '&'. But none of these are working.

 

  • Niraj466 Profile Picture
    73 on 17 Sep 2022 at 12:49:50
    Re: Escape special character '&' (ampersand)

    I'm getting error as below : 

    <!DOCTYPE html>
    <html>
    <head>
    <title>Runtime Error</title>
    <meta name="viewport" content="width=device-width" />
    <style>
    body {font-family:"Verdana";font-weight:normal;font-size: .7em;color:black;}
    p {font-family:"Verdana";font-weight:normal;color:black;margin-top: -5px}
    b {font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px}
    H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red }
    H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon }
    pre {font-family:"Consolas","Lucida Console",Monospace;font-size:11pt;margin:0;padding:0.5em;line-height:14pt}
    .marker {font-weight: bold; color: black;text-decoration: none;}
    .version {color: gray;}
    .error {margin-bottom: 10px;}
    .expandable { text-decoration:underline; font-weight:bold; color:navy; cursor:pointer; }
    @media screen and (max-width: 639px) {
    pre { width: 440px; overflow: auto; white-space: pre-wrap; word-wrap: break-word; }
    }
    @media screen and (max-width: 479px) {
    pre { width: 280px; }
    }
    </style>
    </head>

    <body bgcolor="white">

    <span><H1>Server Error in '/' Application.<hr width=100% size=1 color=silver></H1>

    <h2> <i>Runtime Error</i> </h2></span>

    <font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif ">

    <b> Description: </b>An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.
    <br><br>

    <b>Details:</b> To enable the details of this specific error message to be viewable on remote machines, please create a &lt;customErrors&gt; tag within a &quot;web.config&quot; configuration file located in the root directory of the current web application. This &lt;customErrors&gt; tag should then have its &quot;mode&quot; attribute set to &quot;Off&quot;.<br><br>

    <table width=100% bgcolor="#ffffcc">
    <tr>
    <td>
    <code><pre>

    &lt;!-- Web.Config Configuration File --&gt;

    &lt;configuration&gt;
    &lt;system.web&gt;
    &lt;customErrors mode=&quot;Off&quot;/&gt;
    &lt;/system.web&gt;
    &lt;/configuration&gt;</pre> </code>

    </td>
    </tr>
    </table>

    <br>

    <b>Notes:</b> The current error page you are seeing can be replaced by a custom error page by modifying the &quot;defaultRedirect&quot; attribute of the application&#39;s &lt;customErrors&gt; configuration tag to point to a custom error page URL.<br><br>

    <table width=100% bgcolor="#ffffcc">
    <tr>
    <td>
    <code><pre>

    &lt;!-- Web.Config Configuration File --&gt;

    &lt;configuration&gt;
    &lt;system.web&gt;
    &lt;customErrors mode=&quot;RemoteOnly&quot; defaultRedirect=&quot;mycustompage.htm&quot;/&gt;
    &lt;/system.web&gt;
    &lt;/configuration&gt;</pre> </code>

    </td>
    </tr>
    </table>

    <br>

    </font>

    </body>
    </html>

  • Niraj466 Profile Picture
    73 on 17 Sep 2022 at 12:36:32
    Re: Escape special character '&' (ampersand)

    @Kresimir_RPA 

    Yes, I tried now all above scenarios by storing value as NewVar using Set variable and passing it to Invoke Url.

    Niraj466_0-1663418162720.png

     

    But still not expected output.

     

  • Kresimir_RPA Profile Picture
    286 on 17 Sep 2022 at 11:17:42
    Re: Escape special character '&' (ampersand)

    Have you tried to set the whole url into variable and then passing it into Invoke Url section as one variable?

  • Niraj466 Profile Picture
    73 on 17 Sep 2022 at 04:40:06
    Re: Escape special character '&' (ampersand)

    Thank you @Expiscornovus .

     

    I tried with '%2526', but it also doesn't work.

    Niraj466_1-1663388915321.png

    I used %% to escape single % which gave syntax error.

    I also tried by applying '%' at both the side.

    Niraj466_2-1663389200243.png

    Tried with single encoded too as suggested in above blog.

    Niraj466_3-1663389535331.png

     

     

    Nothing is working here. I'm not sure which syntax should work here.

     

    Just to clarify, api call is working perfectly for the case without special character like '&'.

     

  • Niraj466 Profile Picture
    73 on 17 Sep 2022 at 04:23:53
    Re: Escape special character '&' (ampersand)

    Thanks @Pavel_NaNoi .

    I tried the syntex you suggested here.

     

    Niraj466_0-1663388484981.png

    It is still throwing 404 error either with single quotes/double quotes.

     

  • Pavel_NaNoi Profile Picture
    1,072 on 16 Sep 2022 at 15:49:25
    Re: Escape special character '&' (ampersand)

    you can escape a character by putting %'s & double-quotes around it, e.g. %"&"% for things like this.

  • Expiscornovus Profile Picture
    31,641 Most Valuable Professional on 16 Sep 2022 at 09:38:10
    Re: Escape special character '&' (ampersand)

    Hi @Niraj466,

     

    I have seen some people suggesting that you need to encode it twice when interacting with the Web API. Haven't tried it myself but it is worth a shot, right?

    https://powerusers.microsoft.com/t5/Power-Apps-Ideas/WebAPI-retrieveMultiple-with-special-characters-like-amp/idi-p/223515

    https://stackoverflow.com/questions/9292865/what-is-url-encoding-2526

     

    Can you try the below instead of the ampersand to see if that works?

    %2526

     

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,645 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,997 Most Valuable Professional

Leaderboard