Hi @luke08156
When the Power Automate flow retrieves the .txt file from SharePoint, it converts the file's content to base64 encoding, which does not support certain special characters like ß, ö, ä, and ü.
Unfortunately, it is not possible to change the encoding to UTF-8 on the server side within Power Automate. However, there are a few workarounds that you can try:
Use a different tool to convert the base64 encoded content to UTF-8 before using it in your flow. For example, you could use a script or an online base64 decoder that supports UTF-8.
Use the "Compose" action in Power Automate to convert the base64 encoded content to a string and then use the "Parse JSON" action to convert the string to a JSON object. This will allow you to access the individual characters of the text and replace the special characters with their corresponding ASCII representations.
If the file is a .txt file and not a binary file, you can use the sharepoint connector to get the file content as a string and use the "Compose" action to convert it to a string.
If possible, you could also try to change the encoding of the original file before it is sent to SharePoint. This could be done by using a different tool to save the file with the UTF-8 encoding before it is attached to the email and sent to the Teams channel.
It's worth noting that depending on the nature of the text you are working with and the use case, it might be better to store the text in a different format, like JSON or XML, that supports UTF-8 encoding.
