Debug Compose actions and Conditions in Power Automate

Debug compose actions and condition steps can be difficult as flow runs will only show the output of your expressions. In this post a workaround, to make this easier. Try-Catch-Finally Before I go into the solution, it will be useful to reintroduce the Try Catch Finally pattern used within this post. It has been a while since I wrote my first Try catch pattern post, 4 year ago, and since then it has been accepted as general best...

Read More

What can I do with my Power Automate Licenses?

Do you know what you can do when you purchased Power Automate licenses? Or what does that Trial that you enabled give you? Power Apps Plan(s) In Power Apps the option to see which licenses you have has been available for a little while in the Settings menu under Plan(s). This then gives me the underwhelming overview of my licenses. But if you want to know more you will need to go to Power Automate. Power Automate Licenses Today I...

Read More

Azure Application Insights and Error Handling in Power Apps

This post is all about error handling in Power Apps with Azure Application Insight. Logging all events in your app (wanted and unwanted) within an easy to use log. Enable the Application Insight feature To enable the Azure Application Insights integration we will first need to enable to Pass errors to Azure Application Insights. If however you want to also catch any erroring code you will also need to enable the Formula-level error...

Read More
Stripe OLT: The Cloud & Cyber Security Specialists – YouTube
Jul22

Stripe OLT: The Cloud & Cyber Security Specialists – YouTube

Stripe OLT: The Cloud & Cyber Security Specialists source

Read More

Boolean logic in Power Apps

