Skip to main content

Notifications

Power Automate - Using Connectors
Unanswered

ODBC and "invalid value" error when using % character within password - Power Automate desktop

(0) ShareShare
ReportReport
Posted on by 13

hello.

 

Is there a workaround for Power Automate to accept % symbols within a SQL connection string using ODBC file DSN? It appears to deem the character as an "invalid value" despite wrapping the password in {} bracket.

 

See screenshot

 

powerautomate_invalid_value.png

 

 

 

 

  • unslog Profile Picture
    unslog 13 on at
    Re: ODBC and "invalid value" error when using % character within password - Power Automate desktop

    Hi, 

     

    The %% kinda worked - i.e. the "invalid value" stopped appearing...however this then broke the next step "Execute SQL Query" as the SQL connection variable uses % symbols, so suspect a clash. 

     

    So the workaround to this (if anyone else experiences this behaviour) is to amalgamate the connection string with the SQL query (see screenshot), The only issue with is approach is I'm unable to close the SQL connection (which appears to depends on a connection string variable. 

     

    Connection String2023-05-23 14_34_32.png

  • lbendlin Profile Picture
    lbendlin 7,609 on at
    Re: ODBC and "invalid value" error when using % character within password - Power Automate desktop

    How about %%  ?    Have you considered changing the password?

  • unslog Profile Picture
    unslog 13 on at
    Re: ODBC and "invalid value" error when using % character within password - Power Automate desktop

    Thanks for reply, however that doesn't work.

     

    It appears to be specifically a problem with the % symbol. I also tried other methods mentioned in the link you provided to no avail. the semi-colon within the password works with no problem. Doesn't even in to be wrapped with {} or ''

     

     

  • lbendlin Profile Picture
    lbendlin 7,609 on at
    Re: ODBC and "invalid value" error when using % character within password - Power Automate desktop

    Single quotes around the password should work

     

    c# - Escape ;(semicolon) in odbc connection string in app.config file - Stack Overflow

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard

Featured topics