cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

ms flow

In ms flow how we can create such flow when email arrives and email have a  .csv attachment in it by using that attachment we create lead 

how we can create this type of flow

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: ms flow

Hi @ishant281,

 

If you want to get the CSV file content, you should store these file into SharePoint or OneDrive first, then use get file content action to get the CSV file content.Annotation 2020-06-05 164343.jpg

 

Are these CSV files format fixed? If they are, you could refer to this post to learn how to parse these CSV tables.

https://powerusers.microsoft.com/t5/Building-Flows/Extract-Data-from-a-CSV-file/m-p/529944

 

If not, you can consider using connectors that can be used a limited number of times: 

https://docs.microsoft.com/en-us/connectors/encodiandocumentmanager/
Annotation 2020-06-05 164528.jpg

It could convert CSV into JSON directly, but it needs it only free for first 50 times.

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

6 REPLIES 6
Highlighted
Community Support
Community Support

Re: ms flow

Hi @ishant28,

 

You could set the Include attachments field to Yes. Then the trigger will be triggered only when the Email contains attachments.

Annotation 2020-06-05 091804.jpg

Then create a condition action to determine the attachment name whether ends with ".CSV" or ".csv", if it is, do next steps, or do nothing.

Annotation 2020-06-05 091511.jpg

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Highlighted
New Member

Re: ms flow

@v-litu-msft  sir i have already applied that portion i want to know after that how to read attachment file data and with  that attachment we create a lead

Highlighted
Community Support
Community Support

Re: ms flow

Hi @ishant281,

 

If you want to get the CSV file content, you should store these file into SharePoint or OneDrive first, then use get file content action to get the CSV file content.Annotation 2020-06-05 164343.jpg

 

Are these CSV files format fixed? If they are, you could refer to this post to learn how to parse these CSV tables.

https://powerusers.microsoft.com/t5/Building-Flows/Extract-Data-from-a-CSV-file/m-p/529944

 

If not, you can consider using connectors that can be used a limited number of times: 

https://docs.microsoft.com/en-us/connectors/encodiandocumentmanager/
Annotation 2020-06-05 164528.jpg

It could convert CSV into JSON directly, but it needs it only free for first 50 times.

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Helper I
Helper I

Re: ms flow

@v-litu-msft  thank you for replying i have use one drive and  i have done file content path thanks for telling but i still not got how to do parsing and convert that file into  in dynamic  and create a lead .sir please help i am stuck

 

and my attach file is .csv file and i am extracting from one drive and convert into lead for creating new record 

Highlighted
Dual Super User III
Dual Super User III

Re: ms flow

Hi!

Good stuff also here

https://sharepains.com/2020/03/09/read-csv-files-from-sharepoint/

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Highlighted
Advocate I
Advocate I

Re: ms flow

I have been advocating for Microsoft to include a basic "parse CSV" action to Power-Automate/Flow for literally years now.

 

C'mon Microsoft!  Get this fixed already!  We should not need to shell out $$$ for such a basic function that even you include in PowerShell to turn CSV formatted data into an "object".  This should just be "built in" the same way "Parse JSON" is.

Helpful resources

Announcements
secondImage

August 2020 CYST Winners!

Check out the winners of the recent 'Can You Solve These?' community challenge!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Users online (3,639)