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.

Speed up your development process with GitHub Copilot

Are you ready to take your development experience to a whole new level? GitHub Copilot is your ultimate development companion, designed to boost your development process and increase your productivity. In this blogpost, I’ll walk you through every aspect of GitHub Copilot, from installation and configuration to creating an Azure Function connected to Dataverse that demonstrate how Copilot Works.

Power Happening building highlights

Power Happening solution is live, this solution is about a Model Driven App that helps you to organize your community events. Together with my friend Ben den Blanken, we spent our free time over the last few months building this solution.

Therefore I’d like to share our findings building it and leveraging Scott’s PCF to deliver a drag & drop experience

Power Platform Release wave 1 2023

It’s here, the release of wave 1 2023 was announced. Every year Microsoft delights us twice with the wave of releases so this time I wanted to share my list of top features about Power Platform I hope you enjoy it as much as I did reading it.

Create a twin record with its children using a table relationship and field mapping

You have probably leverage of the field mapping functionality at some point, to copy fields from table A into a new record in table B. But what happens when you have a scenario like the following one: Copy fields from table A.1 (Child table of table A) into table B.1 (Child table of table B).

For this scenarios you have a hidden gem like the InitializeFromRequest class that you can use in a plugin or in a Custom API. let me walk you through this blogpost and show you how this can be done leveraging the out of the box features like table relationship and field mapping.

Calling a Custom Page using modern commanding and TypeScript

If you want to use two heavyweight Power Platform components like Custom Page and Custom API to solve a business problem by offering a different user experience and applying complex logic at the same time, then let me show you how you can combine them.

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.