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

Ambiguity in Power Apps

Recently I was asked about issues related to ambiguity in Power Apps code. In this post I will look at how to avoid any ambiguity issues in Power Apps. Ambiguity First of all what is ambiguity? According to the dictionary, it is all about things not being clear as multiple explanations can be given to the same thing. Ok, that’s all great! But what does that have to do with Power Apps. Power Apps and Ambiguity I’m going to...

Read More

Set the task priority in Microsoft Planner using Power Automate

For quite a while I’ve been looking to set the task priority in Microsoft Planner when using Power Automate. The preview version of the Create a task actions can do this. Create a task action The Create a task action now has two versions, and the preview version allows you to set the priority to […] Continue Reading Pieter Veenstra’s Article on their blog Set the task priority in Microsoft Planner using Power...

Read More

Co-Authoring in Power Apps

Recently Microsoft added the option to use Co-Authoring as an experimental feature to Power Apps. What is Co-Authoring? You might already be familiar with Co-Authoring in Microsoft Teams. Co-Authoring in teams lets you edit a document while another person is editing the same document. With Power apps it is just the same. You can edit […] Continue Reading Pieter Veenstra’s Article on their blog Co-Authoring in Power Apps...

Read More

Control access with RecordInfo and DataSourceInfo in Power Apps

When you create apps, you might find that different users get different things to do. With RecordInfo and DataSourceInfo you can control elements in your app by using Dataverse permissions DataSourceInfo When you use a table in Dataverse that a user doesn’t have access to you might get these error messsages: You don’t have access to view this data. Server Response <Tablename> failed. The message is clear, the user...

Read More

Enable the new Power Automate pane feature

You might want to Enable the new Power Automate pane feature when you add a flow to your app and you have to find the right flow in a long list of flows. Enable Power Automate pane preview feature It can be a real pain to get the right flow in that long list. But not when you enable the new Power automate pane feature. All you need to do is enable the Enable Power Automate pane and restart your app And now there is an additional...

Read More

Loaddata, Savedata and Cleardata in Power Apps

Today I’m having a look at some of the preview features arriving in Power Apps. This post is about the new LoadData, savedata and cleardata in web players feature. SaveData, LoadData and Cleardata LoadData, savedata and cleardata have been around for a while, but up to now they were only available within the app player. […] Continue Reading Pieter Veenstra’s Article on their blog Loaddata, Savedata and Cleardata in...

Read More

Synchronize two data sources with Power Automate

Over the last few weeks I’ve been asked a number of times how to setup a flow to synchronize two data sources. In this post a pattern that can be … Read More Continue Reading Pieter Veenstra’s Article on their blog Synchronize two data sources with Power Automate Over the last few weeks I’ve been asked a number of times how to setup a flow to synchronize two data sources. In this post a pattern that can be...

Read More

3 Ways to avoid duplicate records in Power Apps

When you create items or records or rows in your data sources using Power Apps, you will often want to avoid duplicate records. In this post 3 ways to avoid … Read More Continue Reading Pieter Veenstra’s Article on their blog https://sharepains.com/2021/12/15/avoid-duplicate-records-in-power-apps/ Blog Syndicated with Pieter Veenstra’s Permission

Read More

Handling SharePoint file locks with Power Automate child flows

In 2019 I wrote a post about SharePoint file locks and how to handle these with a retry pattern. But there is an easier way when you use child flows. … Read More Continue Reading Pieter Veenstra’s Article on their blog Handling SharePoint file locks with Power Automate child flows In 2019 I wrote a post about SharePoint file locks and how to handle these with a retry pattern. But there is an easier way when you use child...

Read More

The must have features of an app in Power Apps using community connectors (well, on a Friday afternoon that is)

Every week there are new connectors added to Power Apps and Power Automate. This week I’m looking at two community connectors that were added recently by on of the Power … Read More Continue Reading Pieter Veenstra’s Article on their blog The must have features of an app in Power Apps using community connectors (well, on a Friday afternoon that is) Every week there are new connectors added to Power Apps and Power...

Read More

Become part of your presentation with Presenter Modes in Microsoft Teams

