About Run Python Script action

(0) Share

Report

Posted on by ZS440

262

I have tried several python scripts.

Screenshot 2021-01-27 223033.jpg

The %PythonScriptOutput% is of type text.

I want to make it a number type, but Convert text to number doesn't work.

Screenshot 2021-01-27 223126.jpg
Does anyone have a solution?

SET List TO [155, 168, 5456, 551, 156, 599, 256, 636, 266, 4894, 282, 522, 266]
Text.JoinWithCustomDelimiter List: List CustomDelimiter: $''',''' Result=> JoinedText
System.RunPythonScript PythonCode: $'''listb = [%JoinedText%]
print max(listb)''' ScriptOutput=> PythonScriptOutput ScriptError=> ScriptError
Display.ShowMessage Title: $'''PAD''' Message: $'''%PythonScriptOutput%
%ScriptError%''' Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: True ButtonPressed=> ButtonPressed
Text.ToNumber Text: PythonScriptOutput Number=> TextAsNumber

Categories:

Power Automate Desktop

All responses (3)

Answers (0)

Sort by

ZS440 262 on at

Like
a
(0)

Report
Copy link

Link copied!
I went into a little more detail.
Assigning a value to PythonScriptOut using print outputs a newline code.

So I used "sys.stdout.write" in python scrip to avoid outputting the newline code.
However, I still couldn't convert it to a number.

import sys
listb = [%JoinedText%].
m=max(listb)
sys.stdout.write(str(m))
In the end, I decided to use regular expressions to extract the numbers.
This is not a smart way.

SET List TO [155, 168, 5456, 551, 156, 599, 256, 636, 266, 4894, 282, 522, 266] Text.JoinWithCustomDelimiter List: List CustomDelimiter: $''',''' Result=> JoinedText System.RunPythonScript PythonCode: $'''import sys listb = [%JoinedText%] m=max(listb) sys.stdout.write(str(m))''' ScriptOutput=> PythonScriptOutput ScriptError=> ScriptError Text.RegexParseForFirstOccurrence Text: PythonScriptOutput TextToFind: $'''[0-9]+''' StartingPosition: 0 IgnoreCase: False OccurrencePosition=> Position Match=> Match Text.ToNumber Text: Match Number=> TextAsNumber

Between the PAD and the Run python script action, I don't think this is a smart way to input/output values.
Does anyone know of a better way?
Henrik_M 2,021 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Try converting %PythonScriptOutput.Trimmed% since it looks like there is a new line after the text.
ZS440 262 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Henrik_M
Thank you for your reply.
I tried %PythonScriptOutput.Trimmed%.
But it did not work.