Answered

Python script error

(0) Share

Report

Posted on by HE-03121232-0

i would like to get only few columns data from datatable, i have passed the datatable to python 3 script and developed the code to get required fields, but i am getting error to while running it.

Error:

File "", line 1
Datatable = 1415140, , SDMT Automations Test Exp JD, Open, Americas (0001)
^
SyntaxError: invalid syntax

My Code:

Datatable = %Var_ExcelData%

new_TD = []

for row in Datatable:

new_row = { 'Job Req ID': row['Job Req ID'], 'Status' = row['Status']}

new_TD.append(new_row)

print(new_TD)

Categories:

Process Advisor

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

MParikh 313 Super User 2025 Season 2 on at

Like (0)

Report
Python script error

The Python step received a plain string, not a datatable. Python treats it as invalid syntax, so it fails before your loop even runs.

Two issues appear:

You used %Var_ExcelData% in the Power Automate Desktop Python action, which injects the raw text instead of a table.

Your dictionary syntax is wrong. You used = instead of :.

Here is the corrected version that works for a datatable passed from Power Automate Desktop.

Working code

# Datatable comes in as a list-of-dictionaries when mapped correctly datatable = Var_ExcelData # remove percent signs new_TD = [] for row in datatable: new_row = { 'Job Req ID': row['Job Req ID'], 'Status': row['Status'] } new_TD.append(new_row) print(new_TD)

What need to be fix in Power Automate Desktop

In the Python script action, map your datatable input using Add input,choose type DataTable or List.

Do not write %Var_ExcelData% inside the Python code.

Power Automate Desktop automatically injects it as a Python object, usually a list of dicts.

Then the loop works without errors.

What caused your original syntax error

Your original line:

Datatable = %Var_ExcelData%

gets evaluated as:

Datatable = 1415140 , SDMT Automations...

Python sees:

number

comma

comma

text

more commas

This is not valid Python syntax.

Set the variable in the action input, not by writing %Var_ExcelData% inside the code.

If you want, I can rewrite the full working PAD Python step with input and output mapping.

Was this reply helpful? Yes No
Suggested answer

HE-03121232-0 4 on at

Like (0)

Report

Python script error

yes, please rewrite the full working PAD Python step with input and output mapping.

Was this reply helpful? Yes No