Answered

How to preserve output variable data type

(0) Share

Report

Posted on by DABot

When I run a desktop flow that reads values from a range of cells from Excel, the variable produced is a data table data type. When I try to pass that variable as an output variable to another flow, it is automatically converted to text. How can I preserve the data table data type for output variables?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Pstork1 69,599 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Have you tried converting the table to JSON and then send the JSON to the other flow where it can then be Parsed?

Was this reply helpful? Yes No
John_Mavridis Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,

That's indeed a limitation for the time being, as Power Automate Desktop currently only supports text and sensitive text as input variables. Supporting more variable types like lists and data tables is in the mid-term roadmap of the product, and will probably take place over the coming months.

Was this reply helpful? Yes No
Henrik_M 2,021 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Interesting info! What about variable types such as browser instances and even UI elements?

Was this reply helpful? Yes No
Verified answer

DABot 11 on at

Like
a
(1)

Report
Copy link

Link copied!

My solution was to copy the desktop flow that reads the Excel range into the calling flow as a sub flow. I had to modify the input/output variables a bit, but this was a fairly simple solution that preserves the data table for that variable.

Was this reply helpful? Yes No
yoko2020 495 on at

Like
a
(1)

Report
Copy link

Link copied!

@Henrik_M wrote:
Interesting info! What about variable types such as browser instances and even UI elements?
@Henrik_M
I think we need to wait. Let the developers do their work .
I remember you in ProcessRobot forum 😂.

Was this reply helpful? Yes No