Our CRM exports a csv file encoded in ISO 8859-1, that gets automaticly placed in a sharepoint folder every day.
We have no control over the makeup/type of this file.
It is a list of currently active projects with a lot of special characters such as "é,ö,ä,à ,°,ç,ü,è, "" ! etc.
We need to be able to import all lines as items in a sharepoint list to process infomation in other processes.
Sofar the import works as intended, but values with one of these special chars produce an ? symbol that will break the automaticly generated filenames, urls, vars etc. of the following processes.
Is there a way, that does not involve manualy importing the csv in excel and saving it as utf8?
We have powerautomate prmium subscriptions and the small AI learning credits package, i would prefere if it could be done with the microsoft provided tools and not some external API/provider.
The file:
csv seperated by semicolons (;)
sharepoint get file content:
{
"$content-type": "application/octet-stream",
"$content": "IlByb2pla3QLjAxLjIw.........."
}
compose as a string: (anon string value of header and one entry)(every special char would of course be replaced by a ?)
"ProjectNr.";"Sömeheäder";"Sömeheäder";"Sömeheäder";"Sömeheäder";"Sömeheäder";"Sömeheäder";"Sömeheäder";"Sömeheäder";"Sömeheäder";"Sömeheäder";"Someheader";"Someheader";"Someheader";"Sömeheäder";"Sömeheäder";"Sömeheäder";"Sömeheäder";"Sömeheäder";"Sömeheäder";"Sömeheäder"
"999999";"Someproject, Description öüäöäö$";;;"ZZ";;"SomeVälüe";;;;"SomeVälüe";"SomeVälüe";;"01.01.2023";"01.01.2023";"01.01.2023";;"999.99";"1";;
The processing of the file after this step is not a problem and the split/select statements are all working fine.
Due to dataprotection i will not be able to provide the real file nor screenshots of active data.
