Skip to content

Rajeev Pentyala – Technical Blog on Power Platform, Azure and AI

    • About
    • DEV Tools
  • CRM, SQL

    [Step by Step] Connecting to Azure SQL Server using OLEDB Connection from SSIS

    Published by

    Rajeev Pentyala

    on

    August 23, 2018

    Connecting to Azure SQL Server from SSIS using ‘OLEDB Connection manager’  is not a straight forward way, if you are to connect using your ‘Azure Account’ credentials. The only way to connect using ‘Azure Account’ is by using ‘ADO.NET connection’ manager. But then, how to connect to Azure SQL using…

    Continue reading →: [Step by Step] Connecting to Azure SQL Server using OLEDB Connection from SSIS
  • CRM, PowerApps

    PowerApps – Create an ‘Account’ in Dynamics 365 from App using Flow

    Published by

    Rajeev Pentyala

    on

    August 13, 2018

    If you are new to PowerApps, please go through my previous blog In this post, lets build an App with an Account Form and create the record in Dynamics 365. Prerequisite: You must have a PowerApps account. Refer blog for details. Create a Microsoft Flow with logic to create an Account record in Dynamics…

    Continue reading →: PowerApps – Create an ‘Account’ in Dynamics 365 from App using Flow
  • PowerApps

    PowerApps – Error while connecting to Excel Data Source

    Published by

    Rajeev Pentyala

    on

    August 13, 2018

    If you are new to PowerApps, please go through my previous blog In my last Post building, I explained the steps to build an App using Excel file as Data Source. While I was exploring more with that App, I encountered an error when playing with different excel files. Reason & Fix: If…

    Continue reading →: PowerApps – Error while connecting to Excel Data Source
  • CRM, PowerApps

    PowerApps – Build an App using Excel data as Source

    Published by

    Rajeev Pentyala

    on

    August 13, 2018

    If you are new to PowerApps, please go through my previous blog In this post, I am going to walk you through building an App using Excel as ‘Data Source’. I am going to build an App by Prepare an Excel file with data formatted as ‘Table’ Place it in…

    Continue reading →: PowerApps – Build an App using Excel data as Source
  • CRM, PowerApps

    PowerApps – Step By Step – Build a simple Calculator App

    Published by

    Rajeev Pentyala

    on

    August 12, 2018

    In my previous article I detailed the steps to get started with PowerApps by signing up to the PowerApps portal. Now, let me walk you through the steps to create and publish a simple ‘Calculator’ App. The Calculator App will have 2 Text boxes and an ‘Operation’ dropdown. Upon clicking the…

    Continue reading →: PowerApps – Step By Step – Build a simple Calculator App
  • PowerApps

    PowerApps – Getting started

    Published by

    Rajeev Pentyala

    on

    August 12, 2018

    PowerApp is a service from Microsoft Business Application Platform (BAP) for creating business applications that can run in a browser or on a phone or tablet, and no coding experience is required. Its a 3 step approach to create an App Connect to a Data Source; It can be your Dynamics…

    Continue reading →: PowerApps – Getting started
  • CRM 2011

    CRM 2011 (on-premise) – Querying Filtered views from CRM DB

    Published by

    Rajeev Pentyala

    on

    August 6, 2018

    We recently working on Data migration from CRM 2011 on-premise to Dynamics 365. We got the CRM 2011 SQL DB back up, which we restored in our SQL server. But when we run query on ‘Filtered’ views we were getting 0 results. Reason: FilteredViews always run on CRM User context…

    Continue reading →: CRM 2011 (on-premise) – Querying Filtered views from CRM DB
  • CRM, Dynamics 365

    Dynamics 365 – Different types of User Accounts and License consumption

    Published by

    Rajeev Pentyala

    on

    August 3, 2018

    Other day I was asked a question “What are the options to create/migrate users in Dynamics 365 application with no license consumption” The options are Create a User of type ‘Stub User’ which does not consume license Sync a User from O365 to Dynamics 365 and remove the license later.…

    Continue reading →: Dynamics 365 – Different types of User Accounts and License consumption
  • Dynamics 365

    Dynamics 365 – How to get App URL

    Published by

    Rajeev Pentyala

    on

    August 2, 2018

    Using PowerApps, we can create custom business apps comprised of components such as entities, dashboards, forms, views, charts, and business processes. Its convenient way to package and provide the components which are matter to the Users. Lets take a scenario to understand this better A sales company has users having…

    Continue reading →: Dynamics 365 – How to get App URL
  • CRM, Dynamics 365

    D365 – Unified Interface – Create an App and Grant App access to a Security Role

    Published by

    Rajeev Pentyala

    on

    August 2, 2018

    In this article, I am going to provide steps to create new App and how to grant the App access to a particular Security Role. Prerequisite to create App: User must have the following privileges to create App: Create, Read, and Write privileges for the “App” entity Read and Write…

    Continue reading →: D365 – Unified Interface – Create an App and Grant App access to a Security Role
Previous Page Next Page
Visitors

2,146,897 hits

Top Posts
Getting Started: Build Your First Power Apps Code AppGetting Started: Build Your First Power Apps Code AppAugust 27, 2025Rajeev Pentyala
Claude Code 'VS Code' Extension: Enable 'Bypass Permissions' ModeClaude Code 'VS Code' Extension: Enable 'Bypass Permissions' ModeFebruary 5, 2026Rajeev Pentyala
[Step by Step] Beginner : Create a PCF control and add it to a custom page[Step by Step] Beginner : Create a PCF control and add it to a custom pageDecember 2, 2024Rajeev Pentyala

Rajeev Pentyala – Technical Blog on Power Platform, Azure and AI

  • Pinterest
  • Instagram
  • Facebook
  • Mail
    • About
    • DEV Tools

Create a free website or blog at WordPress.com.

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
 

Loading Comments...
 

    • Subscribe Subscribed
      • Rajeev Pentyala – Technical Blog on Power Platform, Azure and AI
      • Join 483 other subscribers
      • Already have a WordPress.com account? Log in now.
      • Rajeev Pentyala – Technical Blog on Power Platform, Azure and AI
      • Subscribe Subscribed
      • Sign up
      • Log in
      • Report this content
      • View site in Reader
      • Manage subscriptions
      • Collapse this bar

    Notifications