Read items from Array in Power Automate

Let us consider we have array [1,2,3] and want to read each value in Power automate. Let see how we can read array in Power Automate Step 1- Create array (here you can use your array) Here I have array [1,2,3] and now I want read each value of array in loop Step 2 – Add … Continue reading Read items from Array in Power Automate

Share Story :

Reopen Closed Appointment Using JavaScript in D365 CRM

Introduction: When an appointment is closed in D365 CRM, the appointment is not editable. There can be a requirment when Users wish to edit the closed appointment and add some missing data. This can be achieved by adding a new button on the Appointment form. Solution: Add a new button and use below JavaScript. var … Continue reading Reopen Closed Appointment Using JavaScript in D365 CRM

Share Story :

C# Code to retrieve lookup value id from target entity in D365 CE.

Let us consider below example as use case We have Plugin that triggers on Update of Contact Table and wanted to retrieve Customer related to Contacts. Customer is Lookup field on Contact Table. Hence here our target entity is Contact. Code – Entity targetEntity = (Entity)context.InputParameters[“Target”];   Guid ContactId = targetEntity.Id; Using the above code … Continue reading C# Code to retrieve lookup value id from target entity in D365 CE.

Share Story :

How to unapply/reverse payments from vendors in Business Central?

 There are certain scenarios where you have mistakenly applied the payment to the wrong vendor or you need to refund the vendor. There are two methods in order to resolve these issues. Steps to achieve the goal: Method 1: Globally search vendors. Select the vendor in which payment is applied incorrect. Go to Vendor Tab-> … Continue reading How to unapply/reverse payments from vendors in Business Central?

Share Story :

How Caching Works in Business Central

References: Data Access – Business Central | Microsoft Docs Database.SelectLatestVersion Method – Business Central | Microsoft Docs Explanation: Caching is one of the methods which systems use to improve performance and respond to requests rapidly. In a Business Central system, caching is done at two levels: Business Central Server Instance Data Cache SQL Server Data … Continue reading How Caching Works in Business Central

Share Story :

Create attachments in SharePoint when email arrives

Use case – we wanted to retrieve attachment when new email arrives in outlook and create same file in SharePoint Let see how we can achieve this! Step 1 – Flow triggers on when a new email arrives trigger from Outlook connection. Step 2 – Retrieve attachments and Create file in SharePoint. Add step create … Continue reading Create attachments in SharePoint when email arrives

Share Story :

How to work with Drop Shipments in Business Central?

Introduction: Drop shipment is used when the shipping on the items is done from the vendor directly to the customer without the item coming back home to your warehouse and you delivering them. Steps to achieve the goal: To do so first create sales order and then add field drop shipment which is of boolean … Continue reading How to work with Drop Shipments in Business Central?

Share Story :

How to list all dates between two dates in PowerBI and distribute numbers evenly among them.

Posted On August 2, 2021 by Jaison Menezes Posted in Tagged in , ,

Consider a scenario where a start and end date along with the total duration for a particular task has been given to us. We have to distribute the total duration equally among all dates between the start and end date. We can solve this issue by the combination of Power Query and DAX. Lets see … Continue reading How to list all dates between two dates in PowerBI and distribute numbers evenly among them.

Share Story :

Using Partial Records in Business Central

Introduction: Business Central allows us to load records partially, i.e. only certain fields from a table which can be defined by the User. As this requires less data to be pulled out from SQL and similarly less data to be sent over the network, using partial records provides a significant performance gain. Even more so … Continue reading Using Partial Records in Business Central

Share Story :

[Resolved]You don’t have permission to view files in this location, Contact your Microsoft team owner or SharePoint administrator for access.

We added a new User in CRM, User has the System Administrator role but still were getting the below error. You do not have permission to view files in this location, Contact your Microsoft team owner or SharePoint administrator for access.  We did check User’s SharePoint access and, but it did not work. Solution – … Continue reading [Resolved]You don’t have permission to view files in this location, Contact your Microsoft team owner or SharePoint administrator for access.

Share Story :