AddColumns() function to dynamically add columns to a Data table in Canvas Power App | SharePoint List
At times, you want to do a quick calculation but the Data Source doesn’t have that column present. Example, you’re populating some data from a SharePoint List which is a Scoreboard. But it doesn’t tell the difference between the current Score and Top Score. So, to find how many points does the Score trails by the Top Score. To do that, we’ll dynamically add a Column to our Data Table in a… Continue...
AddColumn() function to dynamically add columns to a Data table in Canvas Power App | SharePoint List
At times, you want to do a quick calculation but the Data Source doesn’t have that column present. Example, you’re populating some data from a SharePoint List which is a Scoreboard. But it doesn’t tell the difference between the current Score and Top Score. So, to find how many points does the Score trails by the Top Score. To do that, we’ll dynamically add a Column to our Data Table in a… Continue...
Implement real-time search in Gallery of CDS records in a Canvas Power App | Power Platform
One of the most common asks is to be able to search CDS records in a Gallery control in real-time using a Text-box. Search Box & Gallery connected to CDS Let’s design a simple gallery that is populated with CDS records from Account entity. Take a Text Input control (Textbox) and make it look like a Search Box. In order to have the Search watermark, write the text to appear as… Continue Reading priyeshwagh777’s...
Using triggerBody() / triggerOutput() to read CDS trigger metadata attributes in a Flow | Power Automate
Now, for all the newbies working with Common Data Service (Current Environment) connector face a little constraint in order to read certain fields which are NOT in the list of the Dynamic Content of the CDS connector itself. Scenario Let’s say you want to read this field from the Body / Outputs of the CDS trigger in a Flow in Power Automate Attributes (or rather supporting metadata)… Continue Reading priyeshwagh777’s...
![Convert environments between Production and Sandbox | Power Platform Admin Center [Quick Tip]](https://365community.online/wp-content/uploads/2020/09/1599331403_Convert-environments-between-Production-and-Sandbox-Power-Platform-Admin-240x240.png)
Convert environments between Production and Sandbox | Power Platform Admin Center [Quick Tip]
In most scenarios, you might need to either – Convert from Production to Sandbox orConvert from Sandbox to Production Converting from Production to Sandbox Navigate to Power Platform Admin Center’s environments section – https://admin.powerplatform.microsoft.com/environmentsSelect the environment you want to convert (you can even navigate inside this environment)You’ll be asked for… Continue Reading...
Log Canvas Power App telemetry data in Azure Application Insights | Power Apps
Here’s how you can register your Canvas Power App in your Azure’s Application Insights and log telemetry data into Azure. Some basic info about what all you can see in Application Insights is – Count of Users who used the appEvents logged, Sessions loggedDevice infoRegion info It’s quite simple to set it up! Let’s take a look – < h2>Registering in Application Insights in… Continue Reading...
![Find Created On date of solution components in Solution Layers | Dynamics 365 [Quick Tip]](https://365community.online/wp-content/uploads/2020/08/Find-Created-On-date-of-solution-components-in-Solution-Layers-240x240.png)
Find Created On date of solution components in Solution Layers | Dynamics 365 [Quick Tip]
If you’ve been using classic CRM since 2011 days until Solutions History came out (around 2018 timeline), we always wondered when was a certain field, view, form (component in general) was created. It’s possible to see using Solution Layers Example: When was a field created Let’s say you want to find out when a field was created. Select the field, check for Solution Layer as shown… Continue Reading...
Call HTTP Request from a Canvas Power App using Flow and get back Response | Power Automate
Now, there are several questions about how can we make HTTP requests from a Canvas Power App. Well, as of today, only HTTP with Azure AD exists in native Canvas Power App Connectors, so in order to call HTTP requests only to external resources, you’ll need to go via a Flow and get response back. Scenario Call a Flow from within a Canvas Power App and capture the response back in the… Continue Reading priyeshwagh777’s...
![Change Booking Status colors on Schedule Board for Field Service/PSA [Quick Tip]](https://365community.online/wp-content/uploads/2020/08/1597859113_Change-Booking-Status-colors-on-Schedule-Board-for-Field-ServicePSA-240x240.png)
Change Booking Status colors on Schedule Board for Field Service/PSA [Quick Tip]
Here’s a Quick Tip for everyone using Field Service and Project Service Automation. In case you are wondering how can you change the colors of the Booking Statuses on the Schedule Board for Field Service and PSA, here’s what you need to do. Default Colors This what your default Schedule Board looks like out-of-the-box. Booking Statuses Booking Status is an entity within which you… Continue Reading...
Send a Power App Push Notification using Flow to open a record in Canvas App | Power Automate
Let’s say most of your users are using custom Canvas Power Apps to follow their business tasks and rely on Canvas Apps for their actions inside Dynamics 365. There could be scenarios where you want to notify them conditionally of important items that need their attention. Scenario Let’s say you have a few users whom you want to tell them that an Opportunity was Won. It could be a team… Continue Reading...
![Add multiple Opportunity Products at once in Dynamics 365 Sales | Enhanced Experience [Preview]](https://365community.online/wp-content/uploads/2020/08/1597180850_Add-multiple-Opportunity-Products-at-once-in-Dynamics-365-Sales-240x240.png)
Add multiple Opportunity Products at once in Dynamics 365 Sales | Enhanced Experience [Preview]
Very easy tweak but this will save loads of your time. One of the most important asks by Salespeople is perhaps this – “Add multiple Products on Opportunity at once!“ Here’s how you can do this – Classic Experience In current/classic experience, if you open Opportunity Lines and go on to add a Product as below – It’ll either open in a New form.This isn’t intuitive. You definitely…...
Recover deleted D365 PowerApp environment using PowerShell
To get the most important things out of the way, this can be done only within the first 7 Days. Deleted Environment At times, you want to delete an environment you don’t need. But you feel you do need it back. Deleting an environment from the Power Platform Admin Center will Soft Delete it and you can get it back within the first 7 days only. Here’s some info by Microsoft on that: Continue Reading priyeshwagh777’s...
Launch URL on a Data Table Text column selection in a Canvas PowerApp | SharePoint Lists
Let’s say you are using SharePoint Lists to populate your Data Table in a Canvas Power App. And you have a Text column which could be typically name of the Website and another column could be a URL. Now, you want to be able to click the Name of the Website and the selection should take you to the Website itself. Scenario Now, below is the Blog List in SharePoint you are populating… Continue Reading priyeshwagh777’s...
Accept HTTP Requests in a Flow and send Response back | Power Automate
Let’s say you want to create a consumable HTTP service, do some operation and send back Response. Here’s what you can do. You can create an HTTP Request Trigger to receive the HTTP request, process the request and send back a Response. Accept HTTP Request in Flow Let’s create a listener first, so that we can get the URL to be used and ask users to submit on that URL. In your… Continue Reading...
Terminate a Flow with Failed/Cancelled status | Power Automate
Usually, things don’t fall into a certain condition and we tend to leave the Flow like that. Use Terminate control in a Flow in Power Automate to correctly end a Flow Run by declaring that it wasn’t successful. Scenario At times, when we use Condition i.e. If True or False, we put everything in True and nothing in False, just keeping it blank. And when the condition turns out that… Continue Reading...
Adaptive Cards for Teams to collect data from users using Power Automate | SharePoint Lists
Adaptive Cards is something so cool and works like magic!! I’m sure there are so many creative ways to use it. Here’s an example – Use Adaptive Cards to gather data from Microsoft Teams Users and populate it automatically to SharePoint List. Scenario Let’s say, you have a set of data to collect from your employees – for instance, planning a trip (or any other event for that matter)… Continue Reading...
Aggregate functions in a Canvas Power App | Using on SharePoint Lists
Aggregate functions have one of the most common applications while building your Canvas Power App. In this simple example, we’ll try to make common Aggregate Functions like Max, Min, Sum & Average work. There are 2 more advanced Aggregate Functions, StdevP for Standard Deviation and VarP for Variance. (It might not make full sense in this post, but I added them anyway to see how we can… Continue Reading...
![Import lookup referencing records together in Dynamics 365 CRM | [Linking related entity data during Excel Import]](https://365community.online/wp-content/uploads/2020/07/1594227016_548_Import-lookup-referencing-records-together-in-Dynamics-365-CRM-240x240.png)
Import lookup referencing records together in Dynamics 365 CRM | [Linking related entity data during Excel Import]
This is one of the most common scenarios where you want to import an entity’s data in Dynamics 365 that has reference to some other entity. And the Lookup’s data is not yet created resulting in the Lookup reference missing. Just like below – And resulting into the below – And similarly while importing Contacts, the Account might not be already imported. And you get the error ‘The… Continue Reading...
Mailbox Alerts Hide/Show behavior in Dynamics 365 CRM
At times, ever wondered what happened to the Mailbox? You ran some tests, you also got results, but the Alerts section is empty or not generating Alerts. Here’s what’s missing and how the behavior is – Turn on Mailbox Alerts In System Settings, you can turn on what type of Mailbox alerts should be shown. Navigate to Email and scroll down. You can then choose what type of info… Continue Reading...
![Count of total CDS records returned in a Canvas Power App connection [Quick Tip]](https://365community.online/wp-content/uploads/2020/07/Count-of-total-CDS-records-returned-in-a-Canvas-Power-240x240.png)
Count of total CDS records returned in a Canvas Power App connection [Quick Tip]
Like in Dynamics 365, you see a total number of records under a view. And you want similar in a Canvas PowerApp too. Here’s a simple tip to do so – CountRows() method It’s pretty simple. Using CountRows(source) method, you can get the count of records in the Source. In this case, it’s the CDS entity Accounts. To flourish how I display the count, I use the Concatenate() method and… Continue Reading...
Dependent OptionSets in a Canvas Power App for 1:N related CDS entities | Power Platform
Most useful scenarios is to create what we commonly call as “Dependent OptionSets” in Dynamics 365 context. Scenario Here, Country and State are 2 entities in CDS. Each Country has N states i.e. Country is a parent entity of State entity. We’ll create 2 Drop-downs in a Canvas Power App i.e. 2 OptionSets namely Country and State that selection of Country will affect what should be… Continue Reading...
![ChildFlowUnsupportedForInvokerConnections error while using Child Flows [SOLVED] | Power Automate](https://365community.online/wp-content/uploads/2020/06/1593367243_ChildFlowUnsupportedForInvokerConnections-error-while-using-Child-Flows-SOLVED-Power-Automate-240x240.png)
ChildFlowUnsupportedForInvokerConnections error while using Child Flows [SOLVED] | Power Automate
Often times, if you are using Child Flows and but you see some unexpected while Saving your parent Flows upon adding a Child Flow, which usually look like the below Assuming, you are aware of using Child Flows and that they can only be created inside a Solution. (Of course, that’s why you could encounter this issue since you’re able to set a Child Flow already ) Reason Issue Let’s say… Continue Reading...
Excel Importing Notes (Annotation) entity in Dynamics 365 CRM
Preparing an Excel Template for Notes entity is a little tricky. Doesn’t work when you just Export directly as a Template from the Templates Wizard and try to include all columns and import as is. Why? Because there’s no Regarding field exported when you export/import that template. Here’s what you can do as a workaround. Scenario Now, let’s assume you want to Export a standard… Continue Reading...
BPF Flow Step as a Trigger in CDS (Current Environment) connector | Power Automate
Here’s an update to the Common Data Service (Current Environment) connector in Power Automate Remember, this is available only in Common Data Service (Current Environment) connector i.e. you’ll need to create you Flow inside a Solution in Power Automate Flow Step Now, you can call your Flow from a Business Process Flow, which existed for some time. But now, it’s available as a trigger… Continue Reading...
Pass selected rows’ GUIDs to ribbon button in D365 | Ribbon Workbench
Whenever your Ribbon button customization involves doing something to selected records, here’s the most common application that you need to take action on the selected record’s GUIDs. Here’s how – CRM Parameter In Ribbon Workbench, let’s say you have a button command which is attached to a button and it calls a method ‘process’ which looks like this (it will be your method in your…...
Pause a Flow using Delay and Delay Until | Power Automate
In some use cases, you want to pause a Flow either by a duration you specify or until the timestamp you specify. Let’s look at both the ways – Delay and Delay Until in Schedule operation Delay In a simple application, you can make a Flow wait for a certain duration by using the Delay Action in Time And I’m selecting a standard 3 min waitAnd it will pause the execution until… Continue Reading...
Generate Dynamics 365 record link in a Flow using CDS connector | Power Automate
There are several ways to formulate a Dynamics 365 record URL and make it clickable in a Flow in Power Automate. Here’s one of the ways I follow for most scenarios – Let’s say I want to open a PSA Time Entry record from my Flow, here’s how I do it Get record action to retrieve URL Since this post is focused on CDS connector, I can get the D365 record link in body of Get record action… Continue Reading...
Text Functions in a Flow | Power Automate
As I was looking at some String/Text operations in Flow recently, here’s what I discovered. Looks like there are a lot more to come, so let’s look at some initial ones. Find text position A pretty simple feature to find the position the Search Text starts from in a String. Here, I’m trying to find where does ‘yes’ in string ‘Priyesh’ starts from in the given text. And the… Continue...
Restore older version of a Canvas Power App | Power Platform
When you users report of an issue and you need some time to look into it but can’t hold the users, you just want to restore to a previous version for the time being. Here’s how you can restore/revert to an older version of the Canvas App you’ve deployed. Current Version Let’s say my current version had a button called Profile under the label Accounts. But in the new version, I had… Continue Reading...
Implement character length validation in a Canvas Power App | Power Platform
Often times, you want to know the size of text entered in a field and want to indicate a user that they need to restrict the text to your specific size, like Twitter. And make sure the user is restricted within the limits. So, I’ve added a button to show that validation – And you want to dynamically check the length as you type to see how much is remainingAnd maybe also add some… Continue Reading...
Logged In User details in a Canvas Power App
You do get some details of the logged in user in a Canvas Power App. Let’s look at what all is available – User() Function User() function provides 3 pieces of information you can retrieve at this point in terms of logged in user. Email Use User().Email to populate a Text field with the Email address of the logged in user. Full Name Use User().FullName to fetch the… Continue Reading priyeshwagh777’s Article on...
Loop through array of objects in a Flow & Create records in CDS | Power Automate
One of the most common scenarios that are looked out for are ways to loop through an array of objects received (say, from HTTP response) and create CDS records Sample Data Let’s say this is the sample data coming in which is an array of objects. This is coming from my HTTP trigger which I created and hosted. It could be anything else in your case And the body looks something like this… Continue Reading...
Implementing Exit app, Logout and Confirm Exit features in a Canvas Power App
Most common scenarios are where you need users to be able to Exit the Canvas Power Apps in the below ways –Scenario – Let’s say you put a close button somewhere in your App. Exit the current App but stay logged-in to Power Apps.Exist and Logout Power Apps entirely.In both above cases, ask user for confirmation before exiting. So let’ look at these scenarios one by one – Exit from… Continue Reading...
Get Count of records retrieved in CDS connector in a Flow | Power Automate
In several applications, you need to know how many record were retrieved in the List records Action in a Common Data Service connector in order to take a decision. Scenario Typically, let’s say I know only 1 record should exist in order to take that record forward and do an action. But how do I know when only 1 record was received? That’s when you use Control Check Count Now, let’s say you… Continue Reading...
Variables in Canvas Power Apps | Global and Context
For all newbies, being able to use Variables is one the most curious questions put out immediately. Here’s a simplistic example of using Variables, both Global and Contextual in this post. Global Variable Global Variables as the name suggest, run through the entire App itself and can be changed and altered when needed. Global variables can hold boolean, string, number etc. Let’s say, I have… Continue Reading...
Number Formatting in a Flow | Power Automate
Quite obviously this is one of the most common asks in Flow to format a number. Here are some ways to do so using Format number Action in Flow (Power Automate). This is available in Format number action in a Flow in Power Automate. This is available in Number Functions connector. Commas and Decimals For a standard simple number, you can simply denote by # and commas or other symbols where… Continue Reading priyeshwagh777’s...
Get N:N records in a Canvas Power App using Common Data Service connector | Power Platform
One of the most common asks when using CDS as Data Source in a Canvas Power Apps is – How do I get the data from N:N entities? Well, I’m attempting to explain this in the easiest way possible. Scenario Let’s assume Account entity has an N:N relationship with Account Plans entity Account <–N:N–> Account Plans. And in Dynamics 365, you simply add these records by going into related records and…...
![Call a Dynamics 365 Action from Flow [Bound and Unbound Actions] | Power Automate](https://365community.online/wp-content/uploads/2020/05/Call-a-Dynamics-365-Action-from-Flow-Bound-and-Unbound-240x240.png)
Call a Dynamics 365 Action from Flow [Bound and Unbound Actions] | Power Automate
Ever wondered how to call an Action from a Flow using the new Common Data Service (Current Environment) connector? There are 2 actions to perform this – Here’s a quick post to demonstrate that and the difference between Perform a bound action and Perform an unbound action in the CDS (Current Environment) connector. Note that the connector used here is Common Data Service (Current Environment)… Continue Reading...
Modify Project tab’s view in Schedule Board in PSA v3 | Quick Tip
Most common asks on Schedule Board in D365 PSA is about how we can modify the Project tab view we see? Resource Requirement Entity The Resource Requirement entity is what controls what views are available for you on the Schedule Board – To be able to find what this view is about, you’ll need to go to the Resource Requirement entity Now, if I open this record, you can make changes to this… Continue Reading...
Switch-Case in a Flow | Power Automate
Some of the common operations / decision making one wants to perform in terms of programming is definitely switch-case! Here’s how you can do it in power automate Scenario To keep things simple, I will simply reflect the name of the OptionSet value in a variable in Flow – Here’s my OptionSet called Account Type with values Customer [1], Vendor [2] & Partner [3] My Flow will be… Continue Reading...
Dynamics 365 PSA v2 to v3 Upgrade failed? Here’s what to do.
This is a little tricky upgrade from PSA v2 to PSA v3. I’m sure by this time of the year, most of you must have upgraded and this post by me comes a little late than it should. Here’s my experience and what help from Microsoft Support I needed to complete the Upgrade successfully. So usually, this is what you expect when you initiate the upgrade process. You go to the Instance Picker from… Continue Reading...
Dynamics 365 Solutions’ New Experience in Power Apps, Solution Checker and more
If you’ve recently noticed Settings > Solutions area in Dynamics 365, you’ll see a notification that this has been moved And you’ll be redirected to Solutions Area in Power Apps – Solution Checker Solution Checker is a helpful feature where it runs a validation of components in the Solution itself – If you see for your custom Solutions, if you haven’t ever Run a check on the solution, the…...
Setting Retry Policy for an HTTP request in a Flow | Power Automate
Often times, There could be an issue where your HTTP request isn’t hitting well. So, to overcome this, you might want your Flow to Retry after a certain duration and for some number of times. You want to setup a Retry policy for the same. Here’s how you do it! Setting Retry Policy Follow this to setup a Retry Policy of your Flow Locate your HTTP step and navigate to Settings Once you’re in… Continue Reading...
Debug Ribbon button customization using Command Checker in Dynamics 365 CE Unified Interface
Developers, it’s a little irksome to keep struggling with issues around making your ribbon buttons work correctly during the development phase. At times, you wonder why your button didn’t show up on the form although you had set everything up correctly. Or even for out-of-box button, that didn’t show? Scenario In this example, I’ll find out by my Project Service Quote record doesn’t have a… Continue...
Using Parse JSON to read individual List Records in Flow|Power Automate
This is a scenario I came across when I was using Common Data Service connector [not Common Data Service (Current Environment)] connector to read Opportunities tied to an Account. Example In this scenario, I wanted to retrieve the Opportunities tied to an Account. So, my filter query was _parentaccountid_value(‘ACCOUNT_IDENTIFIER’) Here’s my Flow starts. I want to read Opportunities that are… Continue Reading...
Enable/Disable the need to Approve Email for Mailboxes in Dynamics 365 CRM CE
This is one of the most useful common scenarios where you have to approach a Global Administrator every time to Approve Emails. Even when you want to create a few Queues or test Mailboxes on a non-production environment. I would recommend this to be used only on Sandbox instance and let Production instance have this layer of approval of Global Administrators, but then it depends what you want… Continue Reading...
Make HTTP request from Flow in Power Automate
One of the most common asks I’ve come across lately is people asking whether or not, we can make external HTTP requests using Flow in Power Automate. Well, yes! Let’s quickly take a look at how you can do that. Scenario To keep the example really simple, I have an API that I can use to call to get weather information. (By the way, you’ll find MSN Weather connector in Power Automate too) So,… Continue Reading...
Pass data to HTML Web Resource using browser’s sessionStorage in Dynamics 365 CE
If you’re using Xrm.Navigation.openWebResource(webResourceName, windowOptions, data), you probably are already using ‘data’ to the HTML Web Resource you are opening. Here, I’m using an alternate method. I use JSON to send my data since it is widely preferred and used. Basically, I’ll Stringify my JSON object and add it to session storage, then – retrieve it from sessionStorage and Parse is…...
Retrieve only active Dynamics 365 CE licensed Users in CDS connector in Power Automate
Let’s say you have a requirement where you want to work only on Dynamics 365 and you are using Office 365 Get User Profile action to retrieve all users. In this example, I have some Dynamics 365 Customer Engagement licenses assigned to uers. And I want to retrieve only the Active D365 Users in my Common Data Service Connector. Here’s how I do it – Retrieve Users with Filter Condition Now, the… Continue Reading...
Refresh button missing on Roll-Up fields in D365 UCI? Quick Tip.
As we are transitioning to the Unified Interface, some visual cues are a little misplaced or say, hidden. If your Roll-up field on the Classic UI appeared like this where you could simply click on refresh and update the Roll-up field It doesn’t seem to be the case in terms of UCI- It’s Hidden! So, simply click on the Calculator icon – And the Recalculate button will be revealed which… Continue Reading...