Now, just putting an Excel with some crude data in it won’t really be identified in the Canvas App you are making. Perhaps you’re missing something. Let’s say, I want to read an Excel file from OneDrive For Business into my Canvas App, I select the Excel file from the OneDrive for Business connection like … Continue reading Correctly connect to an Excel file in a Canvas PowerApp →

Introduction: Using MS Flows, On any trigger, you can add the below action to rename the SharePoint folder.   Steps: 1) In Actions, select “Send an HTTP request to SharePoint” 2) Enter the below details: Site Address: Select your site address from the list. Method: POST Uri:_api/web/GetFolderByServerRelativeUrl(‘LibraryTitle/CurrentFolderName’)//ListItemAllFields Headers: Accept application/json;odata=verbose X-HTTP-Method MERGE If-Match * Body: … Continue reading Renaming SharePoint Folder using Microsoft Flows →

Introduction: In this blog, we will learn how to filter Gallery based on Combo Box which is on different form.   Use Case: We have a requirement where there is a lookup field (Price List) on the Editform (Data Source: Quote Project Price List). When there is data in the lookup field the Gallery (Data … Continue reading Filter Gallery based on lookup field (Combo Box) on EditForm →

In Dynamics 365 for Retail there are many types of discounts available which retailers can offer to customers. These discounts help the business increase the sales and also the customer base. One of the discounts is called Mix and Match Discount . A mix-and-match discount gives customers a discount when they purchase a specific combination … Continue reading Mix and Match Discounts in Dynamics 365 Commerce (Retail) →

A threshold discount is a discount that is given to customers when the total for a transaction reaches one or more specified amounts. For example, you could create a discount that gives a 10 percent discount for purchases over 100.00 and a flat 25.00 discount for totals over 200.00. You can set it up from … Continue reading Threshold (amount-based) discount in Dynamics 365 for Retail(Commerce) →

After signing up for Zoho People subscription, you can go ahead to configure SAML authentication for Zoho People by adding it as a non-gallery application in Azure AD. While adding the gallery apps or non-gallery apps to Azure AD, one of the SSO options available is SAML based SSO. With SAML, Azure AD authenticates application … Continue reading How to configure SAML authentication in Azure AD for Zoho People? →

Introduction: We had a requirement where we wanted to show the editable grid in power apps. The fields which are suppose to show are of string, decimal and lookup. Other data type was easy to display but we find difficulties in showing the lookup value.   In this blog, we will learn how to add … Continue reading Add lookup fields in an editable grid using PowerApps →

Retail Store Scale Unit allows retailers to sell products within store locations that have internet connectivity issues, where it fails to connect with headquarters (HQ). Retail Store Scale Unit support both Modern POS and Cloud POS within the store. MPOS with Retail Store Scale Unit allows users to perform cross-terminal scenarios across multiple POS devices, … Continue reading Overview of Modern POS with Retail Store Scale Unit (RSSU) →

In this blog I am going to explain you how to create a custom URL for your text column in Power BI desktop. You can create hyperlinks in tables and matrix in Power BI desktop. Before jumping to use a new feature in Power BI desktop, I am showing you how we had done previously. … Continue reading How to use a Custom URL for your text column in Power BI →

Introduction: In this series of Fixed Assets aka FA, I will be teaching you through a life cycle of the Fixed Assets. How to create and acquire these fixed assets, how to depreciate the FA, and how to post transactions on Fixed Assets in Microsoft Dynamics Business Central.   Pre-requisites: Microsoft Dynamics Business Central (ERP) … Continue reading Fixed Asset Management In Business Central →