variable 'JsonAsCustomObject' must be a list,datatable or datarow

(0) Share

Report

Posted on by Sidhardha_varma

Hi All,

can anyone help me with the below error -variable 'JsonAsCustomObject' must be a list,datatable or datarowplease find the below screenshots for the reference.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

VishnuReddy1997 2,656 Super User 2025 Season 2 on at

Like (1)

Report

Hey Hi,

This is because the output of the "Convert JSON to custom object" action is a custom object, not a list or data table.

Custom objects are not iterable in Power Automate Desktop, so you cannot really do it this way. The only way to do what you want would be to use Convert custom object to JSON and then use Parse text with regular expressions to retrieve the values from the JSON string into a list.

Please follow this link for the solution.

Link: https://community.powerplatform.com/forums/thread/details/?threadid=bf8cd086-4abc-4b2c-be97-8de951af4a47

(Note:- if you got your solution you can mark as solution and gives kudos)

Thanks & Regards

Vishnu Reddy

Was this reply helpful? Yes No
Amlan Sahoo 4 on at

Like (0)

Report

This is because It is not a list or a data table. You can not apply for each loop here.

Thanks,

Amlan

Was this reply helpful? Yes No