logo
Documents & Forms
Microsoft 365 & SharePoint Tools
Classic SharePoint Tools
Documents
Jun 17
How to parse a CSV file using Microsoft Flow, Azure Logic Apps, or PowerApps
Petr Bushuev
Petr Bushuev
Customer Support Engineer

If you’re working with csv files then you may need to automate the data usage. One of the common cases is to bulk generate documents from a CSV file. It could be the following scenario: A company has a CSV file with customers. They want to bulk generate invitations to a conference for all the customers, print them and send using postal service. In this article we’ll use Parse CSV action from Plumsail Documents connector. This action parses a CSV file into an array of objects with properties which can be used in the Microsoft Flow.

1

Parse CSV parameters

The action has 2 mandatory parameters: Content of CSV document and Headers. You need to specify the headers to be able to select further in the flow. The list of available headers could be found in the dynamic content window:

2

You can find detailed description of each parameter in the user guide.

Use Parse CSV action to bulk generate documents

Getting back to the case with invitations we can create this simple flow: parse the CSV file with the list of customers, then create DOCX document from a template and finally convert the created DOCX documents to PDF for further printing. The flow looks like this one:

3

Review How to read a CSV file in Microsoft Flow and bulk generate documents article for more information.

Conclusion

Parse CSV allows you to read a CSV file and access collection of rows and values using Microsoft Flow.

It is quite easy to work with CSV files in Microsoft Flow with the help of Plumsail Documents. Just register a Plumsail account to get started and follow the steps described in the articles to create your flows. If you have any questions do not hesitate to drop us a message to [email protected].

Note: The post has been originally published at Medium:
Have any questions?
Join our community or contact the support team: