Manage CDS Entity Data – Microsoft PowerApps Office Add-In – Bansal Blogs – Dynamics 365, PowerApps, Microsoft Flows, Power BI
Nov03

Manage CDS Entity Data – Microsoft PowerApps Office Add-In – Bansal Blogs – Dynamics 365, PowerApps, Microsoft Flows, Power BI

Microsoft PowerApps Office Add-In enables user to read, modify and insert data in CDS environment. Add-In is available for download here for free, or you will be prompted to install Add-In for first time when you open entity data in excel from PowerApps portal. Add-In establishes connection to PowerApps OData service. Note: Add-In is compatible with Office 2016 or later versions… Continue Reading Sachin Bansal’s Article on...

Read More
PowerApps – New Functions Introduced – GUID, Concurrent & Notify – Bansal Blogs – Dynamics 365, PowerApps, Microsoft Flows, Power BI
Oct30

PowerApps – New Functions Introduced – GUID, Concurrent & Notify – Bansal Blogs – Dynamics 365, PowerApps, Microsoft Flows, Power BI

Microsoft has released many new features and enhancements for PowerApps since June 2018, part of this blog we will cover three new functions introduced which I believe would be mostly used. GUID Function: In my blog, I mentioned how to generate unique GUID using Azure function which requires us to create an azure function, a custom connector and connection between two. Microsoft has… Continue Reading Sachin Bansal’s...

Read More
The request channel timed out while waiting for a reply after 00:01:59.9396415. Increase the timeout value passed to the call to Request or increase the SendTimeout value on the Binding.
Oct29

The request channel timed out while waiting for a reply after 00:01:59.9396415. Increase the timeout value passed to the call to Request or increase the SendTimeout value on the Binding.

We have SSIS jobs which retrieve incremental data from Dynamics CRM 365 and run every 2 hours. Recently we observed few jobs were failing with request channel timed out error. We figured out that these jobs were pulling data for entities with very high data volume. One of the entity was annotation since we are capturing loads of notes. We are using script component in SSIS package… Continue Reading Sachin Bansal’s Article...

Read More
PowerApps – Secure your Azure Function and Custom Connector with Azure AD – Bansal Blogs – Dynamics 365, PowerApps, Microsoft Flows, Power BI
Aug23

PowerApps – Secure your Azure Function and Custom Connector with Azure AD – Bansal Blogs – Dynamics 365, PowerApps, Microsoft Flows, Power BI

In my previous blog, I explained how to create an Azure Function and consume it in PowerApps using custom connector but it was not secured (anonymous) and anyone can access this API using function URL. In this blog we will see how to secure Azure Function API and register PowerApps custom connector in Azure Active Directory. Below steps will be covered as part of this blog: Secure… Continue Reading Sachin Bansal’s Article...

Read More
PowerApps – CDS for Apps – Generate Unique GUID using Azure Function – Bansal Blogs – Dynamics 365, PowerApps, Microsoft Flows, Power BI
Aug18

PowerApps – CDS for Apps – Generate Unique GUID using Azure Function – Bansal Blogs – Dynamics 365, PowerApps, Microsoft Flows, Power BI

There are many scenarios where we need to generate unique GUID whenever user performs certain action. One of the main scenarios is to link child records with parent records when app is in offline mode. In relationship model, child is linked to parent through Lookup which is complex object and combination of ID and Text fields. When app is online and connected, this ID is… Continue Reading Sachin Bansal’s Article on their...

Read More
PowerApp – Error while creating Connection to Custom Connector – “The reply url specified in the request does not match the reply urls configured for this application”
Aug13

PowerApp – Error while creating Connection to Custom Connector – “The reply url specified in the request does not match the reply urls configured for this application”

I have an azure function which returns unique GUID every time its invoked. My azure function is Azure AD Authenticated which means users under my AD account only will be able to it and no separate authentication token/key is required. To enable Azure AD Authentication, you have to register your Azure Function API as well as PowerApp custom connector in Azure AD under App… Continue Reading Sachin Bansal’s Article on their...

Read More
PowerApp CDS – Multi Select Items in Gallery using Checkbox – Bulk Activate and Deactivate records – Use of Patch vs ForAll
Aug06

PowerApp CDS – Multi Select Items in Gallery using Checkbox – Bulk Activate and Deactivate records – Use of Patch vs ForAll

In my previous blog, I explained how to filter active and inactive records based on value selected in drop down. In this blog we will see how we can select multiple items in Gallery and activate or deactivate bulk records. We will cover below as part of this blog: Add Checkbox control to Gallery list Create a collection and add selected item in collection when checkbox is… Continue Reading Sachin Bansal’s Article on their...

Read More
Centrally Manage Your PowerApp Styling – Bansal Blogs – Dynamics 365, PowerApps, Microsoft Flows, Power BI
Jul27

Centrally Manage Your PowerApp Styling – Bansal Blogs – Dynamics 365, PowerApps, Microsoft Flows, Power BI

