How to parse a CSV file using Microsoft Power Automate, Azure Logic Apps, or PowerApps

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 that can be used in the Microsoft Flow.

Update: We included the Parse CSV action to our Plumsail SP connector. Now, it is an addition to this set of advanced SharePoint actions as well.

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 them further in the flow. The list of available headers could be found in the dynamic content window:

You can find a 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.

Conclusion

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

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 don’t hesitate to drop us a message to support@plumsail.com.