web

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

News and Announcements icon

Power Platform CommunityForums Power Automate split get file content

Power Automate

Unanswered

split get file content

(0) Share

Report

Report

Posted on by CU13031221-0

4

Hello,

I feel like I've searched the whole internet now, but I can't get it to work.

I have a CSV file in the SharePoint, with the content i get via "get file content".

I now must divide the content; each line ends with "/r/n"

I have tried this

split(body('Get_file_content'), '\r\n')

and that

split(body('Get_file_content'),decodeUriComponent('%0D%0A'))

and more.

But nothing works.

If I first load the content into a string variable, it works for small files, but not for large ones.

Categories:

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (0)

Sort by

v-dezhili-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @TimoB ,

Please try:

split(base64toString(body('Get_file_content')?['$content']),decodeUriComponent('%0D%0A'))

Best Regards,
Dezhi

Was this reply helpful? Yes No
CU13031221-0 4 on at

Like (0)

Report
Copy link

Link copied!

Hello v-dezhili-msft,

I have to change the "Infer Content Type" to no

else I get this error.

the output then, is this.

I think it is, because the input file has more than 131000 characters in it.

Was this reply helpful? Yes No
v-dezhili-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @TimoB ,

Can I see the output of your get file content action?

Best Regards,
Dezhi

Was this reply helpful? Yes No
CU13031221-0 4 on at

Like (0)

Report
Copy link

Link copied!

here it is

if i set the "Infer Content Type" to yes
it looks like this.

Was this reply helpful? Yes No

Join the conversation