web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate CSV UTF-8 Comma delimi...

Power Automate

Answered

CSV UTF-8 Comma delimited or CSV Comma delimited Check

(0) Share

Report

Report

Posted on by sree813

77

Dear,

How to find whether the CSV file format is either Comma delimited UTF-8 or just CSV comma delimited?
My flow works only on CSV Comma delimited and I would like to check the format so that the flow will not fail.
Thanks

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @sree813 ,

Based on my test, if it's a file with CSV UTF-8 format, the file content starts with "77u/":

otherwise, there isn't:

So, you can use a condition the check the content:

outputs('Get_file_content')?['body']['$content']

or

outputs('Get_file_content_using_path')?['body']['$content']

according to previous action you use in the flow.

Best regards,

Was this reply helpful? Yes No
sree813 77 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-jefferni,

Thanks for the idea. It works.

Cheers.

Was this reply helpful? Yes No

Join the conversation