Overcoming OpenAPI 2.0 `multi` CollectionFormat Challenges in Power Automate Custom Connectors
Jun24

Overcoming OpenAPI 2.0 `multi` CollectionFormat Challenges in Power Automate Custom Connectors

Integrating APIs into Power Automate flows often requires creating custom connectors, a process that can encounter challenges with certain API specifications. Specifically, the OpenAPI 2.0 specification allows array and multi-value parameters to be passed in various formats, including the multi collection format. This format is particularly troublesome for Power Automate’s Custom Connector… Continue Reading Rick A. Wilson...

Read More
Installing PowerShell Modules in Firewalled and Air-Gapped Systems
Jun14

Installing PowerShell Modules in Firewalled and Air-Gapped Systems

Managing IT environments with limited or no internet access, such as firewalled systems or air-gapped setups, presents unique challenges. One of the critical tasks in such environments is the installation and usage of PowerShell modules, which often require internet access for download and updates. This guide provides a method to facilitate the offline installation of PowerShell modules using… Continue Reading Rick A. Wilson...

Read More
Microsoft Build 2024 Highlights
May24

Microsoft Build 2024 Highlights

This week Microsoft Build 2024 was held. I made a blog post a few weeks ago with a top 10 list of interesting sessions from a Power Platform perspective. I’m still catching up with the sessions I outlined, but here is a post which describes some of the highlights from what I’ve seen so far. How will AI shape your future? This was the overall message on the event page. How will it shape… Continue Reading...

Read More
Dataverse REST Builder and the Hidden Gems
May14

Dataverse REST Builder and the Hidden Gems

Written by wilmeralcivar88@gmail.com The Dataverse REST Builder, a crucial tool in XRMToolbox, enables creating and executing requests against the Dataverse Web API endpoint, invaluable for consultants who need to call Custom APIs from various parts of the platform, such as ribbon buttons. To use it, you connect to your environment, create a new collection and request, select the Custom… Continue Reading...

Read More
The ALM story for Custom Connectors
May08

The ALM story for Custom Connectors

This post is a part of a series of posts about custom connectors. In this post we will look at ALM for custom connectors. That story starts with the concept of Dataverse solutions. Here are my findings after working with custom connectors in solutions! There is a certification process you can go though in order to get a new connector to be available in the platform among the other… Continue Reading carinamclaesson’s...

Read More
Exported Custom Connector, where’s my client secret setting?
May08

Exported Custom Connector, where’s my client secret setting?

This post is part of a series of posts about custom connectors. In this post I’ll let you in on an issue I encountered recently. It has now been solved and might be good for you to know this was a bug and should be fixed soon (might already be ok in your region). In this post I will share my findings from that journey. In my previous post, I mentioned that nowadays it is required to… Continue Reading...

Read More
Unique Redirect URL for OAuth 2.0 Custom Connectors
May08

Unique Redirect URL for OAuth 2.0 Custom Connectors

This post is part of a series of posts about custom connectors. In this post I’ll remind you about the fact that you might have some old custom connectors that you need to take care of in case you created them using the common redirect URL, which earlier was the default option! February 17, 2024 was an important date, but if you did not pay attention to this then, it is not too late to do it… Continue Reading...

Read More
Using OAuth 2.0 in Custom Connectors
May08

Using OAuth 2.0 in Custom Connectors

