[DEMO] Synchronize Data from Business Central to Dynamics CE (Dataverse) through OData (Web API)

Synchronize Data from Business Central to Dynamics CE (Dataverse) through OData (Web API)

Business Central Web Services

Business Central supports three types of web services: API, SOAP, and OData.

Power BI Data Refresh

In this tutorial, we will see what is data refresh in Power BI and how to schedule refresh in Power BI. And also we will discuss

[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.

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.

GroupBy and Ungroup functions in Power Apps

Article
06/30/2022

Reference

Groups and ungroups records of a table.

Embed a Power BI report in a model-driven app main form

You can use Power BI reports in Power Apps model-driven apps to bring rich reporting and analytics to your main forms and empower your users to accomplish more. This unlocks the power to aggregate data across systems, and tailor it down to the context of a single record.

[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.

How to recognize the project management pattern

Reference

Canvas App Monitor

Reference

Canvas App Monitor is a new tool to better understand, debug, and improve your apps. Monitor provides a running log of all the activity within your app allowing you to see how declarative formulas are actually doing their work.

Delegable functions

Reference

The next step is to use only those formulas that can be delegated. Included here are the formula elements that could be delegated. However, every data source is different, and not all of them support all of these elements. Check for delegation warnings in your particular formula.

Power Apps delegable functions and operations

Reference

Delegation is supported for certain tabular data sources only. If a data source supports delegation, its connector documentation outlines that support. For example, these tabular data sources are the most popular, and they support delegation:

Power Apps Functions List.

Filter Array & Select in Power Automate

Filter Array in Power Automate:

Use the Microsoft Dataverse Web API

Reference

Note

Unsure about entity vs. table? See Developers: Understand terminology in Microsoft Dataverse.

Call third party webapi from plugin using secure/ unsecure configuration (Sample C# code)

Reference

Create a note in Dynamics 365

//add a note

Entity Note = new Entity("annotation");

Note["objectid"] = new EntityReference("contact", ent.Id);

Note["objecttypecode"] = 2;

Note["subject"] = "Latest Currency Exchange Data";

Note["notetext"] = "USDEUR : " + USDTOEUR +" " + _url + "?" + query + " " + content;

service.Create(Note);

What's the $ in front of a string in C#?

`What's the $ in front of a string in C#?`

Reference

$ is short-hand for String.Format and is used with string interpolations, which is a new feature of C# 6. As used in your case, it does nothing, just as string.Format() would do nothing.

What's the @ in front of a string in C#?

Reference

It marks the string as a verbatim string literal - anything in the string that would normally be interpreted as an escape sequence is ignored.

Difference between \r\n, \r, and \n

\r = CR (Carriage Return) → Used as a new line character in Mac OS before X
\n = LF (Line Feed) → Used as a new line character in Unix/Mac OS X
\r\n = CR + LF → Used as a new line character in Windows

Utilising Pre/Post Entity Images in a Dynamics CRM Plugin

Lets take a closer look at how Pre and Post Images can be implemented as part of a CRM Plugin…

Reference

Tutorial: Write and register a plug-in

This tutorial is the first in a series that will show you how to work with plug-ins.

Sample Workflow Acitivity C# code

The following sample workflow activity returns the next birthday. Use this in a workflow that sends a birthday greeting to a customer.

Tutorial: Create workflow extension

Goal

The example below will create a simple custom workflow activity that may be used in a workflow, dialog, or action process. More information: Configure workflow stages and steps

This custom workflow activity will match the following requirements:

Accept an decimal input parameter
Output a value equal to the input parameter plus 10.

https://community.dynamics.com/365/sales/f/dynamics-365-for-sales-forum/373563/word-template-created-on-date

Manually Install [Export Security Role] tool on XrmToolBox

Download the file from below link:

https://github.com/arshad1234517/Export-Security-Role-File and add the dll under the xrm tool box.

Using Git source control in VS Code

Reference

Visual Studio Code has integrated source control management (SCM) and includes Git support out-of-the-box. Many other source control providers are available through extensions on the VS Code Marketplace.