Hello,
maybe someone can help me with my specific case:
I'm trying to set up a flow that takes data from a SharePoint list, creates a CSV file and then updates a file in a SharePoint library.
I created it as follows:
1. recurrence as a trigger (1 time per day)
2. get items from SharePoint list
3. create CSV-table
4. two functions to replace the comma seperator with semicolon and to convert the file to UTF-8 with BOM (to show specific characters correctly, e.g. ä,ü,ö,ß)
the functions are:
concat(uriComponentToString('%EF%BB%BF'), body('CSV-Tabelle_erstellen'))
replace(body('CSV-Tabelle_erstellen'), ',', ';')
5. update an existing file in a SharePoint library with the output from step 4 as the content.
So far it works theoretically, but in the end it somehow puts the data in the file two times, one time seperated with commas in one column and one time as it should. Like it somehow restarts filling in the data.
I'll show you some screenshots:
I hope you can see what I mean. On the upper side it puts everything in one column, down its formatted correctly.
Does somebody know a way to fix this?
Thanks in advance
