So you’ll have to get a bit creative if you can’t change the output to replace Assignees from being comma separated to semicolon separated. I would ask to see if they can modify their output or even give you an excel document instead.
a manual step of opening the CSV in excel and replacing the comma with semicolon would work. Alternatively SharePoint has a ‘import from CSV’ option that works to handle your scenario and should read the commas in the column. Manual steps so not ideal.
This video by Reza Dorrani shows the process to read and parse a CSV file, but also explains the comma has to be replaced from a single column beforehand. https://youtu.be/b3aQf17ptAs?si=jBpjRDgIqyTlAs8X
the one trick you may be able to do - force the assignees to be the last column of your data rows. Once you have separated every time by the ‘new line’ character, you use the Split() function to separate the columns. Your Assignees column would start on index 8 for example. Therefore you would know that if your row contains an index 9, you have another assignee. You can conditionally check indexes 8-12 to support up to five assignees in your import flow. Again, this will only work if you have assignees in the last column and that is the only column with this issue.
another solution would be to parse the row for any quotes, record your first instance of the quote, use that as the starting point to search for another quote. The substring function would help you here. Anything inside the Quotes, do a replace() in power automate to change the coma to a semicolon. It’s a lot of substring manipulation and you’ll likely add another set of loops, so be careful properly parsing string this way. But if you get it working, then you can fully automate your CSV file and it will support any column having extra commas, as long as they are enclosed within quotes.
