Answered

Execute SQL Statement with python variable

(0) Share

Report

Posted on by Fearmonger

I've follow this forum post "https://powerusers.microsoft.com/t5/Power-Automate-Desktop/Week-number-in-pad/td-p/1248365" to use the PAD "Run Python Script" option to generate a python variable to show the current weeks number. This works great and I get the data that I'm expecting when I use display message. But when I attempt to execute a SQL statement with ('%PythonScriptOutput%';) I get no results. If I replace the variable with an actual number the statement works fine. I've been able to pass other variables via PAD in other statements just not working with the Python script. I'm able to use "Set variable" to 24 and that newvar variable pass through the SQL statement fine as well. Has anyone else seen this issue before or know of a workaround for this? Thank you in advance for any help with this.

Categories:

Power Automate Desktop

All responses (3)

Answers (1)

Sort by

Srini007 3,490 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Fearmonger

Yeah, for me the same issue, but what I found is that the output,which it is showing has some other extra values where it is not able to convert to number also

If you find this reply helpful, please consider giving it a LIKE AND
If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION

Thanks,
Srini
Verified answer

Srini007 3,490 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @CST

I don't know where to escalate this bug, can you check this is for PAD and when we get the output result from Python it is giving some other whitespaces I believe, that's where it is not converting even though cleared the white spaces

OR

I misunderstood the action

If you find this reply helpful, please consider giving it a LIKE AND
If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION

Thanks,
Srini
Samudiho 4 on at

Like
a
(0)

Report
Copy link

Link copied!

One possible solution would be to use this module called ‘text entity recognizer’ and then retrieve the value