11/7/2019 1:49:00 PM
Rollup fields are a great feature of the PowerPlatform. Rollup fields are used to aggregate values of related records to give the user insights into data in the record relationships. They can be used to calculate the total amount of an order by aggregating the order line amounts using the SUM() function. Another common scenario is using the COUNT() function to count number of related records. This can also be done using hierachical relationships, ie. aggregate values from related records and their related records and their related records ...
You can imagine how much work is done behind the scenes in order to achieve the desired goal based on the simple configuration. It would require a lot of work to implement this functionality yourself.
However, as with most great things in life, there is a catch.
Rollup fields are only calculated every 12 hours via a recurring system job. The schedule of the job can be changed but the frequency cannot.
Users can manually force a recalculation of a Rollup field by clicking the Recalculate button below the rollup field.
Click through to learn how to create a Custom Connector to recalculate rollup fields on the fly
10/8/2019 8:59:00 PM
Here is an example of a PowerApps custom control build using Azure Maps to generate interactive maps of your data points.
Azure Maps is a service that allows for integration into custom applications. It allows you to add geospatial capabilities such as maps, search, routing, and traffic to your application.
For the scenario in this post I used Azure Maps to identify locations of traffic cameras in Copenhagen, Denmark. Red cameras illustrate that there is an anomaly with the camera feed. When zoomed out the pins are clustered, a red outline indicates the cluster contains at least one camera with an anomaly.
Click through for video and source code
10/7/2019 11:00:00 PM
Had a conversation with colleagues today about the value propersition of the PowerPlatform from an app developer perspective.
You get a boat load of features and functionalities out of the box that you would otherwise have to build and manage your self.
On top of that you also get a myriad of ways to integrate with other systems applications. And DevOps tools to support your agile develoment methodology. And a global and helpful community
Read on for the list
10/6/2019 10:30:00 PM
Azure Application Insights Custom Events allow you to track events in your Canvas app. A Custom Event can be anything that happen in you PowerApp such as 'order submitted', time registration deleted', 'settings saved' or anything else you find meaningful to track.
Tracking these type of events gives you deep insights into how users use your app.
I wrote a blog post, Using Azure Application Insights to monitor your PowerApps Canvas App, about using a PCF control to implement Application Insights PageViews telemetry in your PowerApps Canvas app to track screens used. Using Custom Events can improve the feedback you get from your app and usage of it and make you better equipped to deliver value for your users.
Read this blog post to see how you can implement this cool feature in your own app.
10/2/2019 8:28:00 AM
Microsoft Flow has an RSS Feed action that can be used to retrieve news feeds from web site that implement RSS feeds.
On this blog I am aggregating feeds from a range of blog from the Dynamics 365 and PowerApps community. Find it here https://www.powerappsguy.com/news
The news aggregator also serves up a RSS feed that can be used to retrieve a feed of news from the community.
In the below example I will show how you can setup a simple Microsoft Flow to receive notifications when new blog posts are published.
9/25/2019 3:57:00 AM
The PowerPlatform offers monitoring of your apps on a high level. The telemetry gathered includes Performance, Usage and Errors aggregated on the environment level.
As of now, there is no official way to get detailed telemetry at the app level.
I decided to give it a shot to see if I could create a PCF control that could send telemetry to Azure Application Insights.
Here is my initial attempt. It supports tracking of Page Views i.e. Screen Views which includes screens views, duration, user information, session information, geographic information and other telemetry.
It's a custom PowerApps control for Canvas Apps. It might be useful for Model-Driven apps also, you let me know, ok?
7/25/2019 11:00:00 AM
If you are running your portal to host your blog like I am then you might want to get rid of some of the login options on the sign in page.
In my case, the only option for sign in that I want is Azure AD.
The available options on the sign in page are:
- Local SignIn - this is using credentials stored in Common Data Service / CDS on a contact record
- Register - this allows users to register a new user account (contact record) in CDS
- Redeem invitation - this allows users to register using an invitation code generated in CDS and usually sent to user via email.
- External SignIn - this options use Azure AD credentials for signing in to the portal.
7/23/2019 10:00:00 PM
The capability of creating Portals have arrived to the already powerful PowerApps platform! The Portal feature of PowerApps allows you to create a web portal based on data in Common Data Service or CDS. It allows access for anonymous users so can be used for any external facing scenario.
It’s still in preview though so not recommended for production scenarios.