At times, end users are used to working with Advanced Find a lot without having much control over what they can customize. Because for obvious reasons, they are users. And not someone who customize the system. In this case, they might also not know what they can’t search for in the Advanced Find and are led into believing that all the fields are being shown. And they could even wonder why it doesn’t appear in Advanced Find when they can see it on the Form/View. However, there’s a configuration which can either hide/show the fields in the Advanced Find. Making Fields Searchable So this is the answer. If fields are not Searchable, they don’t appear in Advanced Find Advanced Find field list with the missing field   And, when the Searchable is set to Yes, they appear in the Advanced Find. Advanced Find showing the Searchable enabled field   So that’s why. Hope this helps!

Business Use Case: Often there are team members who share the need of getting allocated on schedule board in Dynamics 365 Project Services Automation directly as soon as they book an appointment or have a meeting invite. One of the reasons for the same is for the team or anyone concerned about allocation to understand that the said team member is either having a meeting with someone or has an appointment. Hence, they do consume some time of the day. This is one of the reasons that I get when I think aloud. Since, there is lot of argument and justification the team needs to provide for these additional non-billable time that they spend. There can be many other reasons as to why this is needed by other organisations. Mitigation: Though there is an (Out of the Box) OOB solution for marking an appointment in Outlook calendar from Schedule Board, but, vice-versa is not provided OOB. MS Flows helped me here. I created a flow between Bookable Resource Booking entity and Outlook entity in Flows. I have explained the steps as to how to do the same. Steps: Step 1: Login to https://portal.office.com with your credentials. Step 2: Click on Flows as shown in below image. Step 3: This will take you to the portal where you can mange and create all your Flows: Step 4: Click on +New. Step 5: Click on Create from Blank. Step 6: Click again on Create from Blank. Step 7: Select the Outlook connector by searching the Outlook 365 Connector from the search box as show in the image below. Also, select the Triggering event on when the flow should be triggered. So we selected, When a new event is created (v2). Step 8: Select Calendar id as Calendar. Step 9: click on next step. Step 10: Select the target connector i.e. Dynamics 365 by searching in the connectors. Step 11: Click on create a new records. Step 12: Select the Organisation and the Entity where you want to create a record. Since the booking that shows up on the schedule board comes from Bookable Resource Booking, we shall select Bookable Resource Booking. Step 13: Add the mappings to the fields as shown below, by searching them from the right pane. Step 14: Once done, click on save and your flow is ready. Step 15: Once created do not forget to Turn it On. Test it by creating an event in calendar and see in the event history of the flow whether it is successful or not. Conclusion: This blog reflects my personal findings and based solely on my experience of using PSA for last 3 years. For those who are looking for a platform that can track and manage the entire procedures of sales and project managements, I would highly recommend them to try Microsoft dynamics 365 for project service automation. According to my opinion, implementation of Microsoft dynamics 365 for project service automation is one of the best things that we did in CloudFronts Technologies. We have gained a lot with this implementation because we save time and money due to easy access resources and ability to manage them.

Introduction: With update of Microsoft dynamics many new exiting features has been introduced in Dynamics 365 sales one them is Unified Interface with Navigation. By default, form December organization will start receiving the new UI. But if you are still interested you can enable it by yourself. Description: To enable the UI navigation you need to have organization Id, You will find the organization id can be found at Developer resource. To get the organization id you need to follow the below path 1. Go to setting -> customizations -> select “Developer Resource”. Highlighted in red is the organization Id. Once you have organization id you need to execute a small script in developer script console. To do so you need to press key F12. Also you need to make sure that you are logged in to the same system where you want to change the UI. You can see that navigation has change from old to new UI. Conclusion: Hope this blog help you to use make UI look and feel more better and comfortable