This post is all about Boolean logic in Power Apps. So that is all the true/false stuff within your app. true and false In short we have two values that are important in Boolean logic. And we actually have 3 values that are relevant: truefalsenull/empty/nothing/undefined ( or whatever you would like to call this) In Power Apps we can now use this true and false to check if something is true or if it is false (yes this sounds indeed...

Read More

Secure your SharePoint data in Power Apps using Power Automate

Although Dataverse is available many of us still use SharePoint to store their data. But how do you secure your SharePoint data? Or are you just happy for people to edit your data outside your app? SharePoint is not a database!? I often hear that SharePoint is not a database. Our friends from Oracle use the following definition of a database: A database is an organized collection of structured information, or data, typically stored...

Read More
Stripe OLT X Microsoft – HLK, E5 case study – YouTube
Jul21

Stripe OLT X Microsoft – HLK, E5 case study – YouTube

Stripe OLT X Microsoft – HLK, E5 case study Want to understand the benefits of Microsoft’s E5 Licensing? Hear directly from Haseltine Lake Kempner, who recently transitioned to this enterprise, business technology solution. Want to understand the benefits of Microsoft’s E5 Licensing? Hear directly from Haseltine Lake Kempner, who recently transitioned to this enterprise, business technology solution....

Read More

Application Lifecycle Management and Power Pages

In my recent posts about Power Pages, I’ve looked at development of pages, but I’ve not considered Application Lifecycle Management (ALM) yet. Application Lifecycle Management In general I would recommend to have at least 3 environments for any development work. These environments should include: DevelopmentTestProduction But they could also include environments like training, UAT and quite a few more depending on your ALM...

Read More
Moving a Canvas app into a solution and keeping the associated URL and ID in different environments
Jul16

Moving a Canvas app into a solution and keeping the associated URL and ID in different environments

If for any reason you have built a Canvas app outside of a Solution, and published it to multiple environments using the export/import functionality of Power Apps, if later you decide to add it to a solution (best practice) and redeploy the app to those environments using solution export/import, you will be duplicating the canvas app and the canvas app present in the solution will have a different ID and by consequence a different...

Read More

Get started with Liquid in Power Pages

In this post I’m going to introduce some code into my Power Pages ultimate user guide, by introducing Liquid. Find your liquid in Power Pages In one of my recent posts I talked about editing pages in Power Pages. Using the most left icon of the above four, you can open the page editor. As you open the editor you will notice some html code and some code that sits within {% and %} or {{ and }}. The stuff sitting between these...

Read More

User relevant Power BI components in Power Pages

Do you want to have a different Power BI component configuration in Power Pages depending on who is logged in, making the data user relevant? Some background How about creating a page in Power Pages that lets you display Power BI reports depending on the user that is logged in? So depending on which company a user works at, they get a different report shown? So for different companies I have a different Power BI report to be...

Read More

5 years of Microsoft MVP-ness

Today I received an email confirming my 5th Microsoft MVP award. Time has flown since those first nomination emails in 2017. The Microsoft MVP Award For anybody reading this post I thought that it might be useful to explain what the MVP Award stands for. When do you get the MVP Award? And what do you need to do get get an MVP Award and become part of the Microsoft MVP program. The Microsoft MVP award is given to community leaders who...

Read More

Error when trying to retrieve data from the network

Today I got the error: Error when trying to retrieve data from the network What is causing the Error when trying to retrieve data from the network error? The first step is to identify which line of code is generating the error. Quite quickly I identified that the following code caused the problem. ClearCollect( colAllDocuments, ‘Documents’ ); The above line of code is reading document details form a document library and in...

Read More

Return Arrays from Power Automate to Power Apps without a premium licence

When you want to return arrays from a flow in Power Automate to an app in Power Apps you could use the Response action, however this requires a premium connector Avoiding the premium licences First of all if your flow really uses premium features then just get that premium licence in place, but if you don’t use any other premium features then you might want to use the method described in this post to avoid the costs of a premium...

Read More

Display the environment name in your Canvas App in Power Apps

So you start using environments and you deploy the app across multiple environment. How do users know which environment they are in? Get the environment name There are two easy options to get the environment name while running an app. Use an environment variable that you set during deploymentCreate a flow that finds the environment name The first option is easy, just set a text environment variable to the right value and your done....

Read More

Create custom content instead of components in Power Pages

After yesterday’s post about components today I’m looking at a bit more detail and how we can create custom content on our pages. Finding the technical bits To find out how the Power Pages really work, there is a model driven app available. This model driven app can be accessed through the Portal Management option the Power Pages menu . I’ve created a page in Power Pages And when I look in the Portal Management app I...

Read More

Style your Power Pages, the easy way

When you try out Power Pages, and you have created some pages, you might want to adjust the styling of the page. In this post the options. Style your pages with a Theme Once you have opened your Power Pages site, you can select the styling option on the left hand side to change the Theme used by your pages. This way you can change a page that looks like this: To a page that looks like this: The above change you can make with just a...

Read More

1 Client ID, 1 Secret and a Bearer token in Power BI

Connecting to data sources in Power BI can be very easy. But when you need to call three end points to get to your data with Secrets, Client IDs and Bearer tokens it can be a bit harder to get your data. Background on the API Sometimes APIS are nice and easy to use and sometimes APIs are just a pain. If all you have to do is connect to your data source by clicking a few button, it would be no fun. In this post I will look at one of...

Read More

Create custom content instead of components in Power Portals

After yesterday’s post about components today I’m looking at a bit more detail and how we can create custom content on our pages. Finding the technical bits To find out how the Power Pages really work, there is a model driven app available. This model driven app can be accessed through the Portal Management option the Power Pages menu . I’ve created a page in Power Pages And when I look in the Portal Management app I...

Read More

Components in Power Pages, a quick overview

As we saw in my most recent post about Power Pages, content of pages are made up of components. In this post I will go through the existing Power Pages components Available components The following components are available in Power Pages TextButtonImage, VideoSpacerPower BIListFormiFrame The Text component The text component might look like the simplest of components, but it is actually even simpler than you think. In the below...

Read More

Edit Pages in Power Pages, a quick overview

So you got started with Power Pages, and now you’re ready to edit pages in Power Pages. This post will guide you through the first steps. Power Pages Studio vs Site Preview Our site is ready and now we want to make some customizations to the site. Before we edit pages in Power Pages, I will walk through the options by clicking on the Edit button. First of all it is important to understand the differences between the Power Pages...

Read More

Get started with Power Pages super quickly in 5 minutes

In this post I will look at how to get started with Power Pages. In this post I will guide you through the first steps that you can take with this amazing platform. The first steps You might ask, What is Microsoft Power pages? Well Power Pages is the new platform that Microsoft have recently launched that will help you set up your own website. Complete with option to let your clients or user login to your site. Time to dive into the...

Read More
Hide view in Microsoft Lists
Jun12

Hide view in Microsoft Lists

Photo by Brando Louhivaara on Unsplash Microsoft Lists views are powerful, and you can adjust them as your need. You can have basic ones for regular users and more advanced ones, for instance for the admins of the site. Obviously, all the views are available for all the users which will have access to them. However, a few weeks ago I found that you can hide those views. The… Continue Reading David Ramalho’s Article on...

Read More
How we do Construction Project Planning with help of Primavera P6 – YouTube
Jun10

How we do Construction Project Planning with help of Primavera P6 – YouTube

How we do Construction Project Planning with help of Primavera P6 Most Trusted Oracle Primavera Project Planning Management & Consultant in India. Wiznic World provides an extensive training in latest version of Primavera in PPM and EPPM as well. We are specialized in Oracle Primavera Project Management software with an expertise in provision of certified Oracle Primavera Training and Consultation. Our consultants are Oracle...

Read More
Updating list views JSON formatters for a SharePoint list using Power Automate
Jun08

Updating list views JSON formatters for a SharePoint list using Power Automate

Imagine a case where you want to apply the same JSON custom formatting in all SharePoint list views for a list and this list has a lot of views. You would need to do it one by one in all views, or you could use PowerShell to script it. But not all the times you are able install PowerShell in your work computer. That’s when Power Automate comes handy, we can create a button Flow to run this action for us. The same idea can even be...

Read More

Runtime error when running tests: TypeError: Cannot read properties of null (reading ‘errorMessage’)

How do you deal with Runtime error when running tests: TypeError: Cannot read properties of null (reading ‘errorMessage’) in your Power Apps Test Studio? Automated tests Automated testing in Power Apps can reduce the time to test your app dramatically. First of all the automated testing in Power Apps is still in preview. About 2 years ago I wrote a post about it, and as the automate testing depends on a preview feature...

Read More

Create an app using the new image import in Power Apps

Earlier this week a new feature was released in preview. Take any image of a form and turn it into an app. All using the standard out of the box Power Apps editing experience. Create an image I’ve seen a few people testing this new feature with nice looking images. But I’m not good at drawing, so I used paint.net and my finger to drop an interesting form. Ok, nothing complicated here. As you can see my boxes are far from...

Read More
SharePoint lists custom View and Edit Buttons using JSON Formatting
May19

SharePoint lists custom View and Edit Buttons using JSON Formatting

If you need to add custom buttons as below to open SharePoint Online forms from list items (with the same behaviour as if you opened them using the out-of-the-box options), you can add them easily by using list formatting JSON, as below: The main point here is to add a customRowAction element to a JSON template. This row action will allow you to call several list item out-of-the-box actions from the custom button/HTML element. For the...

Read More

3 steps to implementing a better date picker in Power Apps

One of the biggest annoyances of Canvas Apps in Power apps is the date picker. It just doesn’t feel right. Some improvements needed There are quite a few improvements that you might want to make to the date picker, that aren’t easily possible. Having to press the OK button after you selected a dateDisplay the last days from the previous month or the first days of the next monthBranding the date picker And so much more. In...

Read More
Power Apps: Patch data from the Office 365 Users connector to a SharePoint multi-user field without using collect
May14

Power Apps: Patch data from the Office 365 Users connector to a SharePoint multi-user field without using collect

Sometimes when building a Power Apps Canvas app we want to use the Patch function instead of Forms to update items in SharePoint for several reasons, such as to have fewer controls in the screen, or to have more control over how the data is updated. For some complex fields, it can be trickier, as there will be more data manipulation needed and the format varies per field type. Especially when you are updating data using a data source...

Read More
How we do Construction Project Planning with help of Primavera P6 – YouTube
May09

How we do Construction Project Planning with help of Primavera P6 – YouTube

How we do Construction Project Planning with help of Primavera P6 Most Trusted Oracle Primavera Project Planning Management & Consultant in India. Wiznic World provides an extensive training in latest version of Primavera in PPM and EPPM as well. We are specialized in Oracle Primavera Project Management software with an expertise in provision of certified Oracle Primavera Training and Consultation. Our consultants are Oracle...

Read More
Glossary View formatting: JSON Template including Related Link
Apr30

Glossary View formatting: JSON Template including Related Link

A few people who used my previous sample/post on building a Glossary page using list formatting and connected webparts have asked for another version of the Glossary formatter with the feature of adding a related link. This post is to explain the changes made to the earlier template. New Column Add a new column with type ‘Hyperlink or Picture’ , with Hyperlink selected to the list. The internal name should be RelatedLink...

Read More
Filtering SharePoint lookup fields in Power Apps combo boxes by more than one related field
Apr30

Filtering SharePoint lookup fields in Power Apps combo boxes by more than one related field

When we use a SharePoint lookup field in Power Apps forms, the default filter for the combo box control that is created automatically when adding a lookup field to a form will filter items only based on the primary lookup value. Sometimes it can be useful to search on more list fields, especially when we create only the custom form using Power Apps and the lookup field has projected fields configured for the list and those values are...

Read More

Power Automate Flow run failed: Connection not configured for this service

Today I was battling with the Connection not configured for this service error. Background Iv’e got an app in Power Apps that manages documents. And the different levels of access to the documents I’m controlling using AD groups. One of my flows is run while the app is starting, and this flow will get the groups that the logged in user is part of. Iv’e got 3 versions of the app. One app in a Development environment,...

Read More
Power Automate: Relabeling JSON properties so they show up with different names in the Dynamic Content pane
Apr18

Power Automate: Relabeling JSON properties so they show up with different names in the Dynamic Content pane

Normally when we want to parse JSON content from an API in Power Automate, we use sample data and create the JSON schema to parse it using the option ‘Generate from sample’ : This speeds up the process, however if we have a case where we have separate children properties with the same names, it’s hard to know what is the exact property when accessing it from the Dynamic Content pane, unless you add them and hover...

Read More

Open Word documents in the desktop app from Power Apps

When you open Word documents from Power Apps you might have noticed that Word Online is used, but can we open documents in the Word Desktop app instead? Displaying Word documents In my app I have created a gallery that displays the icons and the name of the documents. Now there is a property available ThisItem.’Link to item’ to open a document. And Using the Launch function. We can open the document....

Read More

Introducing Portal Apps in Power Apps

Power Apps has three types of apps. One of them is the Portal app. In this post a how to get started with these websites that present data from Dataverse. First steps to building a Portal app The first steps to take are to decide what you want to present to which users. Or maybe we should even identify who these users are. There is quite a bit more to it all, but I will not focus on that in this post. Once we know what we want we can...

Read More

NEVER give your SharePoint fields the displayname of Value!

After an hour of banging my head against a brick wall when my Patch command failed I found the issue with a field named Value. Value It is not uncommon to call a field Value inn SharePoint. For example when you want to keep track of the Value of products you might think that Value is a good name. But it is not if you use Power Apps in combination with SharePoint. The word Value is a reserved word in Power Apps as you might have found...

Read More
Showing selected SharePoint form fields as read-only using List Formatting
Mar09

Showing selected SharePoint form fields as read-only using List Formatting

With the setValue action on SharePoint/Microsoft Lists JSON formatting, people from the community are creating several solutions or use cases, including myself in the two samples: Quick Approvals and Like/Dislike. The setValue action expands the possibilities of what we can do using list formatting, however, we need to bear in mind that, people are able to easily bypass the rules we implement if they either open the list item from the...

Read More

Collect flow runs of your failed child flows

When you use child flows, you might need to collect the flow runs of your failed child flows to identify any issues. In this post some error handling tips. Introduction into error handling We all know (or should know) how to do basic error handling in flows. And then a while back I also wrote about error handling in child flows. And I’ve explained that the following expression can give you the url to your flow run:...

Read More

Cancel Flow Run instead of Terminate in the middle of an apply to each in Power Automate

Have you tried using terminate in the middle of an apply to each? Did you get The operation terminate cannot be used inside a for each? Terminate The terminate action is so often misused. As I mentioned a while back the terminate action should really not be used. But if you are inside an apply to each processing 1000s of records then cancelling out might be something that you want to do. Cancel flow runs There is now an option to...

Read More

Copy SharePoint files from one tenant to another using Power Automate

Have you ever tried copying files from one tenant to another using Power Automate? Create a file in another tenant Well, the copy file action isn’t going to work in this case. So we will need an alternative When you try to connect into another tenant using Power Automate you migth ghetting error message like the one below: We are unable to find the site address. Please try selecting a site address from the dropdown So if the...

Read More

Create vibrating icons in Power Apps

Last week I got a strange question about how to make vibrating icons. So this post is to show you how to make icons vibrate so that you can point them in the right direction. Icons in Power Apps Icons have X and Y locations to make my icon vibrate. In this post I will adjust the X only but of course if you wanted to vibrate your icons by adjusting the Y then that would be fairly similar. I’m creating an app that has the...

Read More

Create a custom connector in the Power Platform – The WordPress example

Have you tried to create a custom connector in the Power Platform? As I was getting annoyed with the limitations of the existing WordPress connector here a full example. Step 1 – Find an API for your connector In my case I found that the existing connector for WordPress was just not good enough. Just a few actions that would give me hardly anything, didn’t do the trick for me. I quite quickly ended up on the REST API...

Read More
Hiding a SharePoint list from the site contents using Power Automate
Jan30

Hiding a SharePoint list from the site contents using Power Automate

Sometimes when building any solution based on SharePoint we need to hide a list from the site contents, for several reasons. The list can be creted to be used only by an automated solution and not to be updated or accessed by users. Even if we restrict permissions to read-only in the list, this can cause some confusion in users. Using SharePoint Designer we can mark a list as hidden from the site contents easily, and the same can also...

Read More

Compare two arrays, tables or lists a lot faster in Power Automate

When you want to compare two arrays, lists or tables in Power Automate and you might end up with a very slow flow. In this post the speedy solution. Two arrays I’m going to create two arrays in compose actions. But most likely you would have a list in SharePoint or a table in Dataverse or maybe data coming from a completely different data source. One important thing to notice is that the two arrays have a different structure....

Read More
Create folders on SharePoint Document Library from CSV
Jan23

Create folders on SharePoint Document Library from CSV

Photo by Maarten van den Heuvel on Unsplash There are a few options to achieve this result, you can do a PNP template, create a folder individually and that onwards, and there is a command that will create all the folders if you respect some logic which I will use here. I recommend you update your PNP PowerShell to make sure you got the same cmdlets used by the script. We will… Continue Reading David Ramalho’s Article on...

Read More

Handle unmanaged changes made to tables in the default solution in the Power Platform.

The default solution in the Power Platform is an unmanaged solution even in production. How do you handle unmanaged changes in the default solution that are edited manually? Unmanaged layers Deployment of apps, flows and tables should be done through solution packages. And you will find that as you deploy the solutions to production environments as managed solutions after you have developed them in a development environment as an...

Read More

Disable editing of your production apps and flows in the Power Platform

So often people edit apps and flows in production environments just to make them work. In this post I will look at why you shouldn’t and how to disable editing. Managed vs unmanaged solutions Within the Power Platform we have managed and unmanaged solutions. And you migth already know that managed solutions stop you from making modifications to some things in solutions, however deploying managed solutions doesn’t stop...

Read More

Comparing collections, table variables and data sources in Power Apps

In Power Apps you can use data sources directly or you could use collections or you could use variables. But what is the difference? Performance and behaviour In my example app I’m reading data from a SharePoint list and display this in three galleries. Within the app startup I’m setting a variable and a collection to the content presented by the connection to my SharePoint list. The variable and the collection are set...

Read More