Power automate
We currently use the Power Automate desktop version to download CSV files to a local drive from a portal. We then use PA to extract the data from the CSV into an Excel workbook.
This flow will change into the following
- use Power Automate to download the CSV files
- Use PA to extract predefined fields from the CSV and upload them into a SQL database on Azure.
What are the products we require for this flow?
how can we do this?