Hello,
I am having trouble with my workflow where I am essentially uploading a CSV file from PowerApps - my workflow grabs the content of the CSV file and parses JSON from column data in the csv file and creates a word document in SharePoint, then fills it out using SharePoint Quick Parts.
Most of my templates are working correctly however there are a few which are not populating particular bits of data into the documents.
One of the column names is named "Key Type, Make and Serial Number" - I have put this in quotes in the CSV file as I believed that it would not process correctly because there is a "," in there. I re-tested and came across the same issue, still not populating.
Is it possible that it just doesn't like a "," in the column header regardless or not whether it has quotes around it?
Thanks
You can try using this template to parse any CSVs with in-data commas.
It should work as long as there are quotes around any items with in-data commas.
https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/CSV-to-Dataset/td-p/1508191
User | Count |
---|---|
89 | |
37 | |
26 | |
13 | |
12 |
User | Count |
---|---|
128 | |
53 | |
38 | |
26 | |
21 |