Blog Archives - Page 30 of 130 - - Page 30

Category Archives: Blog

Delete multiple CDS records from Grid using PowerApps.

Introduction: In this blog, we will learn how to Delete multiple records of CDS from the Grid.   Use Case: We have a requirement where there is a Grid of CDS Data Source, on clicking the Delete Icon on top of the Grid, it should delete every record which is selected through the checkbox which … Continue reading Delete multiple CDS records from Grid using PowerApps.

Share Story :

Hide certain Field of the form depending on Security Role of the User using PowerApps.

Introduction: In this blog, we will learn how to hide fields from the form based on the Security Role of the Logged in User. Use Case: We have a requirement where there are some Fields in the form, which should be hidden to the users who does not have the Security Role as Manager. Steps: … Continue reading Hide certain Field of the form depending on Security Role of the User using PowerApps.

Share Story :

Filter a Lookup Field on New Form Using PowerApps.

Introduction: In this blog, we will learn how to filter a Lookup Field on the New Form. Use Case: We have a requirement where there is a Lookup Field on the form, which should only show those values whose Status is Active. Steps: 1. This is the form of Quote Product. We want to filter … Continue reading Filter a Lookup Field on New Form Using PowerApps.

Share Story :

Purchase order approval through a Mobile device in Microsoft D365 Fianance and Operations

In this blog I am going to explain in brief about  the Purchase order approval mobile workspace. This workspace lets you view purchase orders and respond to them through actions. For example, you can approve or reject a purchase order. After a purchase order (PO) has been created, it might have to go through an approval … Continue reading Purchase order approval through a Mobile device in Microsoft D365 Fianance and Operations

Share Story :

How to Upsert Records in SQL(Sink) through ADF?

Introduction We are performing Integration of Accounts from CRM to SQL using ADF Copy activity pipeline. We want to upsert the accounts instead of inserting duplicate records again. Step 1: Auto create the Table named “accounts” in SQL Server during the first Integration run by selecting the Auto create table option.   Step 2: Create … Continue reading How to Upsert Records in SQL(Sink) through ADF?

Share Story :

x++ code to import data from excel to D365 FnO

We can also import data through code in D365 FO. Data import through code in D365 works differently than Ax2012 since cloud services.  Import Class we are trying to import data from Excel to D365FO through the following code.   using System.IO; using OfficeOpenXml; using OfficeOpenXml.ExcelPackage; using OfficeOpenXml.ExcelRange;   class EmplAttendance { public void run() … Continue reading x++ code to import data from excel to D365 FnO

Share Story :

Customize Purchase order approval status

In the case of D365 Finance and Operations when you approve purchase requisition by default system creates Purchase order with approval status as “Approved” as follows     To change this default behavior of system such that once purchase requisition is approved the approval status of the purchase order as a draft you can use the … Continue reading Customize Purchase order approval status

Share Story :

Steps to Configure Environments through Life Cycle Services (LCS)

Configuration of Environment through LCS. After we purchase licence, Login the LCS through Admin account. You can see the follow link to complete setup environment. Before configuring the environments there are some pre-requisites need to be performed. Declaration of project milestone. Click on setup milestone, Enter the end date for each milestone and save. 2. … Continue reading Steps to Configure Environments through Life Cycle Services (LCS)

Share Story :

Nested Filters in PowerApps.

Introduction: In this blog, we will learn how to use Nested filters in PowerApps. Use Case: We have a Gallery(GalleryQuoteLineDetail) where we need to put filter which equals Quote Product selected in another Gallery. Once we get those Quote Products, we need to filter the Gallery(GalleryQuoteLineDetail) based on ‘Transaction Type’ Field,  which is a field … Continue reading Nested Filters in PowerApps.

Share Story :

How to increase OneDrive for Business storage up to 5TB

You must have known that OneDrive for Business storage has a limitation of 1TB but what if you have utilized the full capacity (1TB). There is no such announcement for the same, but the limit is not 1TB. In this article, we will see how we can increase the storage capacity for OneDrive for Business … Continue reading How to increase OneDrive for Business storage up to 5TB

Share Story :