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.
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.
Nintex Xtensions framework for Nintex Cloud, allows you to create custom connectors to third-party platforms in your workflows. In this example, you will create a custom connector that will help you Convert, Merge, Watermark, Secure and OCR SharePoint files.