How to sync Azure sql table to sharepoint list?

Hello @SachK - I understand that you're looking to accomplish this with Functions, and not use Power Automate but can Logic Apps be a consideration? In this case, I think that leveraging Logic Apps would be quicker in terms of time-to-solution, and be easier to maintain in the long run. A compelling case for me to use Functions would be if some type of granular data transformation & processing is needed during in-transit and I would look at Azure Durable Functions for its stateful orchestration.

Microsoft Flow (Scheduled Job) or Azure Function app or Azure SQL DB à O365 SP List

Our solution is completely generic and can be used for multiple lists vs DB table synchronization just by changing configuration.

Components

• Azure: Function App, SQL DB, Log Analytics
• O365: SharePoint List, Microsoft Flow

Now, let’s go through the detailed discussion required to implement the sync job between list and DB table. Below mentioned are the steps that we will follow in this article:

1. Create SharePoint list
2. Create Azure SQL DB and table
3. Generate Client ID and Secret & grant access at site level
4. Create Azure function app
5. Create Log Analytics
6. Create Microsoft Flow for SP to Azure SQL Sync (Single item)
7. Create Microsoft Flow for Azure SQL to SP Sync (Multiple items)
8. Add Azure Function App Configuration (Key & Value Pair)
9. Test it by adding/updating items in SP list and DB table

For more details use the below link.

[https://technovert.com/blog/sync-o365-sharepoint-list-data-to-azure-sql-db-table-using-microsoft-flow-azure-function-app/