Unanswered

How do I build a flow that outputs a .tsv file from a dataverse table?

(1) Share

Report

Posted on by futr_vision

831 Moderator

I've been stuck on this for a couple of days now. I am starting with a Dataverse table and want to output to a .tsv file. On the top of that .tsv file I want to add 6 rows of static data. I've attached a template as an example. The first three rows have two columns of data. The fourth row is blank and the fifth row is the table headers. Then I need one more blank row before the table data. I've used Copilot and ChatGPT take a stab at it, but the output is never correct. I figured I'd post here to see what the actual users of the project had to say.

Categories:

Building flows

Campaign Tracking...

I have the same question (0)

All responses (2)

Answers (0)

Michael E. Gernaey 53,479 Super User 2025 Season 2 on at

Like (1)

Report

Hi

So just to clarify you are in fact not creating a TSV at all. A portion of that has the data you want in that format but a big portion is just text in different formats, correct?

Do you have any parts of the Flow started to share?

From a pure data perspective, you can certainly name the file .tsv, it just won't be a try tsv.

So what you can do is create a string array where you would build it based on the data that you have, adding in the lines and carriage returns (blank lines) and then all the TSV data.

I can only guess that the data itself comes from dataverse but I do not know which parts. So unfortunately, just telling you you can create what you want is easy honestly.

But giving you an actual sample that would do what you want isnt as easy as I have no idea where the data (all the lines) come from.

Was this reply helpful? Yes No
futr_vision 831 Moderator on at

Like (0)

Report

Well. I had a response and thought it posted but I guess not. Let me try again.

The file I attached is the template the Adobe provides for the output file. Actually, they recommend a .tab file but that is essentially the same thing. Up until this point I've been able to output the Dataverse table to a csv file without and issue. Granted, it doesn't contain the static rows I need but it does work. Here is what the flow looks like. The circled area spits out another required file so that can be ignored.

This is one of the proposed flows that Chat GPT and Copilot have spit out. The only thing that has been consistent between the various flows they have give me are the first two steps and usually the 3rd where you do your selection. This 3rd step sometimes gets tweaked because the following actions are looking for the data in an array format and the select step outputs JSON.

Was this reply helpful? Yes No