Did you know how to convert CSV to Array in Power Automate? No, then don’t worry! In this Power Automate tutorial, I will demonstrate how to import CSV to Array using Power Automate.
CSV in Power Automate usually refers to Comma-Separated Values, a plain text format representing a tabular column. CSV files are often used for importing and exporting data between different applications or systems.
How to Convert CSV to Array in Power Automate
Here, I will explain how to import CSV to Array using Power Automate.
The Excel spreadsheet shown in the screenshot will be converted to a .csv file and then imported into an array using Power Automate, as shown below.
Let’s see how to import CSV to Array using Power Automate step by step:
1. For this, I have created an Excel spreadsheet with a few columns such as Candidate Name, Candidate Age, Candidate City, and Candidate Registration Date.
2. Save the file with a .csv extension on the local device.
3. Navigate to https://make.powerautomate.com in your browser to open the Power Automate home page; click on + Create -> Select the Instant cloud flow -> Provide the flow name and choose the trigger’s flow(Manually trigger the flow).
I have added an input ‘File Content’ in this trigger as shown below.
4. To decode the data encoded in Base64 format, add the ‘Compose’ flow action (renamed as csvData) and provide expression.
base64ToString(triggerBody()['file']['contentBytes'])Where this expression is used to convert a Base64-encoded string into an equivalent plain text (string).
5. Then add the ‘Compose’ flow action, hit enter into inputs, and go to the next step.
6. Next, add the ‘Compose’ flow action (renamed as Array) and provide the required expression as shown below.
split(outputs('csvData'),outputs('Compose'))It is used to split a string into an array of substrings based on a specified delimiter.
7. Now, click Save and Test -> Test it Manually-> Inside Run flow tab, import the CSV file from your local device -> Click on Run flow.
8. The ‘Compose’ flow action will display the output according to the expression inserted in the Array(Compose) flow action as shown below.
This is how to import CSV to Array using Power Automate.
Conclusion
I hope you find this Power Automate tutorial helpful. Here, I have discussed how to import CSV to Array using Power Automate.
Moreover, you may like some more Power Automate tutorials:
- Convert UTC to Local Time Zone in Power Automate
- How to Convert String to Integer in Power Automate
- Power Automate formatNumber() Function
- Power Automate startOfHour() Function
Preeti Sahu is an expert in Power Apps and has over six years of experience working with SharePoint Online and the Power Platform. She is the co-author of Microsoft Power Platform: A Deep Dive book. As a Power Platform developer, she has worked on developing various tools using Power Apps and Power Automate. She also makes Microsoft 365 videos and shares them on YouTube.
