Import Excel file using Custom API and Alternate keys

Have you ever had headaches trying to build an integration using an Excel file?

If so, let me walk you through this blogpost where I’ve been trying to combine some tools to import an Excel file using Power Automate, but in a much more efficient way than using just the Excel connector.

In this solution I am using a cloud flow, a custom API and alternative keys to create a bulk Upsert request.