Microsoft Azure-Powered Data Transformation

Purpose Parse various input data, tranform and transmit it successful via API call and receive enriched data related to people and properties Stack Needs Microsoft & Azure Scope & Flow 1- A Power Automate flow is triggered when a new file is uploaded to a specific SharePoint or OneDrive folder. 2- The flow sends the file to an Azure Function. 3- The Azure Function (written in a language like Python or C#) contains the logic to: Parse the input file. Call the Data warehouse API for each record. Process the complex, nested data returned by the API. Create the "wide" sheet with all enriched data and the separate "to verify" sheets (for emails, phones, addresses). 4- The Azure Function then saves these newly generated Excel files back to a designated output folder in SharePoint or OneDrive. Goals Robust & Scalable, Cost-Effective and create the feel of a "Magic Folder" Feel: The entire process is automated. The user just needs to drop a file into a folder. Resources I will provide multiple input files, a successful output file, the App Script from Google Sheet that currently works with the API call, the API Docs. I look forward to working together! Note: I have accomplished the above in Google Sheet, have a newborn at home, and need someone with Microsoft Ecosystem experience to create the solution above - so I can sleep.