CSV Action and List Variable in Power Automate Desktop

Hello Readers !! In this blog we will see how we can use the CSV action and list variable in Power Automate Desktop (PAD). Most of the time we need to read data from the CSV file. In my today’s example, we will see how to read columns in CSV. This example will help in understanding the CSV action of Power Automate Desktop.

Read from CSV File

Before we proceed to read from CSV under Power Automate Desktop, need to create a CSV file. As you can see from the below screenshot, I have created an Empfile.csv. This is very simple with Name, StaffID, and MobileNO as column headers.

After creating the CSV file, use Read from CSV file action of Power Automate Desktop. Use the default configurations as it is given. Provide the File path and enable the First line contains column names option. You can refer to this link on how to start with Power Automate Desktop (PAD).

Retrieve Data Table

Now in this step, we will retrieve the data table column into the list. Basically, this action of Power Automate Desktop converts the contents of a data table column into a list.

Set the Data table value is equal to the CSV Table variable. And column name or index is equal to 0 because here I want to show the first column. You can provide the index value as per your requirement.

Display Message

Now in next step, I will display the column as list data into a message box. As you can see in below screenshot, message to display value is equal to column as list variable.

After completing the above steps, hit on the Run and you will see result like below screenshot.

Hope you all will like this small demonstration on CSV and list variable in Power Automate Desktop. If you like this post, please share and subscribe to our site for more articles. Also, you can post your suggestion for the next article in the comment box.
Thanks !!