For my last PowerApp project I wanted to create a setup where the styling is centrally managed for the PowerApp. I did not found a method yet online but this blog: Giving Consumers Color and Text Size Configuration Options from Audrie Gordon explained how to load the styling from a collection in the app. This is a great method. And I thought wat if I store my styling information in a… Continue Reading Sachin Bansal’s...

Read More
PowerApp – CDS for Apps – Filter Active/Inactive records in Gallery based on drop down selection
Jul13

PowerApp – CDS for Apps – Filter Active/Inactive records in Gallery based on drop down selection

In this blog we will see how to filter records on record status based on value selected in drop down. In Dynamics 365 we can configure views with different filter conditions. In PowerApps there is no view concept but based on value selected in drop down list, we can filter records in Gallery list or data table. This behavior can be extended further to replicate view concept in… Continue Reading Sachin Bansal’s Article on...

Read More
How to build reusable code snippets in Microsoft PowerApps – Bansal Blogs – Dynamics 365, PowerApps, Microsoft Flows, Power BI
Jul10

How to build reusable code snippets in Microsoft PowerApps – Bansal Blogs – Dynamics 365, PowerApps, Microsoft Flows, Power BI

Based on the current evolutionary state of this great new cross platform Office 365 focused application service, it is very difficult to built reusable code snippets in Microsoft PowerApps so we don’t have to cut and paste code all over the application.  While this might not seem like a big deal in smaller applications, but larger and more complex applications quickly become impossible to… Continue Reading Sachin Bansal’s...

Read More
PowerApp – CDS for Apps – Remove items from Gallery list – Add Delete Button in Gallery control
Jul08

PowerApp – CDS for Apps – Remove items from Gallery list – Add Delete Button in Gallery control

Thanks to Audrie Gordon for such a nice video on PowerApp hacks. One of hack was related to how to extend Gallery list control to make it editable. On same lines, in this blog we will see how to add delete button to Gallery list which will remove item from list. Select Gallery control, expand Icons under Insert tab and click on Trash icon to add it to Gallery control Align icon to… Continue Reading Sachin Bansal’s Article...

Read More
Common Data Service for Apps – Export/Import CDS Customizations across Environments
Jul03

Common Data Service for Apps – Export/Import CDS Customizations across Environments

Currently there is no easy or standard way to move customization changes across environments from PowerApp web portal. Only way to export and import CDS customizations (Entities, Business rules, Apps) is by exporting CDS solution from Dynamics 365. Before we look into how to achieve this, lets first understand what Environment, Instance and Organization mean when working with CDS for… Continue Reading Sachin Bansal’s...

Read More
Microsoft PowerAPPS and Flow restrict third party Apps – Bansal Blogs – Dynamics 365, PowerApps, Microsoft Flows, Power BI
Jun30

Microsoft PowerAPPS and Flow restrict third party Apps – Bansal Blogs – Dynamics 365, PowerApps, Microsoft Flows, Power BI

Flow and Powerapps are two most powerful tools in office 365 arsenal and can automate IT, business processes and can create applications in no time. With that being said Power Users that become fluent in using these can easily move data around and can connect to hundred of third-party application which your security department may not allow. To apply these restrictions you can apply Data… Continue Reading Sachin Bansal’s...

Read More
Quick Capture Customer Visits into Dynamics 365 – Bansal Blogs – Dynamics 365, PowerApps, Microsoft Flows, Power BI
Jun30

Quick Capture Customer Visits into Dynamics 365 – Bansal Blogs – Dynamics 365, PowerApps, Microsoft Flows, Power BI

Canvas PowerApps are great for building simple apps that make us more efficient and help remove obstacles to collecting data. In this blog post I am going to showcase a PowerApp that I have built which significantly improves the speed in which a user can record a customer visit as an Appointment in Dynamics 365. The Scenario The scenario I am tackling is one in which Account Managers visit… Continue Reading Sachin Bansal’s...

Read More
PowerApps Sort & Filter A Data Table (When SQL Is Your Source) – Bansal Blogs – Dynamics 365, PowerApps, Microsoft Flows, Power BI
Jun28

PowerApps Sort & Filter A Data Table (When SQL Is Your Source) – Bansal Blogs – Dynamics 365, PowerApps, Microsoft Flows, Power BI

I have rendered a SQL view in PowerApps in the form of a data table. The table itself, is pretty simple – four columns and multiple rows. The business problem I wanted to fix was as follows: I only want to show rows where a count of a field for a given row is equal to zero I want to filter the table using a toggle switch (the filter is on a “type” field that I have created) I want… Continue Reading Sachin Bansal’s Article...

Read More
Retrieve Data in PowerApps from Flow – Bansal Blogs – Dynamics 365, PowerApps, Microsoft Flows, Power BI
Jun28

Retrieve Data in PowerApps from Flow – Bansal Blogs – Dynamics 365, PowerApps, Microsoft Flows, Power BI

Published by Sachin Bansal Microsoft Dynamics Consultant with 7 years of experience in Microsoft .NET technologies. Proficient and well versed with Dynamics 365 configurations, customization and extensions as my primary skills. Well experienced in .net tools and technologies including ASP.NET, ADO.NET, WCF, C#, SQL Server. Have extensive experience with data… Continue Reading Sachin Bansal’s Article on their...

