How to connect a Data App output table with another Workflow?

[marianaa_pi]

Hello,

I have a data App that outputs a table in the Workflow data area after the app receives an input from the consumer and is refreshed. My goal is to copy the output table of the data app data area to a Sharepoint folder. However, I’m having difficulties accessing the table (in csv format) outputted from the data app to the new Workflow (used to copy the table to the Sharepoint folder by a trigger based deployment).

I tried to save the data app workflow using the capture workflow start and end nodes combined with the Workflow writer, and as my second approach tested the Save Workflow. However, those options do not work because they mess with the app interface. I also tried to use the Call Workflow (Table) node directly in the second workflow but it does not retrieve any table.

Maybe the solution is simple but I’m not sure if my logic is correct or if there is a specific node I’m missing which would work better.

For more context, you can find my Data App Workflow in the image below:

Note that the component is fed by a simple table.

Best regards,

Mariana Pimentel

[rfeigel]

Have you tried the Sharepoint Online Connector and Transfer Files nodes?

[marianaa_pi]

I’ve tried now but it does not encounter the Data App workflow data area where I have the file, even when I try to access the relative path.

In my csv writer I wrote the table in this folder with this name:

Then, in the second workflow, the write files ask me for the file and I can only give them the workflow which it won’t be written because it is not compatible with the Sharepoint.

Do you know how can I access the data area of a data app? I tried multiple times to find it in the Hub but I can’t find the folders and according to KNIME documentation, the relative path should work without a data area connector.