Checking a User’s New Email is Active
Often in an onboarding type app, an email will be sent to the new starter with Welcome type info. But this cannot be sent to the new account until the Exchange mailbox is ready, which takes some time depending on which way the wind is blowing at the data centre. One solution is to stick…
PowerShell from Power Automate via Azure Automation
There are some things, particularly with Exchange, that can still only be done by PowerShell. Flow can call these PowerShell jobs via an Automation account. I used this at a client years ago, and since then setting it up has become more challenging shall we say. My use case was to turn in Litigation Hold…
Dummy’s Guide to expand query in Flow
Expand query really simplifies one’s Flows, but the syntax is a killer. I forget this after 10 minutes so a super brief primer. Below, expanding the query to get the licenses attached to a system. The key is to ensure the lookup table uses the navigation property table name, easily seen in the all fields…
DataVerse List Rows get Related Records
When you stick a subgrid of related records on a form (if a N:N relationship was created rather than an intermediary entity), how does one retrieve those records? In Power Automate, do a List Rows on one of the entities with Fetch XML created in Advanced Find (or XRMToolBox) Where in this case, the related…
DataVerse Email Templates in Flows
Most apps need emails sent out, very likely from Power Automate. As a developer the thing I always hate is doing work. Well, boring work. A lot of Flow writers have a tendency to embed the email content into the Flow. Need a grammar change? Code release. Too much work. Previously I would create a…
Power Automate: Creating Teams, Tabs and Channels
There are various ways of creating Teams with Power Automate: The Create Team action in Flow. Currently, very limited options available. Create a Team from an Azure Group. This still requires the Graph API to create the group. Clone a current Team (Graph)- this is a really useful method, as it allows non IT people…
Using Visual Studio Code PAC to change Connection References in bulk
Those times you need to change connection references in 20 Flows and you go oh no! First in the solution in dev, create the new connection references or bring them into the solution. Then, export the unmanaged solution to your local machine. Put the unmanaged solution file in a nice folder, I go for C:/temp…
A way of getting Dynamics’ License members
Azure AD does not let you export users assigned a license. Group members can be exported, but not licences. Another reason to use Groups to assign licenses ! If you need all the members of a license type in a nice Excel spreadsheet, then : First you need to get the SKU of the license…
Sending DataVerse Emails in Power Automate Flow
Flow has the Outlook connectors for sending emails, from a shared mailbox or an individual account. But when using these, they are not connected into DataVerse, and it’s generally better to have any emails visible through the underlying app. If your app is built on DataVerse, then don’t use the Outlook connector, use the built…
Patching DataVerse from a Canvas App Error Handling
Simply, check for any errors ! Below example is using a DataVerse table called Jobs, and the record being patched is held in selRequest. With( { wUpdateJob: Patch( Jobs, LookUp( Jobs, Jobs = selRequest.tm_jobsid ), {‘Process Job’: true} ) }, If( IsBlank(wUpdateJob), Notify( “There was an error submitting your request: ” & Last(Errors(Jobs)).Message, NotificationType.Error )…
Something went wrong. Please refresh the page and/or try again.
Follow My Blog
Get new content delivered directly to your inbox.
Power Platform Always Learning 