Dynamics 365 Customization Insight: Navigating Business Rule Activation Errors

In the world of Dynamics 365, customizing business processes to fit specific requirements is a common task. However, this customization journey isn't without its hurdles. A particularly perplexing issue can arise when activating Business Rules, especially those involving lookup fields. This article delves into a specific error encountered during Business Rule activation and offers a JavaScript workaround for situations where traditional Business Rules fall short.

[TIPS] SSIS: Export data from SQL Server to Excel Fail

 Error Message: 

[TIPS] Hide date format "12/31/2001" when date filed is unselected or blank in Canvas App

 Issue: 

  In Power Apps (Canvas App), when use SharePoint as the data source, the date field always shows "12/31/2001" even this field is blank or not selected.

[TIPS] Power Apps SharePoint form setting date/time field to blank

Power Apps SharePoint form setting date/time field to blank

ISSUE: Can't clear a datetime field in SharePoint from PowerApps.

[TIPS] Add "Other" to PowerApps Canvas App Dropdown Field

 Dropdown menus allow app users to select a pre-defined value from a list of options. But sometimes you want the user to fill-in their own value using a text input their selection cannot be found in the list. In this article I will show you how to create a dropdown with an other option in Power Apps.

[TIPS] PowerApps Form doesn't show up in SharePoint List or not the expected size (squeezed)

Issue:

   When trying to use PowerApps form in SharePoint list, the PowerApps form doesn't show up.

[TIPS] Columns couldn't be imported to SharePoint List by using Power Automate /Flow

 Requriement:

   Import Excel to SharePoint through Power Automate (Flow).

Issue:

  Below highlighed two columns couldn't be imported.

[TIPS] Get Excel Date Column and Create in SharePoint List Failure

Requirement:  get items from Excel, then create an item in SharePoint list.

Issue:

Got failure when create new item in SharePoint List.

The error occurred in Date column.

The date value in Excel is integer numbers. 

I used a Compose step to get the date value in Flow.

Use the below expression got below error.

if(empty(outputs('Get_Requested_Date')),null, addDays('1899-12-30',int(outputs('Get_Requested_Date')),'yyyy-MM-dd'))

Unable to process template language expressions in action 'Create_item' inputs at line '0' and column '0': 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.

 

Solution:

Change the expression to below one. The error gone.

if(empty(outputs('Get_Requested_Date')),null, if(isInt(outputs('Get_Requested_Date')), addDays('1899-12-30',int(outputs('Get_Requested_Date')),'yyyy-MM-dd'),null))

If you wanna follow this expression, just replace outputs('Get_Requested_Date') with yours.