Call authenticated external APIs using JavaScript from Power Pages
If you need to call external APIs using JavaScript from Power Pages, you may want to secure the calls to avoid exposing information or application hacking, as all the calls are made from client side. Power Pages sites can have OAuth 2.0 implicit grant flow enabled, so you can obtain an authentication token that has your Portal as the issuer, and you can use this token to do authenticated calls to external APIs. This post is a quick...
Using SharePoint list formatting and Power Automate to create linked items (via LookUp field) in a related list
Recently I was asked by a community member how to create a linked issue item (via LookUp field) using SharePoint list formatting. Via pure list formatting, it’s not possible to implement such functionality. But we can use List Formatting to create a button that triggers a Power Automate flow and this flow creates a linked issue as below: Check out how to implement this functionality in this post. Create an Issues list Create a...
Using the HTTP with Azure AD connector in Power Automate to create Planner Plans and add them as Teams tabs
Some people have reported to me that the beloved Send an HTTP request (V1) under Office 365 groups that we used to easily call Microsoft Graph is not available anymore when creating new flows. It turns out it has recently been deprecated, as stated by Microsoft, and we are recommended to use V2 instead: Unfortunately, the V2 action only supports the /groups endpoint and will not allow us to create planner plans. The alternative At the...
Create an Issue Tracker App using Power Apps Copilot (Preview)
Recently I tried out the Power Apps Copilot, which is still in Preview but even though not yet perfect, had actually quite interesting results. I used it to create a basic Issue Tracker app. Here are my first impressions on this post. How can I use Copilot? Currently Copilot is available only for Power Platform environments hosted in the United States. You can try it out even with a Developer environment. Just make sure that when you...
Issue solved: Canvas Apps PDF function – ‘PDF Creation Failed’ when using a gallery and checking conditions before calling the PDF function
Recently a reader reported an issue happening while using the PDF export functionality in Canvas Apps: I have an application with 2 galleries. The first one is populated with items that are users from a group, and the other is a collection that is populated with users from first table. Items with users from first gallery are “moved” to a collection and then, displayed to the secondary gallery. Like in your example, I put a button that...
Filtering Dataverse data by the current user in Cards for Power Apps
While playing around cards for Power Apps, I noted that the User Power Fx function that is used in Canvas Apps to detect the current user and get some information about it is not supported. After some investigation, I found that Cards use a new object called Viewer instead. How to use the Viewer Object The viewer object has 3 properties that potentially we could use to filter data by the Current User : name: it’s the user...
Sort an object array by numeric values that are stored as string using Power Automate
Recently I got a question in a previous post about the sort expression in Power Automate: I am attempting to use this expression in a compose box to sort by a numeric ascending value, but it is sorting that value as if it were a word and not a number. How would I amend this expression to sort the array by a number value that is apparently stored as a text string? Let’s have a look at the issue. If we have an array of objects as...
Opening the New form from another list using SharePoint list formatting
If you want to open the new form in another list using SharePoint Lists JSON formatting, it is pretty straightforward. All you need to do is to use the href property in a link object inside of your custom HTML generated by list formatting, and point it to the relative path of the new item form of the list you want to open, for example: /sites/<your site>/Lists/<your list>/NewForm.aspx Imagine you have an issues list in...
Using Power Automate to send cards built with Cards for Power Apps in Teams
If you want to send fancier notifications to Teams and struggle with Adaptive Cards, you can now use (in preview) Cards for Power Apps to generate your cards and send them in Teams chats. Cards for Power Apps provides a straightforward experience to create Adaptive Cards that can easily be used on Teams chats. In this post, we’ll see an example of how you can send use Power Automate to send a Power Apps card in Teams based on...
My top Power Platform 2023 release wave 2 plan features
The Power Platform 2023 release wave 2 plan was recently released, and as always we get to know what are the upcoming features and updates to the platform. Check out some of the announcements that were my favourites in this post. Use Copilot to build and edit apps in the Power Apps studio New Enhanced copilot capabilities to help build apps with natural language input and run tasks like adding screens, controls, and modifying...
LookUp column with a custom icon using SharePoint list formatting
I recently got question from a follower on LinkedIn, which I thoght that the answer can be useful for more people: I am struggling with formatting a SharePoint list lookup column. I want to make it show an icon but when I click it, it should open the lookup column value on that other list (normal lookup hyperlink behavior). I have achieved this before with text fields but never with Lookups. Any help would be appreciated! How to use...
Handling variables in SharePoint custom forms built with Power Apps
It’s possible to create custom forms for SharePoint lists/libraries using Power Apps, directly from the list command bar by using the option Integrate/Power Apps/Customize the form: This allows you to create a custom form using all features that a Canvas app offers. While you can keep all the out-of-the-box SharePoint list view native features, such as sorting, filtering, grouping & using JSON formatting, you will be able to...
Customize the SharePoint command bar icons and titles with JSON formatting
Previously I posted about hiding buttons in a SharePoint list using JSON formatting using the command bar customization. The same customization features can be used to edit the buttons icons and titles, for example, below we have a custom bar that replaced some of the native buttons icons and text. By adding values to the ‘text‘ and ‘iconName‘ properties we can accomplish this. For example, if we apply the...
Customize the SharePoint command bar icons and titles with JSON formatting
Previously I posted about hiding buttons in a SharePoint list using JSON formatting using the command bar customization. The same customization features can be used to edit the buttons icons and titles, for example, below we have a custom bar that replaced some of the native buttons icons and text. By adding values to the ‘text‘ and ‘iconName‘ properties we can accomplish this. For example, if we apply the...
Customize the SharePoint command bar icons and titles with JSON formatting
Previously I posted about hiding buttons in a SharePoint list using JSON formatting using the command bar customization. The same customization features can be used to edit the buttons icons and titles, for example, below we have a custom bar that replaced some of the native buttons icons and text. By adding values to the ‘text‘ and ‘iconName‘ properties we can accomplish this. For example, if we apply the...
Customize the SharePoint command bar icons and titles with JSON formatting
Previously I posted about hiding buttons in a SharePoint list using JSON formatting using the command bar customization. The same customization features can be used to edit the buttons icons and titles, for example, below we have a custom bar that replaced some of the native buttons icons and text. By adding values to the ‘text‘ and ‘iconName‘ properties we can accomplish this. For example, if we apply the...
Customize the SharePoint command bar icons and titles with JSON formatting
Previously I posted about hiding buttons in a SharePoint list using JSON formatting using the command bar customization. The same customization features can be used to edit the buttons icons and titles, for example, below we have a custom bar that replaced some of the native buttons icons and text. By adding values to the ‘text‘ and ‘iconName‘ properties we can accomplish this. For example, if we apply the...
Customize the SharePoint command bar icons and titles with JSON formatting
Previously I posted about hiding buttons in a SharePoint list using JSON formatting using the command bar customization. The same customization features can be used to edit the buttons icons and titles, for example, below we have a custom bar that replaced some of the native buttons icons and text. By adding values to the ‘text‘ and ‘iconName‘ properties we can accomplish this. For example, if we apply the...
Customize the SharePoint command bar icons and titles with JSON formatting
Previously I posted about hiding buttons in a SharePoint list using JSON formatting using the command bar customization. The same customization features can be used to edit the buttons icons and titles, for example, below we have a custom bar that replaced some of the native buttons icons and text. By adding values to the ‘text‘ and ‘iconName‘ properties we can accomplish this. For example, if we apply the...
Customize the SharePoint command bar icons and titles with JSON formatting
Previously I posted about hiding buttons in a SharePoint list using JSON formatting using the command bar customization. The same customization features can be used to edit the buttons icons and titles, for example, below we have a custom bar that replaced some of the native buttons icons and text. By adding values to the ‘text‘ and ‘iconName‘ properties we can accomplish this. For example, if we apply the...
Customize the SharePoint command bar icons and titles with JSON formatting
Previously I posted about hiding buttons in a SharePoint list using JSON formatting using the command bar customization. The same customization features can be used to edit the buttons icons and titles, for example, below we have a custom bar that replaced some of the native buttons icons and text. By adding values to the ‘text‘ and ‘iconName‘ properties we can accomplish this. For example, if we apply the...
Customize the SharePoint command bar icons and titles with JSON formatting
Previously I posted about hiding buttons in a SharePoint list using JSON formatting using the command bar customization. The same customization features can be used to edit the buttons icons and titles, for example, below we have a custom bar that replaced some of the native buttons icons and text. By adding values to the ‘text‘ and ‘iconName‘ properties we can accomplish this. For example, if we apply the...
Customize the SharePoint command bar icons and titles with JSON formatting
Previously I posted about hiding buttons in a SharePoint list using JSON formatting using the command bar customization. The same customization features can be used to edit the buttons icons and titles, for example, below we have a custom bar that replaced some of the native buttons icons and text. By adding values to the ‘text‘ and ‘iconName‘ properties we can accomplish this. For example, if we apply the...
Customize the SharePoint command bar icons and titles with JSON formatting
Previously I posted about hiding buttons in a SharePoint list using JSON formatting using the command bar customization. The same customization features can be used to edit the buttons icons and titles, for example, below we have a custom bar that replaced some of the native buttons icons and text. By adding values to the ‘text‘ and ‘iconName‘ properties we can accomplish this. For example, if we apply the...
Customize the SharePoint command bar icons and titles with JSON formatting
Previously I posted about hiding buttons in a SharePoint list using JSON formatting using the command bar customization. The same customization features can be used to edit the buttons icons and titles, for example, below we have a custom bar that replaced some of the native buttons icons and text. By adding values to the ‘text‘ and ‘iconName‘ properties we can accomplish this. For example, if we apply the...
Customize the SharePoint command bar icons and titles with JSON formatting
Previously I posted about hiding buttons in a SharePoint list using JSON formatting using the command bar customization. The same customization features can be used to edit the buttons icons and titles, for example, below we have a custom bar that replaced some of the native buttons icons and text. By adding values to the ‘text‘ and ‘iconName‘ properties we can accomplish this. For example, if we apply the...
Customize the SharePoint command bar icons and titles with JSON formatting
Previously I posted about hiding buttons in a SharePoint list using JSON formatting using the command bar customization. The same customization features can be used to edit the buttons icons and titles, for example, below we have a custom bar that replaced some of the native buttons icons and text. By adding values to the ‘text‘ and ‘iconName‘ properties we can accomplish this. For example, if we apply the...
Customize the SharePoint command bar icons and titles with JSON formatting
Previously I posted about hiding buttons in a SharePoint list using JSON formatting using the command bar customization. The same customization features can be used to edit the buttons icons and titles, for example, below we have a custom bar that replaced some of the native buttons icons and text. By adding values to the ‘text‘ and ‘iconName‘ properties we can accomplish this. For example, if we apply the...
Customize the SharePoint command bar icons and titles with JSON formatting
Previously I posted about hiding buttons in a SharePoint list using JSON formatting using the command bar customization. The same customization features can be used to edit the buttons icons and titles, for example, below we have a custom bar that replaced some of the native buttons icons and text. By adding values to the ‘text‘ and ‘iconName‘ properties we can accomplish this. For example, if we apply the...
Customize the SharePoint command bar icons and titles with JSON formatting
Previously I posted about hiding buttons in a SharePoint list using JSON formatting using the command bar customization. The same customization features can be used to edit the buttons icons and titles, for example, below we have a custom bar that replaced some of the native buttons icons and text. By adding values to the ‘text‘ and ‘iconName‘ properties we can accomplish this. For example, if we apply the...
Customize the SharePoint command bar icons and titles with JSON formatting
Previously I posted about hiding buttons in a SharePoint list using JSON formatting using the command bar customization. The same customization features can be used to edit the buttons icons and titles, for example, below we have a custom bar that replaced some of the native buttons icons and text. By adding values to the ‘text‘ and ‘iconName‘ properties we can accomplish this. For example, if we apply the...
Customize the SharePoint command bar icons and titles with JSON formatting
Previously I posted about hiding buttons in a SharePoint list using JSON formatting using the command bar customization. The same customization features can be used to edit the buttons icons and titles, for example, below we have a custom bar that replaced some of the native buttons icons and text. By adding values to the ‘text‘ and ‘iconName‘ properties we can accomplish this. For example, if we apply the...
Customize the SharePoint command bar icons and titles with JSON formatting
Previously I posted about hiding buttons in a SharePoint list using JSON formatting using the command bar customization. The same customization features can be used to edit the buttons icons and titles, for example, below we have a custom bar that replaced some of the native buttons icons and text. By adding values to the ‘text‘ and ‘iconName‘ properties we can accomplish this. For example, if we apply the...
Customize the SharePoint command bar icons and titles with JSON formatting
Previously I posted about hiding buttons in a SharePoint list using JSON formatting using the command bar customization. The same customization features can be used to edit the buttons icons and titles, for example, below we have a custom bar that replaced some of the native buttons icons and text. By adding values to the ‘text‘ and ‘iconName‘ properties we can accomplish this. For example, if we apply the...
Customize the SharePoint command bar icons and titles with JSON formatting
Previously I posted about hiding buttons in a SharePoint list using JSON formatting using the command bar customization. The same customization features can be used to edit the buttons icons and titles, for example, below we have a custom bar that replaced some of the native buttons icons and text. By adding values to the ‘text‘ and ‘iconName‘ properties we can accomplish this. For example, if we apply the...
Customize the SharePoint command bar icons and titles with JSON formatting
Previously I posted about hiding buttons in a SharePoint list using JSON formatting using the command bar customization. The same customization features can be used to edit the buttons icons and titles, for example, below we have a custom bar that replaced some of the native buttons icons and text. By adding values to the ‘text‘ and ‘iconName‘ properties we can accomplish this. For example, if we apply the...
Customize the SharePoint command bar icons and titles with JSON formatting
Previously I posted about hiding buttons in a SharePoint list using JSON formatting using the command bar customization. The same customization features can be used to edit the buttons icons and titles, for example, below we have a custom bar that replaced some of the native buttons icons and text. By adding values to the ‘text‘ and ‘iconName‘ properties we can accomplish this. For example, if we apply the...
Customize the SharePoint command bar icons and titles with JSON formatting
Previously I posted about hiding buttons in a SharePoint list using JSON formatting using the command bar customization. The same customization features can be used to edit the buttons icons and titles, for example, below we have a custom bar that replaced some of the native buttons icons and text. By adding values to the ‘text‘ and ‘iconName‘ properties we can accomplish this. For example, if we apply the...
Customize the SharePoint command bar icons and titles with JSON formatting
Previously I posted about hiding buttons in a SharePoint list using JSON formatting using the command bar customization. The same customization features can be used to edit the buttons icons and titles, for example, below we have a custom bar that replaced some of the native buttons icons and text. By adding values to the ‘text‘ and ‘iconName‘ properties we can accomplish this. For example, if we apply the...
Customize the SharePoint command bar icons and titles with JSON formatting
Previously I posted about hiding buttons in a SharePoint list using JSON formatting using the command bar customization. The same customization features can be used to edit the buttons icons and titles, for example, below we have a custom bar that replaced some of the native buttons icons and text. By adding values to the ‘text‘ and ‘iconName‘ properties we can accomplish this. For example, if we apply the...
Customize the SharePoint command bar icons and titles with JSON formatting
Previously I posted about hiding buttons in a SharePoint list using JSON formatting using the command bar customization. The same customization features can be used to edit the buttons icons and titles, for example, below we have a custom bar that replaced some of the native buttons icons and text. By adding values to the ‘text‘ and ‘iconName‘ properties we can accomplish this. For example, if we apply the...
Customize the SharePoint command bar icons and titles with JSON formatting
Previously I posted about hiding buttons in a SharePoint list using JSON formatting using the command bar customization. The same customization features can be used to edit the buttons icons and titles, for example, below we have a custom bar that replaced some of the native buttons icons and text. By adding values to the ‘text‘ and ‘iconName‘ properties we can accomplish this. For example, if we apply the...
Customize the SharePoint command bar icons and titles with JSON formatting
Previously I posted about hiding buttons in a SharePoint list using JSON formatting using the command bar customization. The same customization features can be used to edit the buttons icons and titles, for example, below we have a custom bar that replaced some of the native buttons icons and text. By adding values to the ‘text‘ and ‘iconName‘ properties we can accomplish this. For example, if we apply the...
Microsoft Forms: Hiding the ‘Untitled Form’ label in forms without a title
If we want to create custom headers for Microsoft Forms, as we don’t have many customisation options, an alternative way would be to create a custom image. But if we want to add the form title to the image, and leave it as blank as below: Forms always will set the title as ‘Untitled Form’ when you save it, even if you add spaces to it: However, it turns out that if we add the ‘zero-width space character‘...
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...
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...
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,...
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...
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...
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...