Extract CSV file attachment from Outlook and convert it into json format automatically

[Reshmaelvin]

I need to extract a CSV file attachment from Outlook automatically and I need to convert the values in the CSV file into json format.It should be an automated cloud flow 

[v-yueyun-msft]

Hi , @Reshmaelvin 

According to your description, you want to extract a CSV file attachment from Outlook .

For how to extract the email attachments in outlook, you can refer to this:

Solved: read csv content from outlook attachment and show ... - Power Platform Community (microsoft....

And for how to convert the csv file content to the json , you can refer to this blog:

Power Automate: How to parse a CSV File to create a JSON array (tachytelic.net)

Best Regards,

Yueyun Zhang

[Reshmaelvin]

Thanks for the solution.But my problem is I have extracted CSV file from email and converted it to base64ToString. Now I need to parse this data to json.since it's a CSV file, i need the Json data in a required url.All these are working.But my issue is I need each value of the CSV file to be displayed with corresponding heading uniquely 

[v-yueyun-msft]

Hi , @Reshmaelvin 

Thanks for your quick response! Do you mean you want to dynamically generate the json object from csv headers/?

If I misunderstand what you mean, you can describe your needs and your expected outcomes in detail so that we can better help you.

Best Regards,

Yueyun Zhang

[v-yueyun-msft]

Hi , @Reshmaelvin 

I search the dynamic method to convert the csv content to the json. And i test it in my side . This is my flow:

The Apply to each action:

skip(split(outputs('Compose'),decodeUriComponent('%0D%0A')),1)

range(0,length(split(take(split(outputs('Compose'),decodeUriComponent('%0D%0A')),1)[0],',')))

split(take(split(outputs('Compose'),decodeUriComponent('%0D%0A')),1)[0],',')[item()]

split(items('Apply_to_each'),',')?[item()]

replace(replace(replace(replace(string(body('Select')), '{', ''), '}', ''), '[', '{'), ']', '}')

json(outputs('Compose_4'))

And the result is as follows:

And for more information, you can refer to :
How To Parse any CSV to JSON Array - DamoBird365

Best Regards,

Yueyun Zhang

[Reshmaelvin]

Can you please provide the link so that I can export the flow

[v-yueyun-msft]

Hi, @Reshmaelvin 

This is my test flow, you can just replace the "outputs('Compose')" in your side .

And i hope it can help.

Best Regards,

Yueyun Zhang

[Reshmaelvin]

Spoiler

A CSV file is converted to base64ToString.Now I need to convert it to Json using Parse Json and the output should need to be displayed in a URL.Can you help me?
And one more problem is there,do you know how to concatenate the outputs of a loop together and display it to a Url

[v-yueyun-msft]

Hi, @Reshmaelvin 

Thanks for your quick response! i am not surely understand " the output should need to be displayed in a URL".

Can you give me some sample data and your end result you need to me so that i can understand your need better!!

Best Regards,

Yueyun Zhang

[Reshmaelvin]

[v-yueyun-msft]

Hi , @Reshmaelvin 

In my unerstand , the "Parse Json" action just used to parse Json, so that we can choose the fields in Json to use, and this is generally a fixed Json, which cannot be dynamically recognized. You need to put your sample Json in Parse Json.

Best Regards,

Yueyun Zhang

[Reshmaelvin]

this is the flow i have created.dont know what is the input of parse json. the input is a csv file.it is converted to base64ToString. now it need to be parsed to json. expecting the output as follows

[v-yueyun-msft]

Hi , @Reshmaelvin 

You need to convert your csv file to json, and then you can put your json output to the Parse json action.

The Parse json action can not convert the csv file to json , you need to use the above methods i have replied to you.

Best Regards,

Yueyun Zhang

[Reshmaelvin]

Can you able to show a flow which converts CSV to Base64toString and then it to json and by using http, the output is displayed on a url

[v-yueyun-msft]

Hi , @Reshmaelvin 

If you want to use the csv file data as the body of http request.

I think you need to convert it to json first , it will be like this:

And the schema is an array :
[{obj1},{obj2},{obj3}]

So i think each of the obj is your body in your http request . You can use the "Apply" to each action to loop this array to get the each item which can directly put in your body of http request in my understand.

If I misunderstand what you mean, you can describe your needs and your expected outcomes in detail so that we can better help you.

Best Regards,

Yueyun Zhang

[Reshmaelvin]

Is there any flow which uses select and parse json method

[v-yueyun-msft · Accepted solution]

Hi , @Reshmaelvin 

If the json is like this:

We can use the Apply to each action and parse json like this to get each item of this array:

Best Regards,

Yueyun Zhang