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:}