Is it possible to use a List output from one dataflow in another dataflow?

[arpost]

I have a scenario where I'm trying to create a parameter list from one dataflow and use the list in multiple other dataflows. I successfully create the list by disabling the load in the first dataflow.

However, I can't seem to reference the list when trying to connect from the second dataflow.

Anyone have any ideas?

[jeffshieldsdev · Accepted solution]

Dataflow output is saved as CSV files in data lake storage. Consumers of dataflows read from that store. Because of this you're limited to tables and columns.

You'll have to pass the List as a table of values, or as a table with one column and row containing a delimited string (or JSON string if List data is nested).

You can still use a parameter in your source dataflow, but also create a reference table that exposes the values in table format and have downstream dataflows consume from that.

Or store your parameter in its own dataflow, add a reference table, and use that in original source and downstream dataflows.