Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Is it possible to output UTF-16 LE encoded files or email attachments?

(0) ShareShare
ReportReport
Posted on by

Hi all,

 

First off, I am a beginner, so thank you for bearing with me. With that said, I have a cloud-based flow that:

  1. retrieves responses from an MS Form
  2. creates a CSV table from selected response data
  3. then I use compose actions to get the exact output style I need
  4. then I turn that compose output into a Send email (v2) attachment as a .txt file using this input:wards_ada_0-1706206317904.png

This text file goes to a mailbox to be imported into FileMaker Pro software that only handles UTF-16 LE encoded files. The problem is that the text file the flow creates is encoded UTF-8 and does not import properly into the software.

 

Does anyone know if there is anything I can do in the flow that would allow me to send this file with UTF-16 LE encoding to match output from the legacy form I am hoping to replace?

 

I have solved all my other problems with other flows by reading this community, so huge thank you to everyone who contributes!

  • lbendlin Profile Picture
    7,945 Super User 2025 Season 1 on at
    Re: Is it possible to output UTF-16 LE encoded files or email attachments?

    So give it a try.  Use the FFFE BOM, and then iterate through all the characters in your source text and write them to the output with a 00 in between

     

    The Unicode Standard, Version 15.0

  • wards_ada Profile Picture
    on at
    Re: Is it possible to output UTF-16 LE encoded files or email attachments?

    I don't believe so, there does not appear to be any real reason that the legacy system was set up to use UTF-16 LE, but the CSV files are added to an ongoing database that has always utilized that encoding. When I tried importing the CSV file generated by Power Automate it displayed incorrectly in the software the users are working with, so that's why I started researching a way to get the encoding to match without having to manually download the file and convert it using another program before importing it.

  • lbendlin Profile Picture
    7,945 Super User 2025 Season 1 on at
    Re: Is it possible to output UTF-16 LE encoded files or email attachments?

    Does your original text have non-ANSI characters?  LE is basically just BOM followed by your character followed by zero , then next character, then zero etc. Unless you have actual UTF-8 encoded characters...

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 566 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 516 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 492