This post is part of a series of posts about custom connectors. In this post we’ll look at custom connectors configured with OAuth 2.0 as authentication type. It’s assumed that you are already familiar with how to create a custom connector. If you are not, there are plenty of tutorials in the official documentation as well as from the community. You can also take a look at my old post (yes,… Continue Reading...

Read More
Revisiting Custom Connectors
May08

Revisiting Custom Connectors

Recently I encountered an issue with a custom connector configured with authentication type OAuth 2.0. It’s solved now and I realize that I have learned a lot since the last time I wrote about custom connectors. It’s time to take this subject, dust it off, and make a new series of posts, let’s revisit custom connectors! Why create a Custom Connector? Either you are just trying out… Continue Reading...

Read More
Power Apps – Work with JSON
Apr27

Power Apps – Work with JSON

In this article, let’s see how we can work with JSON format in our Canvas App. What JSON is? JavaScript Object Notation (JSON) is a lightweight format for exchanging data. It is based on JavaScript syntax, but is language independent and is commonly used for the transmission of structured data. JSON’s foundation is two structures: A collection of name/value pairs An ordered… Continue Reading Angelo’s Article on...

Read More
Get ready for Microsoft Build (online) – BizApps Edition
Apr19

Get ready for Microsoft Build (online) – BizApps Edition

May is approaching and do you know what that means!? Microsoft Build is around the corner! In case you have not registered yet, navigate to the event site, Microsoft Build, and get it done. It’s a hybrid event with possibilities to attend live in Seattle (to a cost) or online (free of charge). The session planner is available so you can already start browsing and planning what sessions to… Continue Reading...

Read More
Harnessing Host Form Data with PCF Controls in Model-Driven Applications
Apr15

Harnessing Host Form Data with PCF Controls in Model-Driven Applications

Introduction This tutorial delves into integrating PowerApps Component Framework (PCF) controls with host form data within Microsoft Power Platform’s model-driven apps. This article will guide you through the necessary scripting to expose and consume formContext and globalContext from a custom table called new_Competitor. Aimed at enhancing both custom and Microsoft Form Component PCF… Continue Reading Rick A. Wilson...

Read More
Microsoft Business Applications Launch Event April 2024
Apr12

Microsoft Business Applications Launch Event April 2024

This week the Microsoft Business Applications Launch Event for 2024 Release Wave 1 was held. A launch event marks the start of the roll out of a new wave. New features are presented in demos and customer stories are showcased. I watched it late evening here in Sweden, after it was sent (happy to be able to do so). In case you missed it, you can watch it on-demand now as well. <span… Continue Reading carinamclaesson’s...

Read More
SecurePay in Power Pages
Apr08

SecurePay in Power Pages

This post explains how to integrate with SecurePay (Asutarlia’s payment gateway) in a Power Pages site. It’s based on the similar architecture pattern explained in the post Power Pages Paypal integration. If you are interested in this topic, you may also want to check out my posts on the Anatomy of the Stripe payments in Power Pages and How to improve Stripe payments in Power Pages. Please… Continue Reading...

Read More
How to choose between the different types of Power Apps
Mar30

How to choose between the different types of Power Apps

There are so many app types in the Power Platform. How do you go about picking the right one? What are the pros & cons of each? The post How to choose between the different types of Power Apps appeared first on Hardit Bhatia: The Power Addict. Continue Reading Hardit Bhatia’s Article on their blog How to choose between the different types of Power Apps There are so many app types in the Power Platform. How do you go about...

Read More
How to make Power Apps more accessible?
Mar25

How to make Power Apps more accessible?

Learn what is accessibility, why is it relevant in Power Apps, and how to make each control in Power Apps more accessible! The post How to make Power Apps more accessible? appeared first on Hardit Bhatia: The Power Addict. Continue Reading Hardit Bhatia’s Article on their blog How to make Power Apps more accessible? Learn what is accessibility, why is it relevant in Power Apps, and how to make each control in Power Apps more...

Read More
How to make a Power Apps gallery accessible
Mar25

How to make a Power Apps gallery accessible

Galleries are used to display records from a table in a list form. Learn how with a few simple steps, you can make galleries accessible! The post How to make a Power Apps gallery accessible appeared first on Hardit Bhatia: The Power Addict. Continue Reading Hardit Bhatia’s Article on their blog How to make a Power Apps gallery accessible Galleries are used to display records from a table in a list form. Learn how with a few...

Read More
How to make a Power Apps HTML control accessible?
Mar25

How to make a Power Apps HTML control accessible?

HTML controls are used to show text and convert HTML tags to formatting. Learn how accessible they are and how to improve accessibility! The post How to make a Power Apps HTML control accessible? appeared first on Hardit Bhatia: The Power Addict. Continue Reading Hardit Bhatia’s Article on their blog How to make a Power Apps HTML control accessible? HTML controls are used to show text and convert HTML tags to formatting. Learn...

Read More
How to make a Power Apps timer accessible
Mar25

How to make a Power Apps timer accessible

Timers are used to record times in an app to perform actions when the set time ends. Learn how to make timers in Power Apps accessible! The post How to make a Power Apps timer accessible appeared first on Hardit Bhatia: The Power Addict. Continue Reading Hardit Bhatia’s Article on their blog How to make a Power Apps timer accessible Timers are used to record times in an app to perform actions when the set time ends. Learn how to...

Read More
How to make a Power Apps icon accessible
Mar25

How to make a Power Apps icon accessible

Icons are used to represent shapes, actions etc.. Learn a few simple steps to make icons in Power Apps accessible! The post How to make a Power Apps icon accessible appeared first on Hardit Bhatia: The Power Addict. Continue Reading Hardit Bhatia’s Article on their blog How to make a Power Apps icon accessible Icons are used to represent shapes, actions etc.. Learn a few simple steps to make icons in Power Apps accessible! Blog...

Read More
How to make a Power Apps add picture control accessible?
Mar25

How to make a Power Apps add picture control accessible?

Add picture controls are used to allow users to click new or upload existing pics. Learn how to make add pictures in Power Apps accessible! The post How to make a Power Apps add picture control accessible? appeared first on Hardit Bhatia: The Power Addict. Continue Reading Hardit Bhatia’s Article on their blog How to make a Power Apps add picture control accessible? Add picture controls are used to allow users to click new or...

Read More
How to make a Power Apps toggle accessible?
Mar25

How to make a Power Apps toggle accessible?

Toggles are used to allow users to select a value between true and false. Learn a few simple steps to make toggles in Power Apps accessible! The post How to make a Power Apps toggle accessible? appeared first on Hardit Bhatia: The Power Addict. Continue Reading Hardit Bhatia’s Article on their blog How to make a Power Apps toggle accessible? Toggles are used to allow users to select a value between true and false. Learn a few...

Read More
How to make a Power Apps slider accessible?
Mar25

How to make a Power Apps slider accessible?

Sliders are used to allow users to select a value between a min and max. Learn a few simple steps to make sliders in Power Apps accessible! The post How to make a Power Apps slider accessible? appeared first on Hardit Bhatia: The Power Addict. Continue Reading Hardit Bhatia’s Article on their blog How to make a Power Apps slider accessible? Sliders are used to allow users to select a value between a min and max. Learn a few...

Read More
How to make a Power Apps checkbox accessible?
Mar25

How to make a Power Apps checkbox accessible?

Checkboxes are used to allow users to select or deselect items. Learn a few simple steps to make checkboxes in Power Apps accessible! The post How to make a Power Apps checkbox accessible? appeared first on Hardit Bhatia: The Power Addict. Continue Reading Hardit Bhatia’s Article on their blog How to make a Power Apps checkbox accessible? Checkboxes are used to allow users to select or deselect items. Learn a few simple steps to...

Read More
How to make a Power Apps image control accessible?
Mar25

How to make a Power Apps image control accessible?

Image controls are used to display pictures. Learn a few simple steps to make image controls in Power Apps accessible! The post How to make a Power Apps image control accessible? appeared first on Hardit Bhatia: The Power Addict. Continue Reading Hardit Bhatia’s Article on their blog How to make a Power Apps image control accessible? Image controls are used to display pictures. Learn a few simple steps to make image controls in...

Read More
How to make a Power Apps screen accessible?
Mar24

How to make a Power Apps screen accessible?

Do you know which is the most frequently used control in Power Apps? The screen control! Learn a few simple steps to make it accessible! The post How to make a Power Apps screen accessible? appeared first on Hardit Bhatia: The Power Addict. Continue Reading Hardit Bhatia’s Article on their blog How to make a Power Apps screen accessible? Do you know which is the most frequently used control in Power Apps? The screen control!...

Read More
What is accessibility and why is it important in Power Apps
Mar24

What is accessibility and why is it important in Power Apps

What is accessibility? Is it important? Is it relevant to Power Apps? Here’s an introduction to accessibility in general and in Power Apps! The post What is accessibility and why is it important in Power Apps appeared first on Hardit Bhatia: The Power Addict. Continue Reading Hardit Bhatia’s Article on their blog What is accessibility and why is it important in Power Apps What is accessibility? Is it important? Is it...

Read More
How to optimize performance in Power Apps
Mar22

How to optimize performance in Power Apps

Are your apps performant? Are they optimized to be as fast as they can be? Learn why making performant apps is a key and how to do that! The post How to optimize performance in Power Apps appeared first on Hardit Bhatia: The Power Addict. Continue Reading Hardit Bhatia’s Article on their blog How to optimize performance in Power Apps Are your apps performant? Are they optimized to be as fast as they can be? Learn why making...

Read More
How to optimize fetching the same value again and again
Mar21

How to optimize fetching the same value again and again

Do you fetch the same record multiple times in an app? Do you really need to? Is there a better way to do it? Learn how! The post How to optimize fetching the same value again and again appeared first on Hardit Bhatia: The Power Addict. Continue Reading Hardit Bhatia’s Article on their blog How to optimize fetching the same value again and again Do you fetch the same record multiple times in an app? Do you really need to? Is...

Read More
How to increase performance by trashing extra screens and controls
Mar21

How to increase performance by trashing extra screens and controls

Screens and controls are the building blocks of an app. As their count increases, performance suffers. Learn how to minimize them! The post How to increase performance by trashing extra screens and controls appeared first on Hardit Bhatia: The Power Addict. Continue Reading Hardit Bhatia’s Article on their blog How to increase performance by trashing extra screens and controls Screens and controls are the building blocks of an...

Read More
How to get rid of cross screen dependencies
Mar21

How to get rid of cross screen dependencies

Do you know what are cross screen dependencies? Why are they bad? And how to fix them? Get answers to all these questions here! The post How to get rid of cross screen dependencies appeared first on Hardit Bhatia: The Power Addict. Continue Reading Hardit Bhatia’s Article on their blog How to get rid of cross screen dependencies Do you know what are cross screen dependencies? Why are they bad? And how to fix them? Get answers to...

Read More
How to optimize data calls inside a gallery
Mar20

How to optimize data calls inside a gallery

Have you ever made data calls inside a gallery and it takes a long time to load? Learn why it is bad and how to overcome it! The post How to optimize data calls inside a gallery appeared first on Hardit Bhatia: The Power Addict. Continue Reading Hardit Bhatia’s Article on their blog How to optimize data calls inside a gallery Have you ever made data calls inside a gallery and it takes a long time to load? Learn why it is bad and...

Read More
How to make concurrent multiple unrelated data calls
Mar18

How to make concurrent multiple unrelated data calls

We usually make multiple data calls like in an app’s OnStart. Do these have to run one after another or can they run concurrently? The post How to make concurrent multiple unrelated data calls appeared first on Hardit Bhatia: The Power Addict. Continue Reading Hardit Bhatia’s Article on their blog How to make concurrent multiple unrelated data calls We usually make multiple data calls like in an app’s OnStart. Do...

Read More
How to optimize fetching multiple records from a table
Mar18

How to optimize fetching multiple records from a table

A lot of times you would want to lookup multiple records from a table. Would you do that one at a time or is there a better way to do it? The post How to optimize fetching multiple records from a table appeared first on Hardit Bhatia: The Power Addict. Continue Reading Hardit Bhatia’s Article on their blog How to optimize fetching multiple records from a table A lot of times you would want to lookup multiple records from a...

Read More
How to optimize passing a record to Patch
Mar18

How to optimize passing a record to Patch

Patch is used to create new records or update existing records. Learn how to optimize patch when updating an existing record! The post How to optimize passing a record to Patch appeared first on Hardit Bhatia: The Power Addict. Continue Reading Hardit Bhatia’s Article on their blog How to optimize passing a record to Patch Patch is used to create new records or update existing records. Learn how to optimize patch when updating...

Read More
Power Pages custom domain and RRset conflict error
Mar18

Power Pages custom domain and RRset conflict error

When you create a Power Pages site, it will be available under the “powerappsportals.com” domain. If you want it to be part of your actual Internet real estate, you may want to add it to your organisation’s domain. The process of adding a custom domain to the Power Pages website is well documented here. What’s omitted, though, is an interesting detail you may face when doing it… Continue Reading...

Read More

How to optimize fetching multiple columns of a record

Learn how to optimize fetching of multiple columns using Lookup! Should you fetch each column separately or can you fetch all at once? The post How to optimize fetching multiple columns of a record appeared first on Hardit Bhatia: The Power Addict. Continue Reading Hardit Bhatia’s Article on their blog How to optimize fetching multiple columns of a record Learn how to optimize fetching of multiple columns using Lookup! Should...

Read More
How to optimize Lookup function by not using dot operator
Mar18

How to optimize Lookup function by not using dot operator

Learn how to optimize the Lookup function by not using the dot operator! Sounds counter intuitive but the difference is huge! The post How to optimize Lookup function by not using dot operator appeared first on Hardit Bhatia: The Power Addict. Continue Reading Hardit Bhatia’s Article on their blog How to optimize Lookup function by not using dot operator Learn how to optimize the Lookup function by not using the dot operator!...

Read More
How to create a responsive pop-up using layout containers
Mar13

How to create a responsive pop-up using layout containers

There are several elements in an app that can be made responsive. Learn how to make a pop-up responsive using layout containers! The post How to create a responsive pop-up using layout containers appeared first on Hardit Bhatia: The Power Addict. Continue Reading Hardit Bhatia’s Article on their blog How to create a responsive pop-up using layout containers There are several elements in an app that can be made responsive. Learn...

Read More
How to create a responsive pop-up using traditional containers
Mar13

How to create a responsive pop-up using traditional containers

There are several elements in an app that can be made responsive. Learn how to make a pop-up responsive using traditional containers! The post How to create a responsive pop-up using traditional containers appeared first on Hardit Bhatia: The Power Addict. Continue Reading Hardit Bhatia’s Article on their blog How to create a responsive pop-up using traditional containers There are several elements in an app that can be made...

Read More
How to create a left aligned responsive gallery
Mar12

How to create a left aligned responsive gallery

There are several ways in which a gallery can be made responsive. Learn how to build a left aligned responsive gallery! The post How to create a left aligned responsive gallery appeared first on Hardit Bhatia: The Power Addict. Continue Reading Hardit Bhatia’s Article on their blog How to create a left aligned responsive gallery There are several ways in which a gallery can be made responsive. Learn how to build a left aligned...

Read More
Syncing Azure DevOps Work Item Status to Microsoft Dataverse with Dataflows
Mar08

Syncing Azure DevOps Work Item Status to Microsoft Dataverse with Dataflows

In today’s fast-paced development environments, seamless integration between customer and development tracking systems can be crucial for maintaining transparency, efficiency, and alignment across teams. Our objective centers around a scenario faced by some organizations: synchronizing customer requirements captured by staff in Microsoft Dataverse with the development work tracked in Azure… Continue Reading Rick A. Wilson...

Read More
Govee and Power Platform: Transforming Smart Lighting Automation
Mar06

Govee and Power Platform: Transforming Smart Lighting Automation

Introduction In the evolving world of smart home technology, the integration of lighting solutions with sophisticated automation platforms is gaining significant traction. Our focus in this discussion is the Govee Lights Power Automate Connector, a pioneering tool that brings together the advanced capabilities of Govee’s smart lighting with the robust automation features of Microsoft Power… Continue Reading Rick A. Wilson...

Read More
Power Pages PayPal integration
Mar06

Power Pages PayPal integration

This post provides guidance on PayPal integration in the Power Pages site. It was inspired by a few requests on this topic, so I’ve decided to publish this guide. Microsoft Power Pages evolve fast, and the Stripe integration is now available out of the box. I wrote a post about the Anatomy of the Stripe payments in Power Pages and How to improve Stripe payments in Power Pages. Check those… Continue Reading...

Read More
Copilot(s) in Microsoft Learn part 2
Mar01

Copilot(s) in Microsoft Learn part 2

In my previous post I wrote about what I was missing in the Microsoft official documentation when it comes to Copilot. With AI capability being introduced in each and every product & feature, I can imagine the planning, introduction and updates of Copilot chapters to be quite some work.  In this post we’ll look at what chapters there are and focus on where to point people looking for… Continue Reading...

Read More

Step-by-Step to Success: Run AutoGPT using Azure OpenAI on Docker

Integrating AutoGPT with Azure OpenAI through Docker offers a direct path to unlocking advanced AI capabilities. This detailed guide not only walks through the initial setup and configuration steps but also emphasizes the critical adjustments required for effective Azure OpenAI integration. Let’s dive into a more focused and informative discussion on setting up AutoGPT and ensuring it works… Continue Reading Rick A. Wilson...

Read More

Leverage the Power Platform API to create a Capacity Report

As Solution Architects, we’ve all encountered the question from customers about monitoring the entire platform. While we have various methods to collect data (audit, application insights, system jobs, plugin trace logs, and more), we often find ourselves in a quandary when it comes to storage capacity. In this article, we’ll explore ways to harness these data sources effectively and endeavor… Continue Reading Allan...

Read More
Government API Development Playbook: Designing for Power Platform and Building Custom Connectors
Feb16

Government API Development Playbook: Designing for Power Platform and Building Custom Connectors

The article discusses integrating Government APIs with Microsoft Power Platform, emphasizing the creation and certification of custom connectors. It guides government API developers on adopting best practices and standards for API design to ensure compatibility and effectiveness within Power Platform. This includes leveraging tools like OpenAPI and Postman for development and navigating the… Continue Reading Rick A. Wilson...

Read More
Copilot(s) in Microsoft Learn
Feb16

Copilot(s) in Microsoft Learn

In my previous post I had Copilot(s) on my mind and shared my thoughts as I was looking into what’s what in the Microsoft Copilot ecosystem. In this post we will look at how the concept of Copilots looks in the official documentation, Microsoft Learn. Is the official documentation up to date? Lot’s of hits for Copilot! Let’s first check what happens if we search for Copilot. The… Continue Reading...

Read More
Copilot(s) on my mind
Feb16

Copilot(s) on my mind

A post dedicated to Copilots. When did we hear about it for the first time? Have you followed how the concept has evolved? What’s what? I recently had to delve into this myself and I thought I might as well write down my thoughts in a post. So here it is! One or several Copilots? The headline to this post probably already reviled it, in Microsoft context, we are not just talking… Continue Reading carinamclaesson’s...

Read More