You’re offline. This is a read only version of the page.
Announcements
148
I have a flow that parses a CSV file, then creates a new CSV table that has some conjugations and new columns that I added. Here is a link to the article I used to create it. It's basically the same thing.
I then just use a "Create CSV Table" step in order to create a table, create the file, then download it to a OneDrive folder. The flow works really well, the only issue is that I get these issues in certain rows that have commas from the original csv file, and it's interfering with the actual code. How can I make it to where these commas don't mess up the column, therefore messing up the row?
Original CSV File: (Names covered), only commas shown
New CSV File (Note the row where there are commas) (Note that the "Project Manager" & "CSR" row is messed up since it contains commas)
Any help appreciated, thanks.
There is this template for reading in CSVs to JSON while avoiding in-data comma errors: https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/CSV-to-Dataset/td-p/1508191
As long as your CSV field values with in-data commas have double quotes “ “ around them, it should help fix your issue.
Share
Report
All responses (
Answers (