Introduction: With update of Microsoft dynamics new exiting features has been introduced in Dynamics 365 sales one them is Reference Panel. Description: While putting the Quick create or any subgrid in a section extra space gets added which looks weird. Most of us has feel the same situation. But with the introduction of “Reference Panel” we can now overcome this issue. Solution Let’s start with adding a reference section and view 1. Go to setting -> customizations -> select “Customize the System”. 2. Open the account entity Form. Now you can add the Reference panel by adding the section. If you try to add more than 1 Reference Panel you will receive below error. After adding the reference panel, you will not be able to identify the which one is the general section or reference. There is only way to know if it is reference panel, as name of reference Panel is generated by default as you can see in the below screen shot. I have added below two grids on account record. After adding you need to save and publish. Now go to account record and refresh the page you will able to see the sections with no extra space as you can see in the below screen shot. Conclusion: Hope this blog help you to use reference panel wisely.

Introduction: Microsoft has introduced a new platform to access the different app and analytics. You can access your different environment. 1. Power BI 2. Power apps 3. Flow Currently you might have opened few cases using this platform but there are lot more than that we can do. This is in preview mode can be available soon. Description: You can open the portal using below given URL “https://admin.powerplatform.microsoft.com/.” Once you open the portal you will be able to see the default page shown below. As you seen in the above screen shot it show open cases. Navigation menu As you can see the navigation menu contains the familiar components. Help and support This contains the cases open with Microsoft. Analytics This shows the analytics or various apps Environments User can easily navigate to the respective environment, as you can see in the below. Analytics Below details which can be viewed from the Common Data Service. Common Data Service Microsoft Flow As I don’t have any flow it is not showing anything. PowerApps Data policies You can develop your own data policies. Admin center You can navigate to the various application from the admin Center. Dynamics 365 Thi will navigate you to the Dynamics 365 instances. Microsoft Flow This will take you to the Microsoft Flows apps. Power Apps This will take you to the Apps associate with you organization. PowerBI You can view your PowerBI Reports.

Introduction: After the introduction of web API in CRM, user can execute all the requests which is possible through C# or JavaScript. In this blog I will explain how to attach a document to record using the postman. Description: Notes attachments has been tested with a custom entity and tested on Postman. To work this, you can follow the below blog to get the Access code. https://www.magnetismsolutions.com/blog/johntowgood/2018/02/12/dynamics-365-online-authenticate-with-user-credentials METHOD: POST URL: https://instancename.crm.dynamics.com/api/data/v9.1/annotations Authorization: Header: Content-Type:application/json In Authorization select the type Bearer Token Type and pass the token value which we got before. Body: You need to pass the below 4 parameters with value. Key Value subject   Filename   objectid_cf_document@odata.bind   documentbody   Json Body: { “subject”: “Test From Web API”, “filename”: “Untitled2.png”, ” objectid_cf_document@odata.bind “:”/cf_documents(23e6ee7c-5812-e911-a96b-000d3a3638df)”, “documentbody”:”iVBORw0KGgoAAAANS……….” } CODE: Postman Description: Image attached you need to pass it as base64 string as document body. var settings = { “async”: true, “crossDomain”: true, “url”: “https://instancename.crm.dynamics.com/api/data/v9.1/annotations”, “method”: “POST”, “headers”: { “Content-Type”: “application/json”, “Prefer”: “return=representation,odata.include-annotations=\”OData.Community.Display.V1.FormattedValue\””, “Authorization”: “Bearer eyJ0eXAiOiJKV1QiLCJhbGci………………………..”, “cache-control”: “no-cache”, “Postman-Token”: “b57b2d5b-c8d5-4f26-abf0-a3ea1f499637” }, “processData”: false, “data”: ” {\r\n \t \”subject\”: \”Test From Web API\”,\r\n \”filename\”: \”Untitled2.png\”,\r\n \”objectid_cf_document@odata.bind\”:\”/cf_documents(a60fbc96-f00f-e911-a96b-000d3a3638df)\”,\r\n \”documentbody\”:\”iVBORw0KGgoAAAANSUhEUgAAAe8AAAE8CAIAAABmQa4bAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAAEnQAABJ0Ad5mH3gAAM2SSURBVHhe7P0HtCTHeSaIVqUtb2/dquu9ap+9JywAz87LbUdPubNjmbNzmatjmatxZHhxDAthtnMPDSe51EU1C52S3dcjAwMDA8L4hx9qM9Vj3FhQwdK20PKXEZw1D453rlLydl8RAtathuyPWJoXqpHCdo67TWdcteEJEiZtBzN+YPX1JSgy5wijzzx33aq5oC8xKr3THqD8k0Ab576aVAZTjfpqoHTyJwJBq6cCvlXgufY+1px6+rqallZ2djPfhiZ7Eon3JHmn+Qdbrb7Lgd+/9PFjWruLHG+8X89zn7vmT8EV82uF37isV6e+OdfhyZv/pJig5D1w5L/ut/Q8RPvpStR4bjzxf+BzJN/+E1ofNTgaRXa/r7imDP+T/+wOtCefkM05TGGwW8ZBF1VoOl9x/5hezVPr1IoFArlEWEbNT9z5nR69WvBbN72G3UUykNNJEKHOigPO1vfFkKhUCiURxGq5hQKhfJtgKo5hUKhPPoYDP8fI9Uy7N6b03EAAAAASUVORK5CYII=\”\r\n }” } $.ajax(settings).done(function (response) { console.log(response); }); In the above code I have posted- Post Request Response

