Get Rows(Parse) from CSV file using Power Automate and bulk generate documents

This is my solution to an Idea(Text (CSV) file - Get rows) requested by Power Automate community which have 500+ upvotes. In this article, I will demonstrate how to get the CSV files Content in Power Automate, Parse the CSV using a little bit of 'TypeScript magic' using the 'Excel Run Script action' (yes you read it right - we are going to invoke code without a third party action in Power Automate) and we will then use result from the 'Run script' action and bulk generate documents.

Working with SharePoint List using SharePoint Send HTTP Request action in Power Automate

The SharePoint Connector in Power Automate provides many actions with which you can create items, get items, delete items etc. But some scenarios the out of box actions do not handle your requirements (You cannot create a SharePoint List etc.), or the action you are looking for is not yet available in the SharePoint connector. In Power Automate, the SharePoint Send HTTP Request action lets you construct and execute SharePoint REST API queries and help you handle scenarios the out of box actions do not handle your requirements.