Business Requirement: Add a Custom filter for a table named “Language” on Field service Schedule board.

Solution:

Open your “Field Service” Application, make sure you are at the “Service” area (You may select the respective area from bottom left corner of the screen)

• Select “Schedule Board” from the site map

• Select the board in which you want to add a filter and then click on “Board Settings”

• Select “Other” and then edit “Filter Layout”

• Now, here we are adding “Language” entity filter (This is a custom entity I created). Add the following code under filter layout window:

<control type=”combo” source=”fetchxml” key=”Languages” unspecified-key=”UnspecifiedChildTerritory” label-id=”Language” entity=”test_language” multi=”true”>

         <fetch>

            <!– Table –>

            <entity name=” test_language “>

               <!– Filter By –>

               <filter type=”and”>

                  <condition attribute=”statecode” operator=”eq” value=”0″ />

               </filter>

            </entity>

         </fetch>

      </control>

• Here “Language” entity filter which we were trying to add is added 😊

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

Requirement: Enable editable grid on a Dashboard component for views.

Solution:

Follow the following steps to configure editable grid on a view component within Dynamics 365 CE dashboard:

1. Open the Dashboard for editing by clicking Edit:

• Double click the View component in which you wish to add Editable Grid control and select control tab:

• Select Editable grid in the control and set relevant option (selected Web in our example in the blog):

• Clock Ok and then Save, Close the dashboard(using Personal Dashboard in this example)

Result:

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

Today we are going to go through how to enable 2022 Wave 1 feature and then enable Modern Advanced find view settings.

Step 1: Navigate to Power Platform Admin centre and Environments. Under Updates Click Manage:

Step 2: Click on Update now:

Step 3: Leave updates to complete, Activating can take 20-30 minutes:

Next once done navigate to Environment -> Settings -> Features and turn on the following as selected in the screenshot:

Let us go through the feature usage in video format below:

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

Requirement: Extract text out of rich text editor control text on a Dynamics 365 CE Record form.

Here is the script for this example (written on change event):

function onChange(executionContext)
{

var formContext = executionContext.getFormContext();
formContext.getAttribute("new_plaintextwithhtml").setValue(formContext.getAttribute("new_htmlrichtext").getValue());
formContext.getAttribute("new_texteditorcontrol").setValue(convertToPlain(formContext.getAttribute("new_htmlrichtext").getValue()));


}

function convertToPlain(html){

    // Create a new div element
    var tempDivElement = document.createElement("div");
    
    // Set the HTML content with the given value
    tempDivElement.innerHTML = html;
    
    // Retrieve the text property of the element 
    return tempDivElement.textContent || tempDivElement.innerText || "";
}

Hope it helps!

Power 365ing as usual!

Other ways to learn with me:

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

Requirement:

Create a Task and Sales Assistant Card for Opportunity Owner and send him 3 Days before the Closing Date of Opportunity Estimated Close Date.

Implementation:

We are going to create a “Schedule Cloud flow” to implement the requirement mentioned above:

• Go to https://flow.microsoft.com(Make sure you are in the correct environment)
• Select Solution -> Open your Solution -> then Select Cloud flows from left navigation pane
• Click on “New” button -> Select “Automation” -> Select “Cloud Flow” -> then select “Schedule Cloud flow”.

• Give Flow Name as “Create a task 3 days before Est Close Date”.
• Enter starting Date and Time when you want to run Scheduled Flow.
• Enter the Duration/Time Interval (Repeat Every) you want run a flow. In this case we want it to run every day so we will select 1 Day.
• Then click on Create.

• Then click on “New Step”

• Select the action as “List Rows”. In our scenario, we are triggering our flow to check if an Opportunity Close Date is in next 3 days, so first we retrieve records of opportunities which will be closed after 3 days.
• Rename the trigger action as “List Opportunity which close in 3 days”.
• Select “Opportunities” under Table name.
• Add Fetch XML of Opportunity Entity under Fetch XML Query.

• Then click on “New Step”.
• Now, add “Apply to each” Condition from Choose an operation -> Control.

• After Select Apply to each Condition, select an output from previous step as VALUE from List Opportunity as shown below.

• Then click on “Add Action” for Creating a Task.

• Then Add a Dataverse Trigger “Add new Row” for Creating a new Task.
• Select “Task” under Table name.
• Select “Topic” which is Opportunity Name from dynamic content under Subject as shown below.

• Add “opportunities(Opportunity GUID)” under Regarding(Opportunities) field, which is Look-Up field in Task.

• For creating a Assistance Insight Card, Select Create Card for Assistance v3 Action as per below Image.

• After Selection Create Assistance card action, fill all required fields as per following Image.
• Select Environment Which we use form drop-down menu.
• Enter card name which we display on Insight card.
• In Card Header section, Write Header for the Card using Task Topic.
• In Card Text, we write detail message for card.
• In Primary Action type we select Option which u want to perform, in our case we select Open record.
• In Primary Action text we write short message which is show in pop up format.
• In Primary Action entity type we select entity on which we require to display a Assistance Card.
• In Primary Action record ID type we select entity on which we require to display a Assistance Card.  

• Then Save the flow and Test flow by selecting Manual Test.

OUTPUT:

Now, check record whose Est. Close Date is after 3 days from today, for which Task should be Created in Timeline of that Opportunity record.

• Now we will Open Form (as shown in highlighted square logo)

• After Opening a Task Record, we can see data is auto populated which we added into the flow along with Subject and Regarding Lookup field.

• After Opening Assistant It gives notification and Insight Card for Opportunity Entity Record which is Closed In next 3 days.

Hope it helps!

Power 365ing as usual!

