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?
UPDATE: Microsoft has rolled out a fix and once again you should be able to apply row filters to your Dataverse flow triggers. I will leave this post here for posterity. The other day I deployed an update to a Power Automate flow from my development system to my production on a small project. This… Continue reading Power Automate “Fix the Trigger” Issue (and how to fix)
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
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
Anyone who has been working with Dynamics CRM/Dynamics 365 at some point likely tried the Report Wizard. The Report Wizard was introduced in Dynamics CRM v4.0 as a way to quickly create ad-hoc reports. A video version of this blog post can be found on the 365.Training YouTube channel. Reports created using the Report Wizard… Continue reading Secrets of the Dataverse: The Report Wizard
A little know feature of Dataverse is the ability to manage multiple currencies. This is one of the many standard features of Microsoft Dynamics 365 that is also available when building your own Power Apps based on Dataverse. A while back I posted a blog called Guide to Currencies in the Common Data Service (Note that… Continue reading Updating Currency Exchange Rates in Dataverse (including Dynamics 365)
I use the FetchXML Builder on my Power Platform almost on a daily basis. It saves me so much in building SSRS reports, it allows me to build powerful Power Apps portals web templates and it also helps me building Power Automate flow queries. What is FetchXML Builder? It is a tool that is part… Continue reading Do you use FetchXML Builder? Please consider helping a friend out.
Sometimes even the most simple requests can balloon in extra configuration to meet the client’s vision. One of the most common uses of a Power Apps portal is to collect some information using a form. Adding a form component to a portal page is a very simple exercise. You create the model-driven form in the… Continue reading Inject content into Power Apps portals form components
Despite all the cool stuff you can do with the Power Platform, one of my most popular blog posts is Set Up Your Workstation to Create SQL Server Reporting Services Reports for Dynamics 365. The post was likely popular because there were different components in the setup process and Microsoft never did a great job… Continue reading Set Up Your Workstation to Create SSRS Reports for Dataverse, Model-Driven Power Apps and Dynamics 365
If you work with building Power Apps portals, as you make updates to pages, assign users to Web Roles or make any other changes, you want to see these changes immediately on the portal. You are likely very much aware of the Portal studio Browse Website function or the Clear Cache button available in the… Continue reading Using the Power Apps portals WebAPI to Clear the Portal Cache