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.
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:
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:
Review How to read a CSV file in Microsoft Flow and bulk generate documents article for more information.
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].