When we use the Cloud Flows integration in Power Pages, we can use Web Roles to restrict what users can call the Flow or not. But sometimes only this is not enough and we might want to add more logic in the Flow to prevent certain actions. For instance, you can validate the Contact ID against Dataverse records to ensure the user has the right to execute certain actions. Check out how you can do it. Contact ID in the Trigger Every Power Pages user is mapped to a record in the Contact table in Dataverse. If we have a look at the properties that Power Automate provides us in the Power Pages trigg ..read more

Last week I demoed an improved solution of my previous blog post: Using JavaScript and Cloud Flows to download files from a SharePoint document library in Power Pages in the Microsoft 365 & Power Platform community (PnP) call. The Cloud flows are the same as on the previous post, but on the JavaScript side there were a few updates: Using jQuery instead of Vanilla Js Added more comments to the code Added option to preview PDF files on a new tab (be aware that you need to allow pop-ups in your browser for the site address for it to work) Source code The updated source code for the Power P ..read more

In my previous posts Creating and removing N:N relationship between Dataverse records using Javascript and Power Pages Web API I showed how we can leverage the Power Pages Web API to handle single N:N associate and disassociate requests for a custom N:N relationship between Accounts and Contacts, and also in the following post Generic JavaScript Functions to Associate and Disassociate Dataverse records using the Power Pages Web API, I brought revisited versions of functions to handle the Associate and Disassociate process for any table. In case we want to handle multiple requests, we need to d ..read more

In my previous post Creating and removing N:N relationship between Dataverse records using Javascript and Power Pages Web API I showed how we can leverage the Power Pages Web API to handle single N:N associate and disassociate requests for a custom N:N relationship between Accounts and Contacts. In case we want to extend that to be more generic to any N:N relationship we can leverage a custom function that can be used in multiple pages easily. Prerequisites All required fields (including the N:N relationship name) in the code must be enabled for the WebAPI for the Power Pages site where you w ..read more

Managing Dataverse N:N relationships between records using the Power Pages Web API can be trickier as there are few samples around and the syntax differs a little bit from handling N:N relationships using the Dataverse Web API. In this post I will show a quick code sample on how you can handle that, using a sample N:N custom relationship between Contacts and Accounts. Prerequisites All required fields (including the N:N relationship name) in the code must be enabled for the WebAPI for the Power Pages site where you wish to run the code creation via Web API The WebAPI Wrapper code must be adde ..read more

This post is based on a recent question that I got from a blog reader in a blog post related to List Formatting and setting field values: I am trying to add an action button to my Microsoft list. The reason for this is that I would like the trip date column to populate with the current date the button was pressed. Just to make it easier for the executives to confirm they have completed a work trip. Can this be done thru list and conditional formatting and json coding? We can use the customRowAction attribute with the setValue action type in list formatting to achieve this. Basically we need ..read more

Even though we can now use Virtual Tables to expose SharePoint lists in a Power Pages site, the same does not apply to SharePoint Document libraries. You can use the native SharePoint integration to display content that was set up in that way from the Model Driven Apps side, but you cannot expose a custom library in that way. For example, if you want to expose a random library with Document templates for users to download, there is no simple way by using out-of-the-box features. However, you can use the new Power Automate integration to leverage that, by creating a custom Page and manipulating ..read more

We know that in order to use OAuth2 implicit flow in Power Pages, we need to have a certificate in the proper format as specified by Microsoft here: Manage custom certificates As we can the Let’s Encrypt service to generate free SSL certificates, I was wondering if I could not use the same developing Power Pages integration POCs in my developer tenant. Those certificates actually meet the criteria but they are not immediately in PFX format. Straight away we can’t as they are not exposed as PFX files, but it’s not complex to run the conversion. Steps needed (or the ones I took to achieve this ..read more

Microsoft Ignite 2023 showcased many exciting announcements across the Microsoft cloud platform in the era of AI. At Ignite 2023, Microsoft focused on AI and its impact on industries. Most of the highlights involve the new features and capabilities of Microsoft Cloud stack involving Artificial Intelligence and Copilots, which aim to enhance productivity and bring new ways of work. Image generated by Microsoft Designer If you are interested in updates from Ignite 2023 related to Microsoft 365 collaboration tools and the Power Platform, here is a curated list of posts from Microsoft official blo ..read more

If you want to create a record with its child records in Power Pages, there is no way to do it using out of the box forms. But you can do it using JavaScript Power Pages Web API, and with a single Web API call. In this blog post we will use the example of creating an Account with 2 child Contacts in Power Pages. Prerequisites Enable both the Account and Contact tables for the WebAPI Enable the fields used in the WebAPI call for both tables (including the relationship field) Configure proper table permissions for both tables (so users can create items and associate contacts with accounts) Incl ..read more