How to copy azure blob CSV file to SharePoint list

[krish11]

I have created this flow for the copy file to SharePoint but I don't have any clear idea for this expression so it's throwing an error.

For split I have used this formula:

split(decodeUriComponent(replace(replace(uriComponent(body('Get_blob_content')),'%0D',''),'%0A','#NEWLINE#')),'#NEWLINE#')

this is my CSV file format in Azure blob storage:

"list_id","list_name","list_description"
"63D5A5","abc","xyz"

"63D5A5","cshbdj","fjdf"
"3D5A5","kfskjbk","abdjsbc"

Anyone can support me with this, it would be helpful.

[Gopala_Krishna]

@krish11 

You are getting the error as the UriComponent function expects it's parameter to be of type string. When you pass the body of blob content that would be in format of array. That's why you are facing the error. 

Please try to pass string value in the UriComponent function, or use any other function from the reference link shared.

For more information related to conversion functions, please check the link - Reference guide for functions in expressions - Azure Logic Apps | Microsoft Docs

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

if the information shared helps you, please consider giving a thumbs up 👍 and mark solution as resolved

[krish11]

@Gopala_Krishna 

Thanks for your reply. I have converted that UriComponent function parameter to type string. Here's the expression :

split(decodeUriComponent(replace(replace(uriComponentToString(outputs('Get_blob_content')?['body']),'%0D',''),'%0A','#NEWLINE#')),'#NEWLINE#')

And flow ran successfully. But I didn't get any value in the SharePoint list. Can you give me an expression that I can use to convert CSV into Sharepoint List? I don't know much about expressions. I just started learning.

[krish11 · Accepted solution]

Solved: Re: Transfer Azure data lake CSV file data to Shar... - Power Platform Community (microsoft....

Refer to this Post for the solution.

[Anonymous]

How to copy azure blob file to teams channel? The teams channel link should provide in the mail

[krish11]

@Anonymous 

What is your file format? And in which format you want file in Teams channel?