Read More
Improving entity forms using embedded PowerApps – Bansal Blogs – Dynamics 365, PowerApps, Microsoft Flows, Power BI
Jun26

Improving entity forms using embedded PowerApps – Bansal Blogs – Dynamics 365, PowerApps, Microsoft Flows, Power BI

I have been looking into scenarios with PowerApps and Flow that can benefit Dynamics 365 Customer Engagement user experience. One of the scenarios that can add value right away is on the entity forms. PowerApps can be embedded as an IFrame on the normal entity forms, and can be used similar to Dialogs to offload some processing to PowerApps and Flow. Here is the finished product. This… Continue Reading Sachin Bansal’s...

Read More
Display static menu using Gallery control – Bansal Blogs – Dynamics 365, PowerApps, Microsoft Flows, Power BI
Jun26

Display static menu using Gallery control – Bansal Blogs – Dynamics 365, PowerApps, Microsoft Flows, Power BI

In this post, we will see how we can display static menu using Gallery control where each item will navigate to different screen. Pre-Requisites – Basic knowledge of PowerApps and some of the controls. (see references for more information) Steps – First of all add Main or Home screen (to host the static menu) and then add all related screens (where each item will navigate to). Lets… Continue Reading Sachin Bansal’s Article...

Read More
My Favorite Additions – High Contrast Reports and Donut Radius Control – Power BI June 2018 Update
Jun25

My Favorite Additions – High Contrast Reports and Donut Radius Control – Power BI June 2018 Update

Power BI June 2018 Update introduced many features and enhancements listed here. In this blog we will explore two main reporting features: High Contrast Reports and Donut Radius Control. In case you haven’t downloaded June 2018 update, please do so using link. Donut Radius Control: Donut chart is like Pie chart with only difference is Donut chart is blank in middle and allows space… Continue Reading Sachin Bansal’s Article...

Read More
Power BI June 2018 Update – Connect to Dynamics 365 9.0 – OData V4 Enhancements
Jun25

Power BI June 2018 Update – Connect to Dynamics 365 9.0 – OData V4 Enhancements

In my previous blog, we discussed on Power BI limitation while connecting to Dynamics 365 V9.0. Earlier we had to use 8.x version in OData URL for Dynamics 365 V9.0 connection. With June 2018 update, Power BI added enhancements to OData V4 connector and now you can use OData URL with 9.0 version which is much faster than 8.x...

Read More
New View Designer inside App Designer in Dynamics 365 July Update – Bansal Blogs – Microsoft .Net Technologies
Jun23

New View Designer inside App Designer in Dynamics 365 July Update – Bansal Blogs – Microsoft .Net Technologies

The Dynamics 365 July Update new includes a new View Designer. It includes the drag and drop capabilities for adding columns from Primary or Related Entity. Filter Criteria, Sorting and Column Properties can be defined in the same designer canvas without having to open a new window for that. Filter Criteria : Setting sorting and column properties. Hope it helps.. Continue Reading Sachin Bansal’s Article on their...

Read More
Dynamics 365 – Embed PowerApp on Entity Form as Web Resource – Passing Record GUID as parameter – Bansal Blogs – Microsoft .Net Technologies
Jun20
Read More
PowerApps – Canvas App – How to pass parameter in App URL – Display data based on parameter passed
Jun18
Read More
Dynamics 365 – Configuration Migration Tool – “The schema validation failed for the missing fields” – Update Schema file
Jun14
Read More
PowerApp – Working with Images – Part 2 – Update Image data in CDS for Apps – Image Data Card Properties Explained
Jun13
Read More
PowerApp – Common Data Service for Apps – Image types are non-delegable || Images do not load by default
Jun12
Read More
PowerApp – Working with Images – Part 1 – Create Image Field in CDS for Apps || Upload Image in Dynamics 365 || Display Image in Gallery control in PowerApp
Jun09
Read More
Dynamics 365 – Data Migration – Time-Zone Independent VS User Local Datetime Fields – C# – Bansal Blogs – Microsoft .Net Technologies
Jun07
Read More
PowerApps – Delegation with example (500 records limit) – App’s Performance – Bansal Blogs – Microsoft .Net Technologies
Jun05
Read More
Common Data Service for Apps – Canvas App – Update/Patch Lookup Value (Edit form does not update lookup value on Submit by default) – Use of Patch function – Part 6
Jun04
Read More
Dynamics 365 V9.0 Upgrade – JavaScript Validator – Compatibility check – Bansal Blogs – Microsoft .Net Technologies
May31
Read More
Common Data Service for Apps – Canvas App – Handle Lookups – Part 5 – Bansal Blogs – Microsoft .Net Technologies
May29
Read More
MB2-716 (Microsoft Dynamics 365 Customization and Configuration) – Introduction – Bansal Blogs – Microsoft .Net Technologies
May25
Read More
Fatal Error while installing updates in Dynamics 365 – MSCRM Hacks
Jul18
Read More