Blog Archives - Page 31 of 125 - - Page 31

Category Archives: Blog

How to use Expand Query in MS Flows

Introduction This blog explains how to use Expand Query (N:1 Relationship) in the Common Data Service List Records Connector. Steps to be followed: Initialize Variable of type string. Using Expand in list RecordsExpand Query: cf_Project($select=cf_projectname,cf_projectabbreviation) Here cf_Project is the Schema Name of Project Lookup field on location entity. Pass the field names of the project … Continue reading How to use Expand Query in MS Flows

Share Story :

Send an e-mail to any audience when Power BI data alert is triggered

Posted On January 7, 2020 by Sandip Patel Posted in

In this blog I am going to explain you how to send an e-mail to any audience when a Power BI data alert is triggered. Step 1: Create a sample of Power BI report using visuals like gauge, KPI or card title. Step 2: Publish your Power BI report on app.powerbi.com site. Step 3: Pin … Continue reading Send an e-mail to any audience when Power BI data alert is triggered

Share Story :

Conversion of Time and Date in MS flow

Introduction We had a requirement where we wanted to create a price list with current date time with respect to current country. In this blog we will use the OOB date conversion functionality. Use Case : (UTC with ) We created a flow where we had used UTC now functionality but this was returning the … Continue reading Conversion of Time and Date in MS flow

Share Story :

Share Records in D365 CRM by Code

Introduction: This blog details steps how to share entity record in D365 CRM by Code. Scenario:  We have client requirement to share record with multiple set of Users in D365 CRM based on criteria selected by User on Form and needed to be automated. Implementation Step: Below code to be developed for OnCreate of record. … Continue reading Share Records in D365 CRM by Code

Share Story :

Add effects to Power BI Buttons

Hello Friends, in this blog we will see how to add effects to Power BI buttons. Steps: Open Power BI desktop and select blank button from ribbon. Now add a rectangular strip to your button to look more attractive with the following configuration. Now add another button with transparency 50 % in default state just … Continue reading Add effects to Power BI Buttons

Share Story :

Calculated Field in Dynamic 365 CE

Introduction In this blog we will see how to use Calculated field. Use Case : Its common requirement of Project to set calculated date to specific date field by adding or Subtracting the no. of days. Implementation : Step 1: Let say we have date field in an Account Entity.   Step 2:  Create one more … Continue reading Calculated Field in Dynamic 365 CE

Share Story :

Order fulfillment notifications in Dynamics 365 Retail (Commerce)

Posted On December 27, 2019 by Admin Posted in

The order fulfillment operation in the point of sale provides a single work area in the point of sale that can be used to process orders. This includes everything from accepting the order, to marking it as shipped, or initiating store pickup. In my case we wanted a notification to appear on POS whenever a … Continue reading Order fulfillment notifications in Dynamics 365 Retail (Commerce)

Share Story :

Convert Email Body from HTML format to Text

Introduction: We had a requirement , wherein when an Email is received a Case will be created in CRM and the body of the email will be set the description of the case. However we faced a problem because the Email body was in HTML format so we have to convert it and set it … Continue reading Convert Email Body from HTML format to Text

Share Story :

Suspend(Hold) and Recall a transaction in the POS in D365 Retail(Commerce)

Point of sale (POS) users can suspend in-progress transactions, and then resume them later or on a different register. Transactions are often suspended to quickly free up a register for a different task without losing any progress on the current transaction. For example, a store associate starts to process a customer’s transaction on a mobile … Continue reading Suspend(Hold) and Recall a transaction in the POS in D365 Retail(Commerce)

Share Story :

How to retrieve a Sub-string from a String

Problem Statement:  We have a requirement where the client wants a part of String from Sales Order No. which is Code(Data type) and it is auto-generated from Number Series. The Sales Order No. value is “SO/123/789/456”. The required Sub-string was: 123<Space>789. Pre-requisites: VS Code AL Language Extension Microsoft Dynamics NAV /  Business Central Solution: As … Continue reading How to retrieve a Sub-string from a String

Share Story :