Since I need to export data into excels from PowerApps, I applied Power Automate as a media.
But all Chinese codes were exported in a wrong format.
I think I need to use UTF-8 to recode these words, but I have no idea where to change the setting.
This is how data looks like if I open the csv file directly which is in wrong format:
This is how data looks like if I save the csv file as txt and open it in the ANSI format which is correct:
Solved! Go to Solution.
Hello @Karen_Fan
I did try to replicate your method and can simulate a similar issue as yours.
I found this solution on this page and can confirm that this might be the fix to your issue.
Update that part of your Automate to
concat(uriComponentToString('%EF%BB%BF'),body('Create_CSV_table'))
This code makes the CSV with UTF8 encoding.
✔️ | Just in case you my answer helped you solve your problem, please mark/accept this as a SOLUTION. This helps community members if they experience a similar issue in the future. |
🔗 | 🕸bistek.space 🐦 @cha_bistek 📺 @BisTekSpace |
Just in case you my answer helped you solve your problem, please mark/accept this as a SOLUTION. This helps community members if they experience a similar issue in the future. |
bistek.space @cha_bistek @BisTekSpace |
Hello @Karen_Fan
Can you share how you are filling the export data? We need to distinguish whether it went wrong with Power Automate or Power Apps encoding. Below is how you address it with Power Apps.
When you send data to PowerAutomate, use the Language parameter in the Value function. For example below. This is to ensure that the encoded language is right.
If ever it's a PowerAutomate issue, I saw in this thread that UTF8 is unsupported but this is last year, so it might have been added/rectified this year. Will do further research and update my response.
✔️ | Just in case you my answer helped you solve your problem, please mark/accept this as a SOLUTION. This helps community members if they experience a similar issue in the future. |
🔗 | 🕸bistek.space 🐦 @cha_bistek 📺 @BisTekSpace |
Just in case you my answer helped you solve your problem, please mark/accept this as a SOLUTION. This helps community members if they experience a similar issue in the future. |
bistek.space @cha_bistek @BisTekSpace |
Hi @cha_cha
This is my PowerApps code of the export button:
This is Power Automate flow corresponding to the export button:
Hello @Karen_Fan
I did try to replicate your method and can simulate a similar issue as yours.
I found this solution on this page and can confirm that this might be the fix to your issue.
Update that part of your Automate to
concat(uriComponentToString('%EF%BB%BF'),body('Create_CSV_table'))
This code makes the CSV with UTF8 encoding.
✔️ | Just in case you my answer helped you solve your problem, please mark/accept this as a SOLUTION. This helps community members if they experience a similar issue in the future. |
🔗 | 🕸bistek.space 🐦 @cha_bistek 📺 @BisTekSpace |
Just in case you my answer helped you solve your problem, please mark/accept this as a SOLUTION. This helps community members if they experience a similar issue in the future. |
bistek.space @cha_bistek @BisTekSpace |