Making a Canvas app become Teams & SharePoint  theme aware (with the help of the PnP Enhanced Power Apps WebPart)
Dec04

Making a Canvas app become Teams & SharePoint theme aware (with the help of the PnP Enhanced Power Apps WebPart)

By detecting the theme parameter that Teams passes to Power Apps canvas apps when added as Tabs or Personal apps, we are able to make them Teams theme aware, but the same does not happen when we add a Canvas app to SharePoint using the standard Power Apps WebPart. However, there is a free open-source sample in the Microsoft 365 PnP sp-dev-fx-webparts Repository (Enhanced Power Apps WebPart) that we can use to help achieving that. This...

Read More
Hiding the New and Upload buttons from a SharePoint document library using JSON list formatting
Nov19

Hiding the New and Upload buttons from a SharePoint document library using JSON list formatting

Recently I got a query about hiding the New and Upload buttons for a SharePoint library, because there was a need to allow users to browse documents using out-of-the-box SharePoint views in a library while still having permissions to upload files so that they could upload files using an SPFx WebPart or a Canvas App. This request can easily be achieved using list formatting, by adding customisations to the command bar to hide some...

Read More

Create multi user real time apps in Power Apps

When multiple users edit data and you want your app to show real time data, you will need a multi user real time app. It isn’t a good idea to reload all your data every time someone might have updated data. The data setup I’m going to use SharePoint as my data store within this post, however the pattern could be applied to any database, such as SQL or Dataverse. First of all I’m creating a list that will hold my data...

Read More

Sort by Title in your Highlighted Content web part in SharePoint

Yesterday I was asked about how to sort Documents in the Highlighted Content web part by the Title property. To sort by Title you will have to go through some extra steps. SharePoint Search web parts First I would like to take you through some history. In the year 2016, I wrote a blog post about making the Title field sortable in the classic SharePoint search web parts. And for the Highlighted content web part we have to roughly go...

Read More

Copy large files from SharePoint to Azure Blob Storage using Power Automate

When you try to copy large files from SharePoint to Azure Bob Storage with Power Automate, you will find that you have a few options. But quite a few of them fail straight away. In this post the solution. Failed attempts I’m going to include my failed attempts first. In my situation I would like to take a file in SharePoint, get its content and then upload it to Azure Blob Storage. Attempt 1 – Get file content failure I...

Read More

Sort an array by dates in Power Automate

When we use the Sort function to sort arrays in Power Automate, it is soo much easier than the 3 step approach that we had before. But there are a few potential issues when you really start to use this function. Sort Dates When we sort dates in Power Automate we really want to to work with dates like this: We have some dates generated by for example a get items action in SharePoint. Or anything else that generates the dates and all...

Read More
Build powerful Adaptive Card experiences for Teams using Cards for Power Apps
Oct25

Build powerful Adaptive Card experiences for Teams using Cards for Power Apps

Cards For Power Apps (Preview) is a new type of app in the Power Apps family, designed to be used as mini apps instead of full-fledged web pages or mobile apps as normally Canvas apps are used to build.  Cards are based on the same technology that powers Adaptive Cards.  As Cards for Power Apps support Power Fx, logic and data manipulation can be easily done with PowerFx and also with the help of Power Platform connectors,...

Read More

New! Format data by examples in Power Automate

This feature “Format data by examples” will kill one of my most popular posts! How to format dates using formatDateTime. Using the Format data by example Although this feature is easy to use, it is worth writing a quick blog post about this. You can find this new feature in the expression editor. It has even been given a blue icon to jump out at you. Just click on it and then you will see a pane sliding in where you can...

Read More

Named formulas in Power Apps using App.Formulas

