Sunday 5 March 2023

Dynamics 365 Customer Experience Focus Areas: Functional Consultant (Beginner Level)

As a beginner in Dynamics 365 CE, there are several areas a functional consultant should focus on learning:

  1. Understanding the basics of Dynamics 365 CE: A functional consultant should have a good understanding of the basics of Dynamics 365 CE, including the components and architecture of the system, how to navigate the user interface, and how to use the various features and functionalities.

  2. Data management: A functional consultant should have a good understanding of data management in Dynamics 365 CE, including how to create and manage records, import and export data, and perform bulk data operations.

  3. Customization: A functional consultant should have a good understanding of how to customize Dynamics 365 CE, including how to modify forms, views, and dashboards, and how to create custom fields, entities, and workflows.

  4. Business processes: A functional consultant should have a good understanding of how to model business processes in Dynamics 365 CE, including how to define workflows, automate tasks, and configure business rules.

  5. Integration: A functional consultant should have a good understanding of how to integrate Dynamics 365 CE with other systems, including how to use web services, APIs, and third-party connectors.

  6. Reporting and analytics: A functional consultant should have a good understanding of how to create and manage reports and dashboards in Dynamics 365 CE, including how to use advanced analytics tools and features.

  7. Security and permissions: A functional consultant should have a good understanding of security and permissions in Dynamics 365 CE, including how to configure user roles and permissions, and how to set up data access policies.

By focusing on these areas, a functional consultant can gain a solid understanding of Dynamics 365 CE and be able to effectively design, configure, and manage the system to meet the needs of their organization. 

Friday 18 November 2022

Contextual FAQs for Canvas App

 In this Article, we are going to see how the user will get to know the functionalities available in the current screen (Contextual FAQ). You can create a SharePoint list / Dataverse table to store all the FAQ questions and answers along with the screen name.

In the below app, we have nearly 7 screens. Each screen has  icon, that is used to navigate to the FAQ screen. But the FAQs will be relevant to the screen from where the users came from.


For example, if the user clicks on the Information Icon from home page (image shown above), it will take the user to FAQ screen as shown below


If the user click the Information Icon from contacts screen they will the below set of questions in FAQ screen.

Steps to implement:

FAQ: Questions and Answers are stored in the SP List, that is connected to FAQ Screen in Canvas App. Whenever the user clicks the Information icon, it assigns the Screen Name in the variable varScreenName and that is used in the Filter condition for the FAQ data source in the Gallery items. 

SharePoint List: FAQ



Wednesday 12 October 2022

Can you imagine an AI app can build a Image or animated video for Occasions or Business by just typing what you want?

Microsoft's new AI Powered App help you create rich banner, flyer or animation for your business or occasions.


Just start typing the content for your banner image, then later you can remove or add content to it. Now, you are able to create your own marketing flyers for sharing it in social media.


You do not need to know how to design a banner or flyer, AI will convert all your requirements to create a suitable image for your marketing emails. 

Good news is you can try it just by joining the waiting list. Checkout this link for more details.

Monday 22 November 2021

Home Page Idea for SharePoint Team Site

 In this blog, I have created a sample home page for any SharePoint Team Site. We have to create a Web Part Page in Site Pages document library and edit the page, then select the Full View template. After that you need to add Script Editor webpart. 

Now, copy and paste the below code to the Script Editor webpart, your home page is ready.


<p>&nbsp;</p>

<!-- #######  THIS IS A COMMENT - Visible only in the source editor #########-->

<p style="font-size: 1.5em;">&nbsp;</p>

<table style="height: 541px;" width="487">

<tbody>

<tr style="height: 208.5px;">

<td style="width: 477px; text-align: center; background-color: linen; height: 208.5px;" colspan="3"><img src="https://previews.123rf.com/images/varijanta/varijanta1603/varijanta160300108/54405564-flat-line-design-website-banner-of-about-us-company-information-business-solutions-and-services-mode.jpg" alt="" width="466" height="233" />

<h2>Welcome To The SMBC!</h2>

<p>Here is your content for the website</p>

</td>

</tr>

<tr style="height: 47px;">

<td style="width: 154.969px; text-align: center; background-color: darkcyan; height: 47px;">

<p><img src="https://icon-library.com/images/icon-for-create/icon-for-create-11.jpg" alt="" width="23" height="24" /></p>

<span style="color: #ffff99;"><strong>Create New Request</strong></span></td>

<td style="width: 154.969px; text-align: center; background-color: darkgrey; height: 47px;">

<p><img src="https://cdn-icons-png.flaticon.com/512/84/84380.png" alt="" width="23" height="24" /></p>

<span style="color: #ffff99;"><strong>Create New Request</strong></span></td>

<td style="width: 155.062px; text-align: center; background-color: darkolivegreen; height: 47px;">

<p><img src="https://icon-library.com/images/icon-for-create/icon-for-create-11.jpg" alt="" width="23" height="24" /></p>

<span style="color: #ffff99;"><strong>Create New Request</strong></span></td>

</tr>

<tr style="height: 47px;">

<td style="width: 154.969px; text-align: center; background-color: darkslategray; height: 47px;">

<p><img src="https://icon-library.com/images/icon-for-create/icon-for-create-11.jpg" alt="" width="23" height="24" /></p>

<span style="color: #ffff99;"><strong>Create New Request</strong></span></td>

<td style="width: 154.969px; text-align: center; background-color: darkturquoise; height: 47px;">

<p><img src="https://icon-library.com/images/icon-for-create/icon-for-create-11.jpg" alt="" width="23" height="24" /></p>

