web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Automate
Answered

split function

(0) ShareShare
ReportReport
Posted on by 13

Hi,

 

I am creating a flow that would parse csv-file to share point list. 

 

I have found instructions where you first get content of the csv-file and then use split-function.

AR_0-1673431316788.png

In the example that I am following is also using this "get file content"-object in the split-function but for some reason split-function is giving me error below:

"Unable to process template language expressions in action 'Compose_-_split_by_new_line' inputs at line '0' and column '0': 'The template language function 'split' expects its first parameter to be of type string. The provided value is of type 'Object'. Please see https://aka.ms/logicexpressions#split for usage details.'."

 

Is there some other similar fuction that I should be using with objects or how should I proceed?

Categories:
I have the same question (0)
  • Verified answer
    Expiscornovus Profile Picture
    33,844 Most Valuable Professional on at

    Hi @A-R,

     

    If you want to retrieve the content and view it as a string (to be able to split it) you could use the $content property within the body and use a base64tostring function.

     

    Try something like below:

     

    split(base64tostring(outputs('Get_file_content_using_path')?['body']['$content']), outputs('Compose_-_new_line'))

     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 1,027

#2
Valantis Profile Picture

Valantis 815

#3
Haque Profile Picture

Haque 630

Last 30 days Overall leaderboard