When you present in Microsoft Teams and you share your screen you might not be visible. Presenter modes make it easier to interact with your audience. Presenter modes When you … Read More Continue Reading Pieter Veenstra’s Article on their blog Become part of your presentation with Presenter Modes in Microsoft Teams When you present in Microsoft Teams and you share your screen you might not be visible. Presenter modes make...

Read More
Custom View Formatting on Microsoft Lists to show Announcements
Dec01

Custom View Formatting on Microsoft Lists to show Announcements

Announcements are a big part of a SharePoint landing page and there are a few options out there either using out-of-the-box webpart or you can build an SPFx webpart. A few days ago, I was looking for an example using List formatting and I couldn’t find it on the community repo. Therefore I decided to create this sample which should be available soon on the community Git Hub of List… Continue Reading David Ramalho’s Article...

Read More

Get the current environment of an app in Power Apps

Today I tried to display the current environment in a canvas app in Power Apps. This was slightly harder than expected. Power Platform connectors there are quite a few Power … Read More Continue Reading Pieter Veenstra’s Article on their blog Get the current environment of an app in Power Apps Today I tried to display the current environment in a canvas app in Power Apps. This was slightly harder than expected. there are...

Read More

Containers in responsive apps in Power Apps

When you develop responsive apps in containers become very important. In this post I’m trying to help with the common challenges. Horizontal vs Vertical containers A while back I wrote … Read More Continue Reading Pieter Veenstra’s Article on their blog Containers in responsive apps in Power Apps When you develop responsive apps in containers become very important. In this post I’m trying to help with the...

Read More
Who are Stripe OLT… – YouTube
Nov19

Who are Stripe OLT… – YouTube

Who are Stripe OLT… Want to know what the team think about working at Stripe OLT? Want to know what the team think about working at Stripe OLT? source

Read More

Create recursive flows in Power Automate

With the introduction of child flow, have you tried creating recursive flows? Recursive flows Before looking into how to implement recursive flows, please review my child flow error handling post. … Read More Continue Reading Pieter Veenstra’s Article on their blog Create recursive flows in Power Automate With the introduction of child flow, have you tried creating recursive flows? Before looking into how to implement...

Read More
How to enable your Microsoft Viva Connections Dashboard
Nov11

How to enable your Microsoft Viva Connections Dashboard

Microsoft Viva Connection enables the users to have quick access to data and information using Microsoft Teams and with that increase the communication across your company. As you can imagine Teams relies on SharePoint to provide such experience and in order to activate this functionality you need to set up a couple of settings in SharePoint. To do this you need to set up on your… Continue Reading David...

Read More

Error handling in child flows in Power Automate

In the past I’ve looked at error handling for flows and this resulted in the Try-Catch pattern. In this post I will focus on error handling in Child flows. Parent … Read More Continue Reading Pieter Veenstra’s Article on their blog https://sharepains.com/2021/11/10/error-handling-in-child-flows-power-automate/ Blog Syndicated with Pieter Veenstra’s Permission

Read More

The making of: A successful Microsoft Ignite table talk

A couple of months ago Anna Chu asked me to co-host a table talk at Microsoft Ignite about best practices within the Power Platform. The team Together with Karoliiona Kettukari … Read More Continue Reading Pieter Veenstra’s Article on their blog The making of: A successful Microsoft Ignite table talk A couple of months ago Anna Chu asked me to co-host a table talk at Microsoft Ignite about best practices within the Power...

Read More

Comments in Power Automate flows

As it is Microsoft Ignite week, new features are being added to all products. This post is all about comments in Power Automate Notes vs Comments We already had the … Read More Continue Reading Pieter Veenstra’s Article on their blog Comments in Power Automate flows As it is Microsoft Ignite week, new features are being added to all products. This post is all about comments in Power Automate We already had the option to...

Read More

SharePoint Site Scripts and Site Designs in Power Automate

When you look at SharePoint site provisioning solutions, you will quite quickly bump into Site Scripts and Site Designs. In this post some options on handling these in Power Automate … Read More Continue Reading Pieter Veenstra’s Article on their blog SharePoint Site Scripts and Site Designs in Power Automate When you look at SharePoint site provisioning solutions, you will quite quickly bump into Site Scripts and Site...

Read More