Other ways to learn with me:

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

Pre-requisites:

• Should have “Customer Service Hub” app installed in your tenant
• Add out of box “Case” entity in your solution
• Create a custom lookup field (Lookup to Queue) titled as “Queue” under Case entity and place it on “Case for interactive experience” form

Requirement:

1. The Queue to which Case is assigned should get displayed under Queue lookup field
2. If we are closing the Case as “Resolved” or “Cancel” – Queue lookup field should be set to null

Implementation:

Now, we are creating an “Automated Cloud flow” to implement above 2 requirements mentioned above:

• Open Solution >> Select Cloud flow from left navigation (Make sure you have selected the correct environment)

• Click on drop-down arrow next to “New” button >> Select “Automation” >> then select “Cloud Flow” >> then select “Automated Cloud flow”

• Now, give name to your Cloud flow and select the trigger action of Microsoft Dataverse i.e., “When a row is added, modified or deleted”. In our scenario, we are triggering our flow if a Case is added to Queue which means whenever a Queue Item has been created under respective Queue. Then, click on Create.

• Rename the trigger action as “Whenever a Queue Item record is created or modified.
• Select “Added or Modified or Deleted” under Change type
• Select “Queue Items” under Table Name
• Select “Organization” under Scope
• Enter “statuscode” (which is logical name of Status field of Queue Item table) under Select Columns

Then click on “New Step”

• Now, select “Get a row by ID” to get Case details and select “Cases” under Table Name and “Object (Value)” under Row ID. Select “New Step”.

• Now, select “Get a row by ID” to get Queue Item details and select “Queue Item” under Table Name and “Queue Item” (unique identifier) under Row ID. Select “New Step”.

• Now, select “Get a row by ID” to get Queue details and select “Queue” under Table Name and “Queue (Value)” under Row ID. Select “New Step”.

• Select the “Condition” and add the condition where if Status (Queue Item) is equal to “0” i.e., Active. If the condition will be true, “Yes” part of the condition will be continued else it will go under “No” part

• Click on “Add an action” under “Yes” part and select “Update a record” action.
  • Select “Cases” under Table Name
  • Select “Case” (Unique Identifier) under Row ID
  • Add “queue(QueueValue)” under Queue field

Scroll down a little and see the option of Queue.

• Click on “Add an action” under “No” part and select “Update a record” action.
  • Select “Cases” under Table Name
  • Select “Case” (Unique Identifier) under Row ID
  • Add null expression under Queue field

Scroll down a little and see the option of Queue.

• You may now save and test the flow.

Testing:

• Create a case record by clicking on “New Case” button.

• Add a Case to Queue by clicking on “Add to Queue” button from ribbon. Here I have a “Test” Queue, so I am using that

• Now, Queue field which is placed under Case form should be auto populated with respective Queue.

• Now, click on “Resolve” or “Cancel” option from ribbon

• Now, check record becomes read-only, and the Queue field is automatically be set to null.

Hope it helps and Power 365ing as usual!

Other ways to learn with me:

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

Business requirement:

Email notification to be sent to all the Queue Members on assigning a Case to Queue.

Solution:

1. Add a step “When a row is added, modified or deleted” then rename it to “Trigger when a Queue item is created” and enter the following details:

Change Type: Added

Table Name: Queue Items

Scope: Organization

2. Add an action “Get a row by ID” and rename it as “GetCaseDetails” – This step is used to get a case record details:

Table Name: Cases

Row ID: Object (Value)

3. Add an action “Initialize Variable” and rename it to “Get all the emails of Queue Members” – This is used to store emails of all the queue members

Name: Queue Members Email

Type: String

4. Add an action “Initialize Variable” and rename it to “Record URL” – This is used to store the URL of Case record

Name: Case Record URL

Type: String

5. Add a condition to ensure when the type of record is case or not.

6. Under “Yes” part of a condition, add an action “List all records” and rename it to “List all members and their emails” – This is used to get all the users (Members) and their emails which we’ll use later. We may first need to fetch XML query.

Table Name: Users

Fetch XML Query:

<fetch version=”1.0″ output-format=”xml-platform” mapping=”logical” distinct=”true”>

<entity name=”systemuser”>

<attribute name=”fullname” />

<attribute name=”systemuserid” />

<attribute name=”internalemailaddress” />

<order attribute=”fullname” descending=”false” />

<link-entity name=”queuemembership” from=”systemuserid” to=”systemuserid” visible=”false” intersect=”true”>

<link-entity name=”queue” from=”queueid” to=”queueid” alias=”ad”>

<filter type=”and”>

<condition attribute=”queueid” operator=”eq” uiname=”Queue Name” uitype=”queue” value=”{@{triggerOutputs()?[‘body/_queueid_value’]}}” />

</filter>

</link-entity>

</link-entity>

</entity>

</fetch>

7. Add an action “Apply to each” and select the “Value” which we are getting from previous step (List all Records) then add an action “Append to String Variable”

under Apply to each and enter following details:

Name: Select “Queue Member Email” variable

Value: Add following expression

concat(items(‘Apply_to_each’)?[‘internalemailaddress’],’;’)

8. Add an action “Send an email (V2)” and enter the required details:

To: Queue Members Email

9. Save the flow and test it.

Hope it helps and Power 365ing as usual!

Other ways to learn with me:

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 help, get in touch here: Click here

Hope it helps and Power 365ing as usual!

Other ways to learn with me:

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 help, get in touch here: Click here

Hope it helps and Power 365ing as usual!

Other ways to learn with me:

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 help, get in touch here: Click here

Hope it helps and Power 365ing as usual!

Other ways to learn with me:

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 help, get in touch here: Click here