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‘ to the form title, it is preserved: To add this character, you can simply copy it using the button below, and paste it into your Form title: Copy And that’s it! Important to remember that ..read more

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 WebPart adds extra features, such as dynamic resizing, theme awareness, and dynamic data detection. Configuring theme variables in the Canvas App / Preparing it ..read more

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 buttons as below: Items to hide/JSON content Using list formatting, there is an option to hide an out-of-the-box SharePoint button from the command bar in a view (fo ..read more

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, instead of tweaking JSON content or building external applications or Power Automate flows to parse the data.   By now only Microsoft Dataverse is availa ..read more

Microsoft Ignite 2022 brought several amazing announcements across all the Microsoft cloud platform. If you interested in updates related to Microsoft 365 collaboration tools (SharePoint/Teams/Viva & related) and the Power Platform and want to know more details, or in case you missed any updates, here is a curated list of posts from Microsoft official blogs & sites released during Ignite with most of the relevant news: SharePoint Microsoft Lists announcements at Ignite 2022 Introducing Microsoft Syntex: Context AI in the flow of work What’s new in Security and Management in SharePoint ..read more

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 group members (an action that cannot be done using the standard Microsoft 365 Groups action): Why call Graph if we have Office 365 products connectors and actions ..read more

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 of galleries/containers in a PDF, so we are not limited to only what is displayed in the screen. The text in the PDF file exported using this function is also s ..read more

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: sort reverse How the sort expression work The sort expression accepts either an array with simple values or a collection of objects. If you pass a simple array to the expression, no parameter is needed. For example, if you have the following array variable with people’s names: [ "Michel", "Nick ..read more

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 delayed start, some variables might not have been populated when you try to access their values). Formula definitions work like constants, they need to be defined in the App.Formulas pro ..read more

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 setup structure change later. Find your Team ID (Microsoft 365 Group ID) Find ID of the Group/Team (easily found under Groups in the Azure portal) you want to cr ..read more