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

Download

Microsoft Dynamics 365 Business Central Implementation Plan

Reference

BUSINESS CENTRAL WAREHOUSE MANAGEMENT SYSTEM (WMS)

Reference

BUSINESS CENTRAL WAREHOUSE MANAGEMENT SYSTEM (WMS)

Warehouse Management for Microsoft Dynamics 365 Business Central

Reference

Functions for warehouse management in Dynamics 365 Business Central

Reference

Administration

Bin Setup
Storage bins reflect the basic warehouse structure. In Dynamics 365 Business Central, when you create storage bins, you can define the contents you place in each bin very specifically. Alternatively, the storage location can function as a storage bin without specified contents.
On this basis, proposals are made for the placement of items.

Microsoft Dynamics 365 Business Central: Implementation Plan

Reference

The objective of this post is to provide a high level overview of different stages in the implementation of Microsoft Dynamics 365 Business Central (D365BC) to help companies prepare for it, navigate through it and succeed.

Microsoft Warehouse Management Software

What manufacturing and distribution features does Microsoft offer for warehouse management?

Business Central online Tutorial

https://usedynamics.com/business-central/