PowerPlatform
Column Comparison using FetchXML Builder and SQL 4 CDS
Category: Column Comparison,Microsoft Dynamics 365,PowerApps,PowerPlatform Author: Nishant Rana Date: 2 weeks ago Comments: 0

Check it out, the column comparison feature is now added in our favorite XrmToolBox plugins (make sure to update to the latest version) FetchXML Builder https://jonasr.app/2020/07/fxb-july-2020/#more-4374 SQL 4 CDS https://markcarrington.dev/2020/07/15/column-comparisons-in-fetchxml/ Thanks, @Jonas, and @Mark for incorporating it. Also, refer – https://www.itaintboring.com/dynamics-crm/we-can-now-do-column-comparison-with-fetchweb-api/ https://prashantmayur.wordpress.com/2020/07/20/use-column-comparison-in-d365-ce-power-apps-cds-queries/ https://debajmecrm.com/2020/07/16/compare-two-columns-in-queryexpression-in-dynamics-365-cds-sdk/ https://nishantrana.me/2020/07/16/the-new-column-comparison-in-queries-in-dynamics-365-powerapps/ Hope it helps..
Source: Nishant Rana


New Admin Trial (subscription-based) experience – Dynamics 365
Category: Dynamics 365,Microsoft Dynamics 365,PowerApps,PowerPlatform Author: Nishant Rana Date: 2 weeks ago Comments: 0

Recently a new Trial (subscription-based) environment option added to the tenants in the Power Platform Admin Center Earlier we were limited to below options – These new trial types are created and controlled by tenant administrators, as a result of signing up for a trial subscription and can be added to the existing tenant. This … Continue reading “New Admin Trial (subscription-based) experience – Dynamics 365”
Source: Nishant Rana


The new Column comparison in queries in Dynamics 365 / PowerApps
Category: Dynamics 365,Microsoft Dynamics 365,PowerApps,PowerPlatform Author: Nishant Rana Date: 4 weeks ago Comments: 0

Column Comparison is one of the best features that has been recently added to the product. Column comparison allows us to compare values of 2 different columns in our query be it Fetch XML, Web API, or through SDK API. Sharing some of the basic examples that we tried using our favorite  FetchXML Builder If … Continue reading “The new Column comparison in queries in Dynamics 365 / PowerApps”
Source: Nishant Rana


Installation Failed – UI flows setup (Setup.Microsoft.PowerAutomate.UIFlow.exe)
Category: Microsoft Dynamics 365,PowerPlatform Author: Nishant Rana Date: 1 month ago Comments: 0

While trying to run the UI flows setup we got the below error It was because we were trying to install it on Windows 10 Home https://docs.microsoft.com/en-us/power-automate/ui-flows/setup#limitations Hope it helps..
Source: Nishant Rana


Append and Merge to combine data from multiple data source in Power Platform dataflows
Category: DataFlow,Dynamics 365,Microsoft Dynamics 365,PowerApps,PowerPlatform Author: Nishant Rana Date: 1 month ago Comments: 0

Let us continue with our previous post where we loaded the data from on-prem SQL DB to CDS using dataflows. https://nishantrana.me/2020/07/07/load-data-from-sql-on-premise-to-cds-common-data-service-using-power-platform-dataflows-in-power-apps/ Now suppose we have another table (or any other data source) having the contact details, which we would like to append/merge along with our previous data source. For simplicity, here we have created a … Continue reading “Append and Merge to combine data from multiple data source in Power Platform dataflows”
Source: Nishant Rana


Load data from SQL On-Premise to CDS (Common Data Service) using Power Platform dataflows
Category: DataFlow,Dynamics 365,Microsoft Dynamics 365,PowerApps,PowerPlatform Author: Nishant Rana Date: 1 month ago Comments: 0

Let us continue our previous post where we created a connection to the below On-Premise SQL Server Database using an On-premises data gateway. https://nishantrana.me/2020/07/06/configuring-on-premises-data-gateway-to-connect-tosql-server-on-premise-data-source-power-platform/ Here we will use the Power Platform dataflows to load contact entity in CDS using that same on-prem table. Sign in to Power Apps https://make.powerapps.com/home Navigate to Data – Dataflows and … Continue reading “Load data from SQL On-Premise to CDS (Common Data Service) using Power Platform dataflows”
Source: Nishant Rana


Configuring On-Premises data gateway to connect to SQL Server on-premise data source – Power Platform
Category: DataFlow,Dynamics 365,Microsoft Dynamics 365,PowerApps,PowerPlatform Author: Nishant Rana Date: 1 month ago Comments: 0

Let us take a simple example to understand the steps to be performed for configuring an On-premises data gateway. We have below database in our on-premise SQL Server which we connect to using On-Premise data gateway. Below are the steps we need to perform to configure it – Login to Power Apps and navigate to … Continue reading “Configuring On-Premises data gateway to connect to SQL Server on-premise data source – Power Platform”
Source: Nishant Rana


1 2 3 9