-)Hello guys,
I am trying to build an automation that from a CSV file it will update a SharePoint list.
I have a file system trigger that will run everytime a file is added or modified, then I use the file system action "Get file content" (at this stage, if I debug the output, a new tab will display and the special characters would be already as �)
I tried to decode, encode, base64ToString but nothing works ( example: instead of pró-forma it will show pr�-forma)
I even tried to create the CSV file in my OneDrive and then get the file content but without any success. If I open the file directly the words are correctly displayed. When I open using the power automate "get file content using path" the words are all replaced again with �
I also tried creating the CSV using the "concat(uriComponentToString('%EF%BB%BF'),body('Create_CSV_table'))" approach.
Flow
here the values come already with �
The CSV created in my OneDrive
At this moment I don't know what I am doing wrong, I checked the file after and it shows encoded with UTF-8.
Thanks in advance