<span style="color: #ffff99;"><strong>Create New Request</strong></span></td>

<td style="width: 155.062px; text-align: center; background-color: mediumaquamarine; height: 47px;">

<p><img src="https://icon-library.com/images/icon-for-create/icon-for-create-11.jpg" alt="" width="23" height="24" /></p>

<span style="color: #ffff99;"><strong>Create New Request</strong></span></td>

</tr>

</tbody>

</table>

Monday 5 July 2021

Checking the Date in Filter Query within Power Automate Flow

 In this blog, we are going to see how to compare the due date is today.

Most important thing in the date comparison is Date Format. If it is not matching the right date format then it will endup in error.

The SharePoint field "Due Date" is having the value in "M/d/yyyy" format, so the utcNow() date should also be in the same format, only then we will be able to compare it.

Ex: If the date is "07/06/2021", "MM/dd/yyyy" format will give you the result as "07/06/2021". But if the date format is set to "M/d/yyyy" you will get the date as "7/6/2021". That makes the difference.



The Formula in Filter Query for Due Date is equals to current date should be as shown below:



If you like this post, please do like, share, comment and subscribe.



Saturday 3 July 2021

Send Reminder email for the Tasks nearing Due Date

In this Article, I have explained the business scenario of sending reminder email for the tasks that are nearing the due date. You can try this approach for any type of reminder email. In this case, I have created a SharePoint list using the Work Progress template. Next thing is to create the Power Automate flow to send the reminder email.

Here are the detailed steps for creating the workflow:

Step:1

Create “Schedule Cloud Flow”, that runs during certain time interval as we set in the configuration.



Step: 2

To specify the configuration for the flow.








Step: 3

Adding steps in Flow, Configure the recurrence criteria. Click on the “…” to find the additional options.





Click on the “Settings” button to configure the Time Interval and Frequency.

















Step: 4

Add a new step for SharePoint list to “Get Items” that are matching the criteria of “Due Date” nearing in 3 days from the current date. To achieve this we can make use of the “Filter Query” option as shown below.

 

First formula that compares “Due Date” greater or equals (ge) with current date (utcnow).

Second formula that compares “Due Date” less than (lt) with current date (utcnow) + 3.

Step: 5

Loop thru the list of tasks that are nearing the “Due Date” and send email to the team member responsible for the task (assigned to).



After the selection of “Apply to each”, from the Dynamic content select the value for the output from previous steps.



Then choose an operation for Sending email.


In the Send an email (V2) action, we can configure To, Cc, Bcc, Subject, Body and Attachments also.

Below example has all the parameters filled.





You can also include the link for the Task in the email by selecting “Link to item”.







Step: 6

After completion, you can Save, Check the Flow and finally Test it.






On clicking the “Test” it shows the “Test Flow” pop-up. You can select “Manually” option and click on the “Save & Test” button.











Output: 

Finally the Flow runs successfully and email is sent to Assigned To person.

Wednesday 30 June 2021

Event Registration Form using Microsoft Forms

 In this article, I have tried to give the steps to create the sample Event Registration form. It does not require any code. Without any coding knowledge this can be done.

Pre-requisites: You need to have Office 365 subscription and there is no license needed for Forms, it’s free.

When you login to the Office 365, you have thisicon in the left top corner of the page. It’s called waffle icon. On clicking it you can see all the app that you have permission. In that you will find the Forms (highlighted in the below image).



 To load the Forms click on it. Now you will see the below screen that has “+ New Form” button. Use the new form button to create the Event Registration Form.



Once click the New Form button you will see the blank form with options to create questions and header for the form as shown below.



You need to create as much question as you want to know about the person who wants to enroll themselves for the Event. In this example, I have just created 4 questions like Full name, Email address, Organization and Job Title.

It’s easy to add questions, just you need to click the “+Add Row” button as shown in the below picture.

 



There are some suggestions shown while you are trying to create questions. That’s cool isn’t. You can select from the suggestions list and click “Add selected”. It will be added to your form.

You also have provisions to change the response (Answer) type like choice, text or date etc.

Once you are done with the questions, you need to share it. Before that if you would like to change some setting like who are allowed to enroll for this event, For example: people within the organization or outsiders can also enroll for it. In the right top corner of the page you have Preview, Theme and Share Options also. On clicking the “” you will the menu that contains Settings.



Preview Mode: You can see how the Form looks in Mobile and Desktop view.



Settings: When you go to settings, there are options given for “Who can fill out this form”, there you can select the options according to your need.  Anyone can respond can selected if you are expecting the responses from outsiders also (not part of your organization, they don’t need to login). Anyone from your organization can enroll (respond) if you select “Only people in my organization can respond”. You can also set “only specific people within your organization” can enroll (respond) for it.

Start and End date: You can also set duration from when we can start getting the enrollment (responses) till which date (last date to get the responses).



Theme: There are some list of themes available, you can select anything from the available themes.



Share: After all these, now it’s time to share the Event Registration for to targeted audience. Click on the “Share” button. You have different options like sharing it as short url, QR code, Embedded HTML tag, Email.



 

Responses: Finally now you wish to see how of them enrolled for the event. Check the below options you have for responses. You can also view the results one by one and export the results in Excel on clicking the “Open in Excel” link.



How does the Event Registration form look like?

 Here it is.



 

Now you learnt how to create enrollment form, same steps has to be followed if you wish to create Polling, Survey or Feedback.

Scenarios to use Virtual Table in Dataverse (Power Platform)

Virtual tables in Dataverse provide a way to access extern al data sources without requiring data replication or synchronization. Here are...