web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Pass datatable from PA...
Power Automate
Unanswered

Pass datatable from PAD to cloud

(0) ShareShare
ReportReport
Posted on by

Hello, 

I have some problem with passing datatable from power automate desktop to cloud flow. 

The first problem is with my datatable output. I use set variable with my environment variable datatable to pass the rows and column to an output value, but I got something like this instead of rows, columns.

 

my environment variable (there're blank if no data)

deerzzxdell_0-1699428907858.png

deerzzxdell_2-1699429182974.png

 

what I got after using set variable (after expanding details look like: 000012952,0251xxxxx,S, , ,000)

 

deerzzxdell_1-1699428960911.png

 

In my knowledge, after I use set variable the out_dtresults should be similar to dt_results. Please correct me if I'm wrong.

 

And then when I look into my cloud flow after the run, it got an error that said out_dtresults value is null and not array. 

  • Agnius Bartninkas Profile Picture
    Most Valuable Professional on at

    Can you share a screenshot of what your Set variable action looks like? Also, how you've set up your output variable?

    You can also use the same name for the output variable (dt_results) and will not actually need to assign the value to a new variable just for the sake of returning it as outputs.

    -------------------------------------------------------------------------
    If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

    I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 245 Super User 2026 Season 2

#2
11manish Profile Picture

11manish 233 Super User 2026 Season 2

#3
Valantis Profile Picture

Valantis 136 Super User 2026 Season 2

Last 30 days Overall leaderboard