Introduction: Sometimes it is required to share the certain documents with outside users. It is possible that user can share that document as hard copy. If that document is hosted on SharePoint user can make a shareable link. Description: Sharing a document to the outside users are possible via directly going to SharePoint and creating a shareable link. But what if you want to generate a shareable link using the C# code. You can follow below code to generate shareable link in Online SharePoint. 1. Get the link You need to pass the document link to below function as shown. currentLink = https://organization.sharepoint.com/cf_car/JTN_89330b3c-beb5-e811-a968-000d3a324f4c/Untitled2.png 2. Get the base url of your SharePoint and generate the service context using (var context = new ClientContext(Model.SharePointBaseURL)){} 3. Authenticate the user foreach (var c in Model.AdminPassword) passWord.AppendChar(c); context.Credentials = new SharePointOnlineCredentials(Model.AdminUserName, passWord); 4. CreateAnonymousLink method which will generate the shareable link var orgEditLink = Web.CreateAnonymousLink(context, currentLink, true); 5. Execute the query context.ExecuteQuery(); 6. Finally get the public link editUrl = orgEditLink.Value; Complete code: private static string UpdateLinkTOShareable(string currentLink, Entity document) { string editUrl = string.Empty; using (var context = new ClientContext(Model.SharePointBaseURL)) { var passWord = new SecureString(); foreach (var c in Model.AdminPassword) passWord.AppendChar(c); context.Credentials = new SharePointOnlineCredentials(Model.AdminUserName, passWord); try { var orgEditLink = Web.CreateAnonymousLink(context, currentLink, true); context.ExecuteQuery(); editUrl = orgEditLink.Value; } catch (Exception ex) { } /*Code to make link Public End*/ return editUrl; } }

Introduction: In Business Central, to send an Email the sender Email is always the user in SMTP Setup. But, what happens when you are sending email from <admin@yourorganization.com> but should be going department wise ie. <sales@yourorganization.com> and <marketing@yourorganization.com>. Thus in this blog I’ll be showing how to send email from the department email using the admin email. Pre-requisite: 1. VS Code. 2. Office 365. 3. Microsoft Dynamics Business Central. 4. MS Flows. Demonstration: 1. Setting Up MS Flows: Creating the HTTP request: Using Sample Payload as : [{ “sender”:”Test Sender”, “recepient”:”Test recepient”, “subject”:”Test Subject”, “body”:”Test body” }] Add the  Send an Email action: Save the MS Flow and copy the trigger URL in  Postman and passing JSON, check if you the email. Check mail box for delivery of Email 2. Enable email delegation in Office 365. In portal.office.com, navigate to Admin > Admin Center > Exchange > Mail boxes > <–Admin Email–> > Delegate Add you department email here. In this cas Cloudfronts@xyz.com is admin email and olisterr@xyz.com is department email. 3. Call the MS Flows from Business Central. Code: 4. Output Conclusion: Thus in this way we can use MS Flows Webhooks to actually trigger an email passing the data through JSON as an POST http request.

