Generate a file with Unicode coding

(0) Share

Report

Posted on by JM-14081323-0

Hi,

does anyone know why a CSV file generated from dataverse table data through Power Automate does not translate correct Czech diacritics letters? I want it to be in Unicode and tried to coop with base64 somehow, but result is still the same.

See attached. Many thanks

Categories:

Business Process Flows

pa.detail.png

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Tomac 3,198 Moderator on at

Like (1)

Report
Generate a file with Unicode coding

Hi @JM-14081323-0

This limitation appears to be in the Create File action for SharePoint. I've been able to replicate the issue, and the characters are correct pulling from Dataverse, going through a Compose, and going through a Create CSV Table action. It's not a documented limitation on Microsoft's documentation site, but we do have an option to resolve this.

By default, the Create File action doesn't define a default character set, so while Power Automate uses UTF-8 the CSV file isn't explicitly defining the use of that character set. We can force it, though, with the following expression in our Create File action:

concat(uriComponentToString('%EF%BB%BF'), body('Create_CSV_table'))

Which looks like this in practice:

This should resolve the issue in your finalized CSV file.

Was this reply helpful? Yes No
Suggested answer

Ellis Karim 11,490 Super User 2025 Season 2 on at

Like (0)

Report
Generate a file with Unicode coding

Hi

I have read that you need to add a Byte Order Mark (BOM) to the beginning of the CSV file content in Power Automate.

By adding the BOM, it prevents issues with character encoding, particularly when the file is opened in Excel or other applications that may not automatically detect UTF-8 encoding without the BOM present.

To fix this, after the Create CSV table action, add the following expression in the "File content" field of the "Create file" action (or other action) in Power Automate:

concat(uriComponentToString('%EF%BB%BF'), body('Create_CSV_table'))

Ellis Karim
elliskarim.com | LinkedIn | Bluesky
If this solved your issue, please mark it as ✅ Accepted Answer. If it helped, feel free to give it a 🩷 Like!

Was this reply helpful? Yes No