Hi All,
I am trying to create a Tab delimited txt file from a 'Create CSV Table' action. I understand we can create a string that contains a tab character, but some of my fields contain commas so I can't simply use a Compose action with a 'replace' expression.
Is there any way to output as a tsv? Should I even be using the 'Create CSV Table' Action? I am using an array as an input that looks like this:
Any help would be wonderful!
Cheers,
Ben
Solved! Go to Solution.
Hi @Benjimang,
I am trying to figure out your problem with doing these steps:
before converting it into CSV file, relace these commas into another character (the one in the original text didn't exist).
For example:
"\"
Step 1:
Step 2:
Step 3:
Please have a try, I hope it can help you.
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Benjimang ,
You could construct the line with delimited character tab as follows.
Here is my output
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogHi @Benjimang,
Yes, you could use the Create CSV table action, then add a create file action to create a CSV file as output.
There is an instance you can refer to:
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-litu-msft ,
Your solution creates a comma separated file and I need a tab separated file. Some of the field I am using contain commas, so I cannot simply replace commas with tabs using a 'replace' expression.
@abm - I'm not sure how this will all complile into a tsv table and save out as a text file. Can you elaborate? I essentially have 25 columns and over 100 rows of data to compile
Hi @Benjimang,
CSV stands for "comma-separated values". Its data fields are most often separated or delimited, by a comma.
How about output an HTML table, its style just like the following:
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-litu-msft ,
Thank you for trying to help, but I'm not sure you understand what I'm trying to do. I need to arrive at a tab delimited txt file. Is there any way that I can either convert a CSV table, or skip the CSV Table action and compose the array I have built as a tsv file?
Hi @Benjimang,
I am trying to figure out your problem with doing these steps:
before converting it into CSV file, relace these commas into another character (the one in the original text didn't exist).
For example:
"\"
Step 1:
Step 2:
Step 3:
Please have a try, I hope it can help you.
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-litu-msft
You may well have the answer here. I'll try it on my end and come back to you. Just to be clear:
1) Replace commas in fields before creation of CSV table with unusual charachter (# or similar)
2) Replace all commas in CSV table with Tabs
3) Replace all # (or similar) back to commas
I'll test
I know this is almost two years old, but if you're still interested in something, see Shane Young's video here:
https://www.youtube.com/watch?v=foGaOrBzVLc
I commented about my experience with getting a tab-separated file via flow's HTML action. It takes some manipulation back in Power Apps, but it doesn't use Apply to Each and therefore doesn't take more than a few seconds.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
65 | |
24 | |
16 | |
15 | |
11 |
User | Count |
---|---|
114 | |
35 | |
30 | |
28 | |
26 |