Use Dataverse virtual tables in Power Pages sites

A common question I have gotten over the years is if it is possible to build a Power Pages that can surface and interact with data that is stored in a different database than Microsoft Dataverse, such as Azure SQL or other databases. Using a different database for Power Pages was not only difficult, but… Continue reading Use Dataverse virtual tables in Power Pages sites

Using solutions to move Power Pages site configuration

Moving Power Pages (and Power Apps portals) site configuration from a one environment to another used to be a bit of a tedious process. While there were handy tools like the XrmToolBox portal records mover, Power Platform CLI, or the Configuration Data Migration tool, it was always an extra step to move website configuration. Now,… Continue reading Using solutions to move Power Pages site configuration

Using Content Snippets in Power Pages

One feature of Power Pages that doesn’t get a lot of attention is Content Snippets. What is a content snippet? Its really just a piece of text or HTML that you can inject into headers, footers, page copy, or in web templates. You can even include Liquid or JavaScript code in content snippets. A couple… Continue reading Using Content Snippets in Power Pages

Using calculated columns in Power Pages

Form and list components in Power Pages are based on model-driven Power App forms and views, which of course are connected natively to Microsoft Dataverse. While it’s very easy to create tables, columns (fields), forms, and views in the Power Pages data workspace, for new (and even established) makers, understanding how the overall data model… Continue reading Using calculated columns in Power Pages

Demystifying forms in Power Pages

One of the key features of Power Pages is to allow users to interact directly with information stored in Microsoft Dataverse. Makers can easily create web pages with list and form components to allow site visitors to be able to create, read, update or even delete Dataverse records. However, sometimes new users get a bit… Continue reading Demystifying forms in Power Pages

Microsoft Dataverse information in Power Pages – offline!

Before I dive into the details of this blog, you will notice that in 2022, I only published twice. My day job involves creating content for Microsoft Learn, but I also have a backlog of blog ideas that really don’t fit into Microsoft Learn, so hoping that in 2023 I hope to have a good… Continue reading Microsoft Dataverse information in Power Pages – offline!

What is a Progressive Web App?

Around 10 years ago, there was an famous ad campaign for a mobile phone company with the catch-phrase “There is an app for that”. The concept was that for many tasks, activities or even games that were traditionally paper or full computer based could now be expressed as “apps” that could be run on mobile… Continue reading What is a Progressive Web App?

Power Apps Portals – Did you remember to lock the door?

The internet lit up a bit yesterday as UpGuard posted an article on how Microsoft Power Apps default permissions “exposed millions”. The article can be found by clicking here. The Power Platform community is also responding, see excellent articles on this topic from Danish and George Is this something you should panic about? If you… Continue reading Power Apps Portals – Did you remember to lock the door?

Using Multi-table lookups (polymorphic relationships) in Microsoft Dataverse

A new feature landed in preview last week which is something that has been a big ask of Microsoft for many years, multi-table lookups, otherwise known as polymorphic relationships. What are polymorphic relationships and how can they help you? A polymorphic relationship lookup allows you to specify more than one type of Dataverse table to… Continue reading Using Multi-table lookups (polymorphic relationships) in Microsoft Dataverse

Power Apps portal WebAPI – creating a record with lookups

One of the features of Power Apps portals that I have been impatiently waiting for is the Power Apps portals WebAPI. This new feature recently became generally available, and it allows portal makers and developers to greatly extend their portal web applications without needing to resort to complex or costly workarounds. Even if you are… Continue reading Power Apps portal WebAPI – creating a record with lookups