cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gaborszollosy
Helper I
Helper I

Working with CSV content

Hello there!

 

I'm trying to handle a CSV file, but when I use the compose connector, I get � characters instead of any non-english alphabet characters (like áéíóöőúüű).

 

The compose expression is currently:

concat(trim(replace(base64ToString(outputs('Get_file_content_using_path')?['body']['$content']),'�','')),';')
 
Ultimately I only want the "AD ID" column data from this CSV to find the facebook ad ID and count how many times it's in the file, but the whole compose output is so messy, I really can't work with it properly.
 
So if there's a way that I can bypass all other data in the file and just count the content of this one column, that would be awesome! Have you guys worked with CSVs earlier? I'm sure you have some great ideas 😅
 
I appreciate any help!
Kind regards,
Gabor
1 ACCEPTED SOLUTION

Accepted Solutions
v-bofeng-msft
Community Support
Community Support

Hi @gaborszollosy :

This is a known issue, I also encountered the issue you mentioned.

vbofengmsft_0-1634779739233.png

 

vbofengmsft_1-1634779739657.png

 

I am afraid this problem cannot be solved by Flow or PowerApps for the time being.I suggest you use this alternative first(Use UTF-8 mode to re-import the file):

  1. Open Microsoft Excel
  2. Click on the Data menu bar option.

vbofengmsft_2-1634779739929.png

 

3. Select the file

vbofengmsft_3-1634779739662.png

 

vbofengmsft_4-1634779739666.png

 

4.Choose UTF-8 Mode

vbofengmsft_5-1634779739670.png

 

The Result:

vbofengmsft_6-1634779739927.png

 

I think these links will help you a lot:

Create a .csv file that uses UTF-8 character encoding 
How to import a .csv file that uses UTF-8 character encoding 

Best Regards,

Bof

View solution in original post

2 REPLIES 2
v-bofeng-msft
Community Support
Community Support

Hi @gaborszollosy :

This is a known issue, I also encountered the issue you mentioned.

vbofengmsft_0-1634779739233.png

 

vbofengmsft_1-1634779739657.png

 

I am afraid this problem cannot be solved by Flow or PowerApps for the time being.I suggest you use this alternative first(Use UTF-8 mode to re-import the file):

  1. Open Microsoft Excel
  2. Click on the Data menu bar option.

vbofengmsft_2-1634779739929.png

 

3. Select the file

vbofengmsft_3-1634779739662.png

 

vbofengmsft_4-1634779739666.png

 

4.Choose UTF-8 Mode

vbofengmsft_5-1634779739670.png

 

The Result:

vbofengmsft_6-1634779739927.png

 

I think these links will help you a lot:

Create a .csv file that uses UTF-8 character encoding 
How to import a .csv file that uses UTF-8 character encoding 

Best Regards,

Bof

View solution in original post

Thank you very much for your answer, I understand @v-bofeng-msft. I appreciate your time and help!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Users online (1,868)