Power Automate and Logic Apps for OneDrive and Azure SQL
Budget: $30 – $250 USD
High-level objective: I have HTML and XML documents in OneDrive which I would like to parse into Azure SQL.
Existing functionality:
1. User completes HTML form using Android app
2. HTML form file is saved to OneDrive on Android device
3. OneDrive app on Android device syncs with cloud and file is uploaded
New functionality:
1. Once a file is uploaded, it should be moved using Power Automate to a folder in OneDrive and/or a folder in Azure Storage (this folder is only accessible by admin users or SQL users, not regular users of the Android app)
2. Once the file has been moved, an existing stored procedure in Azure SQL should be called (again using Power Automate) to parse the file data into the DB
3. For this a Logic Apps connector is probably needed between Azure SQL and OneDrive or Azure Storage
Deliverables:
- Preferred: a PowerShell script to configure the automation and Logic Apps connector described under New functionality above.
- Alternatively: Remote session to perform the automation and configuration described under New functionality above.
Existing functionality:
1. User completes HTML form using Android app
2. HTML form file is saved to OneDrive on Android device
3. OneDrive app on Android device syncs with cloud and file is uploaded
New functionality:
1. Once a file is uploaded, it should be moved using Power Automate to a folder in OneDrive and/or a folder in Azure Storage (this folder is only accessible by admin users or SQL users, not regular users of the Android app)
2. Once the file has been moved, an existing stored procedure in Azure SQL should be called (again using Power Automate) to parse the file data into the DB
3. For this a Logic Apps connector is probably needed between Azure SQL and OneDrive or Azure Storage
Deliverables:
- Preferred: a PowerShell script to configure the automation and Logic Apps connector described under New functionality above.
- Alternatively: Remote session to perform the automation and configuration described under New functionality above.