CSV is having more than 2500 rows so when I am testing this with till 500 rows then it is taking time but working perfectly. Here is scenario for me: Drop csv file into Sharepoint folder so flow should be automated to read csv file and convert into JSON and create file in Sharepoint list. Hi Manuel, I have followed this article to make this flow automate. I inserted the space on purpose, but we’ll get to that.Īnd then, we can do a simple “Apply to each” to get the items we want by reference. The overall idea is to parse a CSV file, transform it into a JSON, and collect the information from the JSON by reference.įor example, if we have the file: name,date This will benefit the overall community, so I decided to build a CSV parser using only Power Automate’s actions. I want to answer this question with a complete answer. Finally, we depend on an external service, and if something changes, our Power Automates will break. You may not be able to share it because you have confidential information or have the need to parse many CSV files, and the free tiers are not enough. Although some of the components offer free tiers, being dependent on an external connection to parse information is not the best solution.
0 Comments
Leave a Reply. |