Efficient data cleaning is a crucial step in any data preparation process, and Power Query makes it easy to handle common tasks like trimming and removing unnecessary spaces with functions that you can apply across multiple columns and queries at once. By creating and invoking a function, you can quickly trim and remove spaces from … Continue reading How to Trim and Remove Spaces from Multiple Columns in Power Query →

Uploading documents to Dynamics 365 through mobile devices can enhance the flexibility and efficiency of your team members. In this blog, I’ll Walk you through a step-by-step procedure for uploading documents using the **Sales Team Member** app on mobile devices. This guide focuses on document upload via the mobile version of Dynamics 365, showcasing how … Continue reading Streamlining Document Uploads for Entities by Sales Team Members Using the Mobile Application →

Uploading and managing quotes efficiently is crucial for Dynamics 365 CRM users. However, sometimes you may want to restrict certain buttons, such as the ‘+New’ Quote button, to only users with specific roles, like the “System Administrator.” In this guide, I’ll walk you through how to achieve this by leveraging JavaScript and the Ribbon Workbench … Continue reading How to Display the ‘+New’ Quote Button Only for System Administrators Using JavaScript and Ribbon Workbench in Dynamics 365 CRM →

Managing inventory is an important part of any business, and keeping track of stock levels is key to smooth operations. Negative inventory happens when your system shows that you have less than zero items in stock. This can cause problems like delays, mistakes in finances, and unhappy customers. Luckily, Dynamics 365 Finance & Operations (D365F&O) … Continue reading Avoiding Negative Inventory: Tips and Tricks in D365 F&O →

Introduction: Creating a tenant in Microsoft Entra-ID or Azure Active Directory (AAD) is a simple process that can be accomplished through the Azure portal. The portal serves as a centralized hub for managing Azure Active Directory and executing various administrative tasks, including the creation of a new tenant. Additionally, this blog will cover how to … Continue reading Tenant Creation and User Permissions for Business Central using Azure Portal →

Introduction: HTTP (Hypertext Transfer Protocol) is a protocol used for communication between web servers and clients. When a client sends a request to a server, it is called an HTTP request. The request consists of a request line, headers, and an optional message body. The request line contains the HTTP method, URL, and HTTP version. The headers contain additional information about the … Continue reading Get and Post Method in Business Central →

Introduction Hello everyone, Today we are going to create list page and we will attached same to the any master (Ex. Item) page. When user will enter data into list page, Primary key of master and Line no will automatically get inserted. Pre-requisites Business Central on Cloud VSCode Steps: 1. Creating Table and Page First … Continue reading How to create list page and link with master page in Business Central →

In this blog, I will show you how to resolve the below error Popping up on the POS screen while paying through the payment method  Customer Account. The following Screenshot shows the Actual error. Here’s the Solution for the Above error. Step 1: Copy the Customer No (In this case SS-276508) Step 2: Open HQ … Continue reading Error on POS Payment method ” The payment information is either missing information or it is incorrect →

Many of us who are using SharePoint Online for Document Management as using the manual method for syncing the Document Libraries on our devices. Here we can leverage Intune Administrative Template. Administrative Templates are responsible to facilitate the management of registry-based policies that allows configuring many settings on Windows machine. With the availability of these … Continue reading How to silent sync SharePoint Team Sites Library using Intune →

Sometimes after extracting data from certain data sources in JSON format we have to format and make this data easily readable so as to send this data via Microsoft teams or email. In this blog I will format a sample JSON code into a HTML table Since I am not using a data source, I … Continue reading How to use Create HTML Table block in Azure Logic Apps to format JSON data →