Sorting can be used for defining an order direction for your Custom Visual. There are 3 different ways using which you or a user using your visual can sort your visual. They are as follows: Default Sorting: This is the easiest sorting option and gives users the ability to sort the visual by any field used in the visual. The following code needs to be added to the capabilities.json file.  “sorting”: { “default”: { } } After this the user will get the below sorting option: Implicit Sorting: Implicit Sorting can be used for pre-defining your sorting order in your capabilities.json file. Here, the user cannot manually change the sorting order. This can be done with the following code block where direction 1 is ascending and 2 is descending. Role is the data mapping name for which you would like to define your sorting. “sorting”: {         “implicit”: {             “clauses”: [                 {                     “role”: “category”,                     “direction”: 1                 }                 ]         }     } Custom Sorting: Custom sorting can be used for defining sorting in your visual.ts file and not in the capabilities.json file. Since you are defining your sorting order in your code, you can use various different logics to define your sorting(For example, you can define a formatting toggle option in the format pane that will sort the visual when turned on). A simple codeblock that can be used for sorting your datapoints in ascending order is as follows. sort((obj2, obj1) => { if (obj2.category< obj1.category)  return -1 else return 1; }); With so many options available, it is pretty easy create a visual just the way the user wants.

Business Use Case: Often there are team members who share the need of getting allocated on schedule board in PSA directly as soon as they book an appointment or have a meeting invite. One of the reasons for the same is for the team or anyone concerned about allocation to understand that the said team member is either having a meeting with someone or has an appointment. Hence, they do consume some time of the day. This is one of the reasons that I get when I think aloud. Since there is a lot of argument and justification the team needs to provide for these additional non-billable time that they spend. There can be many other reasons as to why this is needed by other organizations. Mitigation: Though there is an (Out of the Box) OOB solution for marking an appointment in Outlook calendar from Schedule Board, vice-versa is not provided OOB. MS Flows helped me here. I created a flow between Bookable Resource Booking entity and Outlookentity in Flows. I have explained the steps as to how to do the same: Steps: Step 1: Login to https://portal.office.com with your credentials. Step 2: Click on Flows as shown in below image Step 3: This will take you to the portal where you can manage and create all your Flows: Step 4: Click on +New Step 5: Click on Create from Blank Step 6: Click again on Create from Blank Step 7: Select the Outlook connector by searching the Outlook 365 Connector from the search box as shown in the image below. Also, select the Triggering event on when the flow should be triggered. So we selected When a new event is created (v2) Step 8: Select Calendar id as Calendar Step 9: click on next step Step 10: Select the target connector i.e. Dynamics 365 by searching in the connectors. Step 11: Click on create new records Step 12: Select the Organisation and the Entity where you want to create a record. Since the booking that shows up on the schedule board comes from Bookable Resource Booking, we shall select Bookable Resource Booking. Step 13: Add the mappings to the fields as shown below, by searching them from the right pane. Step 14: Once done, click on save and your flow is ready. Step 15: Once created do not forget to Turn it On. Test it by creating an event in the calendar and see in the event history of the flow whether it is successful or not. The End. This blog reflects my personal findings and based solely on my experience of using PSA for the last 3 years. For those who are looking for a platform that can track and manage the entire procedures of sales and project management, I would highly recommend them to try Microsoft dynamics 365 for project service automation. According to my opinion, the implementation of Microsoft dynamics 365 for project service automation is one of the best things that we did in Cloud Front Technologies. We have gained a lot with this implementation because we save time and money due to easy access resources and ability to manage them.