In this blog, we will learn about a new Power FX preview feature.   

Business requirement: To find difference between two dates by using “Formula” Data type. 

Follow this link to see “Formula” option as a data type.  

Link. (https://make.preview.powerapps.com/) 

After using this link, select the table where the “formula” data type is to be used. 

Here, we have created a table named as “Custom Table”. 

Now, we will add new column named as “Total Days” inside the table and select the data type as “Formula.” 

Also, we must already have created two date time columns “start date” & “end date.” 

• Formula for Date Difference: 

DateDiff(new_startdate,new_enddate) 

Now, we must add this formula in “Total Days” field inside Formula section.

After that, we must Add columns to main form. And click on save to publish the outcome. 

Let us see what will happen! 

Hope it helps!  

Power 365ing as usual!  

Any problem in Power Platform or Dynamics 365 – end user, Microsoft partner or an individual?  

Problem Area – Technical, Functional, Training, Development, or consulting?  

Me and my team are here to assist, please fill the following form for your business needs: Click here  

^{About the Author:}  

In this blog, we will learn about How to throw a custom error message in the PowerApps Portal page in D365.  

Sometimes when we are working on the PowerApps Portal, and we want to show some custom error message by using a Plugin based on some business logic, we will get a generic error message which is not useful to the end user that will say “An unknown failure has occurred. Error ID …” as shown in the fig. Given below : 

So, we will display the custom error message error with the help of the site setting in PowerApps portal. The steps are as follows: 

• Firstly, Go to Apps > Portal Management  

• Go to Site settings > New 

So, let us see what will do. 

Name - Site/EnableCustomPluginError 
Website – Whatever you have like Partner Portal, Customer Self-Service, etc… 
Value – true 

• Then, Save & close.  

And go to portal > Sync Configuration and click on Browse Website. 

Let us see what happens! 

So, you will see the custom error message on the screen. 

Hope it helps!   

Power 365ing as usual!   

Any problem in Power Platform or Dynamics 365 – end user, Microsoft partner, or an individual?   

Problem Area – Technical, Functional, Training, Development, or consulting?   

I and my team are here to assist, please fill out the following form for your business needs: Click here   

^{About the Author:}   

In continuation of my previous articles where we were exploring how to use the new Command designer, today we will learn how to apply a more complicated Patch function via Power Fx Command.

You can refer the previous parts as listed below:

Part 1: How to create a button:

{Step by Step}Create Command button in Power Apps using command designer

Part 2: How to apply a Power FX command using Command

{Step by Step}Add Power Fx Commands on a command button using command designer

Part 3:Apply Show Hide rules using Power FX command

{Step by Step} Add Show/Hide visibility rule using Power Fx to a Command button using new Command designer

In this blog, we will learn about the Patch function of Power FX in PowerApps, and we will use it in button click using the brand-new command editor!

Today’s requirement is that the account name should be updated at the click of a button.

To implement this requirement, first we need create a command button for which you should refer to Part 1 mentioned above.

We have created a button named as “Patch.”

And, we have used this formula to implement our requirements and added the formula for the notification:

Patch(Accounts, Self.Selected.Item, {‘Account Name’: “Patched: ” & Self.Selected.Item.’Account Name’});Notify(“Acount name is Upadated successfully”)

Let us test this button now! 

As you can see the account name is updated on the click of the Patch button.

Hope it helps! 

Power 365ing as usual! 

Any requirements, implementation or consulting work in Power Platform or Dynamics 365 – end user, Microsoft partner or an individual? 

Problem Area – Technical, Functional, Training, Development or consulting? 

Me and my team are here to assist, please fill the following form for your business needs: Click here 

^{About the Author:} 

In continuation of my previous articles where we were exploring how to use the new Command designer, today we will learn how to apply show and hide rule using Power Fx in the new command designer.

Part 1: How to create a button:

{Step by Step}Create Command button in Power Apps using command designer

Part 2: How to apply a Power FX command using Command designer: https://dynamicsofdynamicscrm.com/2022/08/04/step-by-stepadd-power-fx-commands-on-a-command-button-using-command-designer/

In last article we had already created a button named as “Entity Details.”

Now let us apply show and hide rule to the button!

Formula

Select the button “Entity Details”, click On Visible property and apply below formulae:          If(CountRows(Self.Selected.AllItems) > 0,true , false)

Based on this formulae, if at least one row of data is selected, button will be visible. Else, it will be invisible.

Please refer screenshot below:

As seen in below screenshot, command button is visible only when at least one contact is selected:

Tip: Sometimes the change on button does not reflect instantaneously, so you might need to refresh the page two to three times!

Now let us see the button visibility when no contact is selected:

Hope it helps!

Power 365ing as usual!

Any problem in Power Platform or Dynamics 365 – end user, Microsoft partner or an individual?

Problem Area – Technical, Functional, Training, Development or consulting?

Me and my team are here to assist, please fill the following form for your business needs: Click here

^{About the Author:}

In the last post we learnt how to add a command button using command designer: https://dynamicsofdynamicscrm.com/2022/07/27/step-by-stepcreate-command-button-in-power-apps-using-command-designer/

In this post, we will explore various Power FX commands we can add using new command designer:

We will cover the formulas “Navigate”,” URL” and “Notify”.

First go to the site map for Account table and click in the three dots ,click on edit command bar. Thereafter select the Main grid.

Three buttons are created as per reference in my last blog.

On click of “Navigate Active Record” button, we will navigate to “My Active Accounts” view

• Formula for Navigate.

Navigate(‘Accounts (Views)’.’My Active Accounts’)

• Result:

Now let us try to click on Navigate Active Records on Inactive Accounts view:

You can see that on click of the button we have navigated to “My Active Accounts” view:

Formula for URL:

Launch(“https://dynamicsofdynamicscrm.com/”);

Formula for Notify:

On click of Notification command button, we will try out Notify command:

Notify(“YouSelected”&Self.Selected.Item.’AccountName’,If(CountRows(Self.Selected.AllItems) > 0,true,false))

• Outcome:

There is a show hide formulae also applied on this button(about which we will learn in my next article). The button will only be visible on selection of particular record:

On selecting a single account named “A.Datum dd” and clicking on the “Notification” button, you can see above that the name of the record is showing in the notification section.

Hope it helps!

Power 365ing as usual!

Any problem in Power Platform or Dynamics 365 – end user, Microsoft partner or an individual?

Problem Area – Technical, Functional, Training, Development or consulting?

Me and my team are here to assist, please fill the following form for your business needs: Click here

^{About the Author:}

In today’s blog we will learn how to make command button using command designer. I am taking out of box entity Contact as an example in which we would add a command button. 

The objective is to add a command button to the marked main grid ribbon area as in the below snapshot. 

So, let’s go ahead and create the command button. 

Add Command button using Edit in Preview method of Power Apps:

Open any model driven app, click 3 dots to choose Edit in Preview and choose entity for which you want to add button. 

Let us use Sales Hub app as an example:

After that you will get a new interface in which you have to select the three dots of the entity where the command button you to added Click on edit Command bar:

Choose where you want to add button.

You can choose from the Main grid, Main form, Sub-grid and Associated view to add buttons. 

Thereafter, click on new button then click on command:

A command button has been created, now let’s edit its label.And can also select the visibility of the button  

Click Save and Publish.

Finally now you can see that a command button has been created in the marked box, whose label text is “Entity Details”. 

Hope it helps!

Power 365ing as usual!

Any problem in Power Platform or Dynamics 365 – end user, Microsoft partner or an individual?

Problem Area – Technical, Functional, Training, Development or consulting?

Me and my team are here to assist, please fill the following form for your business needs: Click here

^{About the Author:}

Business Requirement: Add a Custom filter for a table named “Language” on Field service Schedule board.

Solution:

Open your “Field Service” Application, make sure you are at the “Service” area (You may select the respective area from bottom left corner of the screen)

• Select “Schedule Board” from the site map

• Select the board in which you want to add a filter and then click on “Board Settings”

• Select “Other” and then edit “Filter Layout”

• Now, here we are adding “Language” entity filter (This is a custom entity I created). Add the following code under filter layout window:

<control type=”combo” source=”fetchxml” key=”Languages” unspecified-key=”UnspecifiedChildTerritory” label-id=”Language” entity=”test_language” multi=”true”>

         <fetch>

            <!– Table –>

            <entity name=” test_language “>

               <!– Filter By –>

               <filter type=”and”>

                  <condition attribute=”statecode” operator=”eq” value=”0″ />

               </filter>

            </entity>

         </fetch>

      </control>

• Here “Language” entity filter which we were trying to add is added 😊

Hope it helps!

Power 365ing as usual!

Any problem in Power Platform or Dynamics 365 – end user, Microsoft partner or an individual?

Problem Area – Technical, Functional, Training, Development or consulting?

Me and my team are here to assist, please fill the following form for your business needs: Click here

^{About the Author:}

Requirement: Enable editable grid on a Dashboard component for views.

Solution:

Follow the following steps to configure editable grid on a view component within Dynamics 365 CE dashboard:

1. Open the Dashboard for editing by clicking Edit:

• Double click the View component in which you wish to add Editable Grid control and select control tab:

• Select Editable grid in the control and set relevant option (selected Web in our example in the blog):

• Clock Ok and then Save, Close the dashboard(using Personal Dashboard in this example)

Result:

Hope it helps!

Power 365ing as usual!

Any problem in Power Platform or Dynamics 365 – end user, Microsoft partner or an individual?

Problem Area – Technical, Functional, Training, Development or consulting?

Me and my team are here to assist, please fill the following form for your business needs: Click here

Today we are going to go through how to enable 2022 Wave 1 feature and then enable Modern Advanced find view settings.

Step 1: Navigate to Power Platform Admin centre and Environments. Under Updates Click Manage:

Step 2: Click on Update now:

Step 3: Leave updates to complete, Activating can take 20-30 minutes:

Next once done navigate to Environment -> Settings -> Features and turn on the following as selected in the screenshot:

Let us go through the feature usage in video format below:

Hope it helps!

Power 365ing as usual!

Any problem in Power Platform or Dynamics 365 – end user, Microsoft partner or an individual?

Problem Area – Technical, Functional, Training, Development or consulting?

Me and my team are here to assist, please fill the following form for your business needs: Click here

Requirement: Extract text out of rich text editor control text on a Dynamics 365 CE Record form.

Here is the script for this example (written on change event):

function onChange(executionContext)
{

var formContext = executionContext.getFormContext();
formContext.getAttribute("new_plaintextwithhtml").setValue(formContext.getAttribute("new_htmlrichtext").getValue());
formContext.getAttribute("new_texteditorcontrol").setValue(convertToPlain(formContext.getAttribute("new_htmlrichtext").getValue()));


}

function convertToPlain(html){

    // Create a new div element
    var tempDivElement = document.createElement("div");
    
    // Set the HTML content with the given value
    tempDivElement.innerHTML = html;
    
    // Retrieve the text property of the element 
    return tempDivElement.textContent || tempDivElement.innerText || "";
}

Hope it helps!

Power 365ing as usual!

Other ways to learn with me:

Any problem in Power Platform or Dynamics 365 – end user, Microsoft partner or an individual?

Problem Area – Technical, Functional, Training, Development or consulting?

Me and my team are here to assist, please fill the following form for your business needs: Click here