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.

Create a Custom API using bulk request

Custom APIs in Dataverse is a great way to build your own API messages to run complex business operations in a single API. And best of all, they can be called from anywhere, whether using JavaScript, Cloud Flow, or even from a plugin.