Living In Tech

Posts

Power Pages Site Component Tool

If you have worked with Power Pages using the Enhanced Data Model, you know the pain of manually adding all the site components to a Dataverse solution. It's tedious, error-prone, and frankly, there are a lot of components to track down. You need to add the site record, the site languages, and then every individual component — Web Pages, Web Templates, Content Snippets, Site Settings, Table Permissions, Basic Forms, Advanced Forms, and more. Miss one and your deployment won't work as expected. To solve this problem, we built an open source .NET console application called PowerPages.SolutionComponents.Console . This tool automates the entire process of discovering and adding all Power Pages site components to a Dataverse solution in one shot. What Does It Do? The tool connects directly to your Dataverse environment and does the following: Adds the Power Pages Site record to your solution. Finds and adds all related Power Page Site Languages. Finds...

Integrating HubSpot with Dynamics 365: Native Connector vs. Custom Azure Functions

If your marketing team lives in HubSpot and your sales team lives in Microsoft Dynamics 365, getting those two platforms to reliably share data is one of the most important integration decisions you'll make. There are two main paths to connect them: a native connector available directly in the HubSpot App Marketplace, or a custom-built integration using Azure Functions. Choosing the wrong one can mean months of frustration. This post walks through both options in detail so you can make the right call for your team. The Native HubSpot Connector The Microsoft Dynamics 365 integration is a first-party app built and maintained by HubSpot, available in the HubSpot App Marketplace and Microsoft AppSource. It's powered by HubSpot's Data Sync engine — part of Data Hub (formerly Operations Hub) — and supports bidirectional sync across 12 object types: Contacts ↔ Leads / Contacts Companies ↔ Accounts Deals ↔ Opportunities Products ↔ Bundles Meetings ↔ Appointments Task...

Lookup In Select of URL For Power Pages

While working on a Power Pages implementation I was consume the Power Pages API to get a Lookup table so I could show and hide information on the form using jQuery. One issue I was having is I couldn't get a lookup field to return even though I had it as a field in the site setting for the table and included it in the my select statement in the URL. I kept getting an `unexpected error occurred`. This issue is caused because lookup's are made up using 3 fields. 1) Formatted Value = The information you see in the lookup field (i.e. the record name) 2) Logical Name = The table the related record is a part of 3) Id = The id of the related record In the api there is a 4th field that is returned that is the Associated Navigation Property and it is the logical name of the lookup field. When setting up our select and even saying what columns can be returned in the API, we have to think how the OData endpoint will return the data to us. ...

Reusable Method To Get Record By Id

I have a handful of reusable code that I use when creating plugins or external process (i.e. Azure Functions) for working with DataVerse. The first one I am providing is Getting a Record By Id: 1: private static Entity GetFullRecord(string entityName, string primaryKey, Guid recordId, IOrganizationService service) 2: { 3: using (OrganizationServiceContext context = new OrganizationServiceContext(service)) 4: { 5: return (from e in context.CreateQuery(entityName) 6: where (Guid)e[primaryKey] == recordId 7: select e).Single(); 8: } 9: } entityName = The logical name of the entity primaryKey = The primary key field for the entity. If using late binding you can create this dynamically by doing: $"{target.LogicalName}id" recordId = Guid of the record to get service = Service to interact with DataVerse

Power Pages Update Last Successful Login Using JavaScript and Power Pages API

Recently while working on a Power Pages implementation for a client, I had the requirement to show the last time a user logged in on their profile page. I thought this would be easy to do as there is already a field on the contact record for "Last Successful Login" ( adx_identity_lastsuccessfullogin). This use to update when a user logged in, but it appears Microsoft has removed that automation. While searching I came across a few different ways of achieving this task. One used application insights in Azure and another one used an HTTP endpoint setup in Power Automate. I thought, this needs to be simpler. What I came up with is to use Liquid with JavaScript to tell if a user is logged in or not. Then use the new Power Pages api to update the logged in users contact record to mark the last time they logged in. Here is the approach I setup: 1) Make sure you turn on the api for contact in Site Settings. 1) Link to Microsoft Do...

How to Render Raw HTML Column in View in Power Pages

Recently I had a requirement for a client to convert their existing site over to Power Pages. One of the items I needed to convert was a "Recent Announcements" page. This is a pretty straightforward page with only a title of "Recent Announcements" and a grid showing the announcements. The grid only has two columns, 'Created On' and 'Message'. The problem I had to solve was I used the Rich Text Editor control on the 'Message' field. This means that raw HTML was stored in the field. Out of the box Power Pages can't render the raw HTML in the column. This means in the Power Page would have raw HTML showing instead of a nicely formatted message. This is easily solved with a small JavaScript function. The first thing I did was create a custom entity in DataVerse called Announcement. Here is the layout of the fields: Changed the primary name field from 'Name' to 'Subject'. Added a multi-line text field called 'Mess...