Do you use the App onstart to set a lot of variables? And then do you repeat this same within other places of the app to keep things up to date? The new named formulas in App.Formula might be a better option. Enable Named Formulas To enable Named functions you can go to the Settings in your app. Then switch on the Named formula feature. Notice that this feature is still experimental, but it is a great feature to try out ( in non...

Read More
Ignite 2022: Curated list of posts from Microsoft related to Microsoft 365 and Power Platform
Oct15

Ignite 2022: Curated list of posts from Microsoft related to Microsoft 365 and Power Platform

Microsoft Ignite 2022 brought several amazing announcements across all the Microsoft cloud platform. Are you interested in updates related to Microsoft 365 collaboration tools (SharePoint/Teams/Viva & related) and the Power Platform, but missed any update or want to know more details? In case you missed any updates or are interested in more details, here is a curated list of posts from Microsoft official blogs & sites released...

Read More
Calling Graph API using a flow and manipulating the results from Power Apps using the ParseJSON function
Oct08

Calling Graph API using a flow and manipulating the results from Power Apps using the ParseJSON function

Recently I posted about using a generic flow to call the SharePoint Rest API from a canvas app and parse the results using the ParseJSON experimental function, in a way that we can almost simulate as if we could call the SharePoint Rest API from a canvas app. The same technique can be applied to call Microsoft Graph API, as in the example below where we retrieve the list of group members from a Microsoft 365 group, including nested...

Read More

Introduction to the PDF function in Power Apps

Have you ever wanted to create a PDF from your Power Apps Screens? Now you can using a the new PDF function in Power Apps Enabling the PDF Function To enable this new experimental feature all you have to do is look for the PDF function feature in the Experimental tab and enable it. Using the PDF function Now straight away you will be able to use the PDF function as shown below. <img loading=”lazy”...

Read More
Primavera Project Management Consultant, Planning & Training – YouTube
Oct07

Primavera Project Management Consultant, Planning & Training – YouTube

Primavera Project Management Consultant, Planning & Training 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

Do Power Platform updates come as a surprise?

How often does it happen that you are working in Power Automate or Power Apps and suddenly on of those new Power Platform Updates features appears. Released Versions It can be hard to keep up with all the changes within the Power Platform. There are so many releases and so many new features arriving all the time. You can find these releases using the following URL: Released Versions – Release Notes Power Platform Released...

Read More
Export a Power Apps gallery as PDF file using the new PDF function, and email it with the Outlook connector
Oct02

Export a Power Apps gallery as PDF file using the new PDF function, and email it with the Outlook connector

With the recently experimental PDF feature that is available from Power Apps authoring versions 3.22094.* we are now able to export screens, galleries and containers to PDF and obtain the output of this export as bytes, and use it on the PDF viewer or send it to a flow, so we can save it to SharePoint, OneDrive and etc. The advantage of this approach instead using the Print function to print screens is that we can get the full content...

Read More
New Sorting actions for arrays/tables In Power Automate: sort & reverse
Oct01

New Sorting actions for arrays/tables In Power Automate: sort & reverse

Until recently it was not possible to easily sort arrays or collections of objects in Power Automate using a single expression, either complex logic techniques or Office Scripts were required. But recently two new handy expressions became available in Power Automate that make it really simple to do: sortreverse How the sort expression work The sort expression accepts either an array with simple values or a collection of objects. If...

Read More

Use ParseJSON in PowerApps to retrieve data from Power Automate

Recently a new ParseJSON feature was added to Power Apps. ParseJSON is possibly one of the most complex functions available in Power Apps. in this post some help! ParseJSON Introduction Imagine that we have a flow that sends data back to a Power App using a text property in the Respond to a PowerApp or flow action. But rather than creating multiple fields we return everything as a single text property. Now the app will receive a text...

Read More
How to use Power Apps named formulas (experimental feature)
Sep22

How to use Power Apps named formulas (experimental feature)

Recently Microsoft announced a new experimental feature in Power Apps: Named formulas Named formulas in summary are, defined functions without parameters, that can be reused anywhere in a Canvas App. What are the advantages of using Named formulas instead of global variables (defined with ‘Set’)? The formula’s values are always available, there is no time dependency as it happens on App.OnStart (if you enabled...

Read More

1 step to update an item in an array in Power Automate

What do you do when you have an array of data in Power Automate and you want to update just one item? Generate an array In this example I will generate an array of numbers using the following expression: range(1,10) This will now generate the array when I run the flow. So how about updating item 7 to 17? I could imagine using Pieter’s method but there is an easier option. Just 10 minutes ago I was asked on the chat how I would...

Read More

Failed to load in Azure Synapse Workspace

After last week’s post about how to configure Azure Synapse Link to export data from Dataverse into SQL Server, today a post about some issues. How do you deal witht he failed to load messages that users might get when accessing the data. Failed to load When users try to access the data, they may get the failed to load message. The supporting details of the error may say something like Failed to load one or more resources due to...

Read More

Buckinghamshire & Northamptonshire Power Platform User Group launch

Have you been waiting for a new face to face Power Platform User Group in Buckinghamshire & Northamptonshire? First Power Platform User Group session Register now Our first evening will be on 28 September 7pm – 9 pm in the following location: Building 3, Royal Ordnance Depot, Weedon Bec, Northamptonshire, NN7 4PS, United Kingdom Will have the following amazing sessions to kick off this user group: Laura Graham-Brown –...

Read More
Creating a Planner Plan and adding it as a tab to the General channel of a Teams team using Power Automate & Microsoft Graph
Sep16

Creating a Planner Plan and adding it as a tab to the General channel of a Teams team using Power Automate & Microsoft Graph

Some time ago I blogged about using Power Automate to create Planner Plans and recently I got a query on that post about adding the created plan to the General channel of the related Team as a tab. The procedure to add a Planner plan as a tab using Graph is not documented by Microsoft, but by investigating manually added examples, I could figure out how to do it. Bear in mind this is not a documented procedure and may break if the tab...

Read More

Configure Dataverse exports using Azure Synapse Links for Azure SQL Databases

In this post I’m looking at the Azure SQL databases option that is part of the Azure Synapse link configuration. A bit of background Azure Synapse Links let you configure Dataverse exports to Azure. Quite often this results in a file structure in azure storage that holds csv files. These csv files are organised in such a way that the year (or month) of the records creation in Dataverse decide where your exported data will end...

Read More
Using the ParseJSON function and a generic flow to call any SharePoint Rest API endpoint and manipulate the results from Power Apps
Sep13

Using the ParseJSON function and a generic flow to call any SharePoint Rest API endpoint and manipulate the results from Power Apps

Even though there is a ‘Send an HTTP request to SharePoint’ action in Power Automate that allows us to call any SharePoint Rest API endpoint, there is no equivalent action for the same in Power Apps. We can leverage Power Automate Flows to help with any action that is exposed through the SharePoint Rest API, but as previously there was no easy way to parse JSON objects in Power Apps without a premium license, the process could be a...

Read More
Two approaches to replace all occurrences of a value in a String using SharePoint list formatting: replaceAll & split + join
Sep10

Two approaches to replace all occurrences of a value in a String using SharePoint list formatting: replaceAll & split + join

Until some time ago there was only a replace function in list formatting, which allowed us to replace only the first occurrence of a value in a string. Recently Microsoft released two new operators for list formatting: replaceAllsplit With the replaceAll we can easily replace with all occurrences of a value in a string as in the example below, where we replace client by customer: replaceAll has 3 parameters: field, original value,...

Read More

5 steps to implement word based search in Power Apps

A common requirement in Power Apps is to create a word based search on data in galleries. Step 1 – Basic search in Power Apps First of all I would like to have a look at some basic (not working so well) search on data in galleries. In my example here I’m using a SharePoint list as my data source, but there is no real difference between SharePoint and Dataverse or SQL in this case. Imagine I have an app as shown below with...

Read More
Folders-enabled SharePoint lists: Trigger a Flow only when Folders are modified VS only when Items (not folders) are modified
Sep03

Folders-enabled SharePoint lists: Trigger a Flow only when Folders are modified VS only when Items (not folders) are modified

For organisational purposes or even for having different permissions in a SharePoint list, without having to handle item-level permissions, we can leverage folders in a list by enabling folders creation under the list advanced settings. With folders in a list then we can break permissions in a folder instead of each item, and then grant access to a specific subset of list items in a SharePoint list. When we create Power Automate flows...

Read More
New ‘Send an HTTP request’ actions for Office 365 Groups, Outlook and Office 365 users in Power Automate
Aug24

New ‘Send an HTTP request’ actions for Office 365 Groups, Outlook and Office 365 users in Power Automate

Recently, the ‘Send an HTTP request’ action below the Office 365 groups connector in Power Automate went silently to GA. And we now have equivalent new actions in Preview below the Office 365 Users, Office 365 Groups, Office 365 Groups mail and Office 365 outlook connectors. Now each connector supports its related segments in Microsoft Graph, instead of a single connector supporting more operations previously (Office 365...

Read More

900th post on SharePains.com, it is a time to celebrate and win!

This is the 900th post on SharePains.com and I thought this would be a good moment to celebrate that milestone. Ok, it is not the 1000th post but 900 is still quite a lot. The 900th Post Quiz With posts about many of the Microsoft Technologies, SharePains has grown from just a few posts in the beginning to multiple posts per week in the recent years. SharePains has helped with user pains related to SharePoint, Power Platform, Azure,...

Read More

Resolved – Avoid variables in Apply To Each steps in Power Automate

Yesterday I was asked about how to avoid variables when you want an index number of the item processed by an apply to each step. Variables or Compose? The variables or compose question is quite an old question in the Power Automate world. The main issue with variables is that inside an apply to each variables lock the processing of items by the Apply to each. This disables the possibility to run the processing in parallel using the...

Read More

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