Power Apps
Fixing PAC CLI “non-recoverable error” in GCC High and DoD by enabling telemetry
If you use the Power Platform CLI (PAC CLI) in GCC High or DoD environments, you may run into a sudden crash that looks like this:
category
Power Apps
Power Apps
Bridging Clouds: Secure Pipelines from Azure DevOps to GCC High
The goal of this setup is to allow an Azure DevOps pipeline running in the Commercial cloud to move files (e.g., build artifacts, documentation, or deployment packages) into a Storage Account in GCC…
Power Apps
Locking Down a Logic App (Consumption) with OAuth for Calls from Dataverse Plug-ins using Managed Identity
I’m using managed identity to let a Dataverse plug-in call Azure resources without storing secrets. One of those calls hits a Logic App (Consumption) via the When an HTTP request is received trigger.
Power Apps
Passing Pipeline Trigger Time to Data Flows in Azure Data Factory: Use Strings, Not Timestamps!
When working with Azure Data Factory (ADF) and the Dataverse connector, passing the pipeline trigger time into a Data Flow can be trickier than expected.
Power Apps
Power Query: Driftless Merges using Table.Buffer
Recently I was working on data where I needed to pick one best row per group, then merge that result with a lookup table.
Power Apps
How to View DLP Policies Applied to a Power Platform Environment
To quickly see which Data Loss Prevention (DLP) policies are applied to a specific Power Platform environment, you can use a direct URL. This article shows you how to:
Power Apps
Harnessing Host Form Data with PCF Controls in Model-Driven Applications
This tutorial delves into integrating PowerApps Component Framework (PCF) controls with host form data within Microsoft Power Platform’s model-driven apps.
Power Apps
Copy Hidden Power Automate Expressions
While recently walking a colleague through Power Automate, I was reminded of one of my long-standing frustrations: how difficult it is to copy expressions once they’ve been inserted into actions like…
Power Apps
Connecting to Dataverse from Azure Data Factory
Azure Data Factory (ADF) provides versatile ways to connect and interact with Dataverse. Understanding the connection options and configurations is crucial for securely and efficiently managing your…
Power Apps
Automating Azure Storage Account IP Restrictions with Power Automate
When managing Azure Storage Accounts, it’s essential to control access by restricting allowed IP addresses.
Power Apps
FBI Top Ten Power Platform Connector
Today’s digital landscape offers unprecedented opportunities to leverage technology in the service of public safety.
Power Apps
How to Show Notes (Annotations) on a Model-Driven App Dashboard
Model-driven apps in Power Apps allow users to create dashboards that display key data from different entities. By default, dashboards do not provide an easy way to display Notes (Annotations).
Power Apps
Using Web Templates as Custom Components in Power Pages: A Classification Banner Example
Web templates in Power Pages offer a powerful way to create reusable components that can be used across multiple pages, headers, and footers.
Power Apps
From Messy to Manageable: Cleanly Load Dataverse Tables in Power BI
First and foremost, I want to take a moment to acknowledge Brandon Pires, who originally crafted the script that inspired all of this work.
Power Apps
Bypass Power Apps Consent Prompts Using PowerShell
When a user opens a Power App for the first time, they are often presented with a consent form asking for permission to access data sources or APIs used by the app.
Power Apps
Custom Auto Number in Dataverse with Fiscal Year-Based Incrementing Using Plugin Code
In many scenarios, businesses require custom auto-numbering for records in Microsoft Dataverse that go beyond the default functionality provided.
Power Apps
Connecting the Paconn CLI Tool to GCC, GCCH, and DoD Environments for Power Platform Connectors
When working with the paconn CLI tool to create and manage custom connectors in the Power Platform, it’s essential to configure your environment settings properly, especially when targeting different…
Power Apps
Overcoming OpenAPI 2.0 `multi` CollectionFormat Challenges in Power Automate Custom Connectors
Integrating APIs into Power Automate flows often requires creating custom connectors, a process that can encounter challenges with certain API specifications.
Power Apps
Installing PowerShell Modules in Firewalled and Air-Gapped Systems
Managing IT environments with limited or no internet access, such as firewalled systems or air-gapped setups, presents unique challenges.
Power Apps
Syncing Azure DevOps Work Item Status to Microsoft Dataverse with Dataflows
In today’s fast-paced development environments, seamless integration between customer and development tracking systems can be crucial for maintaining transparency, efficiency, and alignment across…
Power Apps
Govee and Power Platform: Transforming Smart Lighting Automation
In the evolving world of smart home technology, the integration of lighting solutions with sophisticated automation platforms is gaining significant traction.
Power Apps
Power Automate Blueprint Accessing Azure Portal Backend APIs and the Intricacies of main.iam.ad.ext.azure.com
In the realms of digital infrastructure management, automation emerges as a pivotal ally, especially when confronting repetitive and time-sensitive tasks.
Power Apps
Government API Development Playbook: Designing for Power Platform and Building Custom Connectors
The article discusses integrating Government APIs with Microsoft Power Platform, emphasizing the creation and certification of custom connectors.
Power Apps
Handling Graph API Pagination in Power Platform Dataflows
When managing extensive user datasets from Microsoft Graph API, a common challenge is handling the pagination of data.
Power Apps
Enhancing Public Sector Travel with the GSA Per Diem Connector for Power Platform
Navigating travel expenses in the public sector can be intricate, especially when it comes to adhering to per diem rates.
Power Apps
Building Better Tables - A patterned approach to using autonumber columns and alternate keys to drive efficiency in Dataflows
Navigating the complexities of dataflows in Microsoft’s Power Platform, especially when dealing with Dataverse, can present unique challenges.
Power Apps
PCF Component: Docx Templates in Canvas Apps
Have you ever wanted to fill in a Docx template within a Canvas App? Look no further! I’m excited to introduce a new PCF component that allows you to do just that.
Power Apps
Capture User’s Last Successful Login with Portal Web API
Hey Power Pages developers! Are you sitting there scratching your head wondering why the Authentication/LoginTrackingEanbled site setting isn’t working? Unfortunately it has been deprecated 😭😭😭😭.
Power Apps
How to Create SharePoint Items with Power Automate Desktop
Power Automate Desktop is a great way to automate many of your daily task so you can focus on real work.
Power Apps
Power Apps Portal - Configure Azure AD Provider in Azure B2C
It is recommended that you no longer use Local Login authentication for Power Apps Portal but instead utilize Azure Active Directory B2C to provide this type of authentication.
Power Apps
Power Automate Desktop Example - Downloading Image From Email To Network Drive
After watching the RPA (Robotic Process Automation) demo from Steve Winward Real-Life Use case using AI Builder Form Processing with Power Automate Desktop I have been looking for ways to utilize…
Power Apps
Model App Access Checker for Dataverse
Want to know which model applications your users have access to in Dataverse? Check out the app access checker that is available within the Power Platform admin center.
Power Apps
Enable the Export to PDF Ribbon Button
Dataverse allows you to easily generate your Word Templates as PDF files. Last year they expanded the functionality beyone just the out of the box sales entities to all custom entities.
Power Apps
Open Model Apps Url Using Unique Name
When generating links for records, lists or reports in a Dataverse environment it is important that they open the specific application they relate to so users have the best experience.
Power Apps
Return Error in Power Automate When Using Try/Catch Scopes
When utilizing scopes within Power Automate to create a try/catch/finally statement it can be useful to provide additional details about any errors that occurred within the try block.
Power Apps
Calling Dataverse Web API in PowerShell using Client Credentials
Connecting to Dataverse using PowerShell can be very helpful for data migrations and use within Azure DevOps. Connecting to an instance in a non-interactive way can be tricky though.
Power Apps
Custom Process Action vs Custom API in Dataverse
I recently had the opportunity to utilize the new Custom API functionality within Dataverse. I had previously used Custom Process Actions and was a little confused as to the difference and why i…
Power Apps
Team Member License Enforcement in GCC
If you have custom applications built on Dynamics/Dataverse within the US Government Community Cloud (GCC) and only have Team user license that were purchased after October 2018 your apps screen may…
Power Apps
Power Automate Custom Connectors - Import Postman v2 Collection
There are many tools you can utilize to develop Power Automate custom connectors including Postman and Swagger Inspector.
Power Apps
Horizontally Scroll A Large Power Apps Gallery
So you have a lot of data to display but the screen in Power Apps isn’t large enough. My friend Ronald Sease recently showed me how to create a gallery in Power Apps that you can scroll horizontally.
Power Apps
Install/Configure Power Apps Mobile for U.S. Government and DoD User
For those working in the U.S. Government or DoD/Military space needing the Power Apps mobile application on your phone, an additional step of selecting a region must be taken before you attempt to…
Power Apps
WebApi - Execute Bound Function (RetrievePrincipalAccess) in PCF
I am current building PCF component that required me to determine if the user has specific rights to an entity before attempting to modify it.
Power Apps
PowerApps Portal - Users Can See More Than Their Assigned Web Roles Allow
Anyone who has configured the PowerApps/Adx Portal before can tell you how complicated the security mechanisms can be to configure. It’s both easy to give users to much permission or not enough.
Power Apps
Rotational Image PCF Component for Canvas Apps
This image component allows you to rotate an image to any degree unlike the Canvas image component which only allows 90, 180, or 270 degrees.
Power Apps
Launch A Canvas App In Model App From SiteMap
Canvas PowerApps provide a great amount of functionality with little or no code. Many examples demonstrate how to open a Canvas App within a Model App on a specific record and pass the context of…
Power Apps
Pass Custom Parameters To WebResource From UIC SiteMap in Dynamics
While working on creating a page to open a Canvas app full screen inside of a Model app I wanted to create a WebResource I could use over and over again.
Power Apps
Move from using Xrm.Page to formContex in UCI form based PowerApps WebResources
The usage of Xrm.Page is currently deprecated, still available due to it’s high usage, but still deprecated. When will it go away, we don’t really know yet.
Power Apps
Sparse Checkout with Git To Reduce Confusion
If you would like to make updates to the Xrm types or any others in the DefinitelyTyped project on github you can find that cloning all the types can be a real pain.
Power Apps
Multilingual Support For PCF Calendar Control
Multilingual support has been added to the Calendar component I recently shared. This works in both Canvas and Model apps.
Power Apps
Gotchas for PCF Code Components in Canvas Apps
PCF Code Components allow developers to create their own custom interfaces utilizing Typescript and/or React. To learn more about the PCF Component Framework check out this article.
Power Apps
PowerApps Calendar Control
This calendar control was built off of React Big Calendar. The calendar can be used to display events with or without related resources.
Power Apps
Bing Maps PCF Control
This PCF control allows you to display information for a view that contains latitude and longitude information within Bing Maps.
Power Apps
Utilize Customized npm Package from GitHub Branch
When working with npm libraries there are times you find bugs or want to add functionality to a library.
Power Apps
Azure Maps PCF Control
This PCF control allows you to display information for a view that contains latitude and longitude information within Azure Maps.
Power Apps
Custom Grid/Subgrid Using Office-UI-Fabric DetailsList
Allows you to simulate the out of the box Grid and Subgrid controls using the Office-UI-Fabric DetailsList control. It was built to provide a springboard when you need a customizable grid experience.
Power Apps
Use Dynamics WebAPI to get Record Count
When working in an environment where tools like XrmToolbox are not available or allowed getting a total record count can be a real pain sometimes.
Power Apps
Use Dynamics WebAPI to get LogicalName or ObjectTypeCode for Entity
If you need to get the LogicalName or ObjectTypeCode of an entity in your Dynamics environment you can utilize the WebAPI to get the metadata.
Power Apps
PCF Color Picker
For anyone looking for a PCF Color Picker I just released one out on GitHub! It utilizes React and the Office UI Fabric controls.
Power Apps
Dynamics BPF Javascript: NEW onPreStageChange Handler!
If you are utilizing the UCI interface there is a new JavaScript handler available for the Business Process Flows (BPF), onPreStageChange.
Power Apps
Icon Resources for Dynamics
Below are resources that you can utilize within your Dynamics project for generating icons.
Power Apps
Rollup Field Refresh on UCI Form
In the web client version of Dynamics when you hovered over a rollup field it would show a refresh icon to the right of the field.
Power Apps
Custom Flow Connector For Parsing Address
While working on a demo of the Business Cards Scanner component for PowerApps I found that the component only returns the address as a single line and not as parsed address components (UPDATE: The…
Power Apps
Update Business Process Flow Using Flow
When working through App In A Day Workshop I wanted to improve the Approval flow to move the Business Process Flow (BPF) Stage forward if the Device Order was Approved.
Power Apps
Get Dynamics/CDS Base URL in Flow To Generate Links To Record
When sending emails or approvals in flow it can be helpful to also include a link to the record which is being referenced.
Power Apps
PowerApps Naming Conventions and Coding Standards
When building canvas apps the naming conventions used by the objects can be very confusing once you have added a few screens.
Power Apps
Validate Solution Using the PowerApp Checker (Includes On-Premise Solution)
I recently saw the article on how to validate solutions using the PowerApps Solution Checker and wanted to share the link.
Power Apps
Finding Largest Files on Drive Using Powershell
Recently a colleague of mine was having issues with low drive space on one of our servers. Because this is a clients system i am unable to copy over WinDirStat which is what i would usually use to…
Power Apps
Cannot Access SharePoint Files Without Visitor Access in Dynamics CRM Documents Grid
Recently while building a system which synchronized Dynamics permissions to SharePoint we came upon an error which caused the SharePoint Document grid to tell us that we did not have the correct…
Power Apps
SharePoint Documents Grid Error in Dynamics CRM
After setting up Server based authentication between SharePoint and Dynamics on several instances we were having issues on certain instances where users would attempt to access the Document grid…
Power Apps
Dynamics Multi Entity Search (Global Search) Entity Selection Using C#
While coming up with deployment scripts i was tasked to ensure that the Dynamics Global Search had specific entities selected.
Power Apps
Filter Customer Id field on Case Entity To Only Show Contacts or Accounts
Recently while working on a project where the customer was utilizing the Case entity they wanted to only allow users to enter contacts into the Customer Id field.
Power Apps
Exporting Duplicate Detection Rules Using CRM Configuration Migration (Data Migration Tool)
In order to move Duplicate Detection Rules to another system utilizing the CRM Configuration Migration tool make sure to add the Duplicate Detection Rule and Duplicate Rule Condition entities to the…
Power Apps
Navigate to the Document Associate Grid View From Record
This will allow you to navigate to the Documents Associated Grid view form a button in the main records ribbon. This currently works for Dynamics 9.0 and 9.1 Online.
Power Apps
Add SharePoint Documents Associated Grid to Page
Recently I was looking for a way to add the SharePoint Documents Associated grid as an IFrame on a Dynamics form. Jason Lattimer's blog had the answer:
Power Apps
VSTS and SourceTree
Recently started using Git with VSTS and wanted to connect it up to Sourcetree. This article by Adam Prescott helped me out. You can view the article here:
Power Apps
Download SDK Tools for Dynamics V9.0+
Microsoft is no longer providing the entire SDK and samples as a download. Instead they are hosting the samples on a their website and providing the sdk and tools on nuget.
Power Apps
Find Empty Methods in Visual Studio
To find empty methods in Visual Studio search using the following regular expression.
Power Apps
Filtering Down the CrmSvcUtil
Most of the time i use late bound but there are times when early bound makes things easier. I needed to limit the size of the file so filtering down on just the entities i use was needed.
Power Apps
Move Shelveset from One Branch to Another
This can be useful if you start working on the wrong branch and need to move your uncommitted code to the correct branch.
Power Apps
Finding Parental and Cascading Relationships In CRM using SQL
This script will find custom Parental or Cascading Relationship between entities in CRM. This script was used to determine if someone had changed a relationship on a target system and if that change…
Power Apps
CRM SSRS FetchXml PreFiltering Tips
I don't do custom SSRS to often but when I do I consonantly have issues pre-filtering FetchXML in SSRS reports.
Power Apps
VS Shortcut for Data View Pane on SSRS Report
To open the Data View pane for an SSRS report do the following.
Power Apps
Deleted Forms Cause Error in Publish
During recent CRM upgrades I started getting the following error on publish.
Power Apps
Watch Window Copy for Plugin Context Depth Issues
For those times when you are trying to figure out a plugin depth issue and you want to quickly copy/past into your watch window.
Power Apps
Refresh ISV/WebResource after CRM 2013/2015/2016 Save Event
I had a Web Resource page which needed to refresh a jqgrid on it after some fields on a CRM form were updated and record was saved.
Power Apps
Import CRM 2011 Solution Into 2015
In order to import a 2011 solution into 2015 you must first import it into 2013 then re-export from there.
Power Apps
Publishing CRM Using WAP, AD FS and DoD PKI
With TMG going the way of the dodo Microsoft has moved much of it's functionality into Server 2012R2.
Power Apps
Team Foundation Sidekicks
In a search to easily export a list of changeset details into a CSV file I found this awesome utility.
Power Apps
ADFS 2.1 & 3.0 Config Debug Tracing
Run CMD as Administrator- WEVTUTIL sl "AD FS Tracing/Debug" /l:5- Open the file “C:/Windows/ADFS/Microsoft.IdentityServer.Servicehost.exe.config”- Find the following sections shown in the image…
Power Apps
Enable Kerberos Logging in Event Viewer
After you have completed your testing delete the LogLevel key reboot the server to ensure you stop logging.
Power Apps
Disable CRL Checking in IIS 8
When working on a system with no internet access it is important to ensure that CRL checking is disabled. If not disabled you will always receive a 403.13 error after entering you pin.
Power Apps
Postpone CRM Rollup Database Updates
Update Rollup 17 for CRM 2011 creates new indexes for database tables when installed. Because of this the install can take several hours.
Power Apps
Recently I have been working with two plugins in my web pages. DirtyForm, which allows you to detect when changes have been made to fields, and JQueryUI which has a very flexible popup calendar for…
Power Apps
Debug App that Uses ADFS: The SecurityToken is rejected because the validation time is out of range
When debugging an app which connected to CRM using IFD connection I kept getting the following in the trace log.
Power Apps
Could Not Load Type System.ServiceModel .net 4 Web App
While attempting to load a .Net 4 website I kept getting a configuration error and the following item in the Event Log
Power Apps
Visual Studio Error: The given assembly name or codebase was invalid (HRESULT: 0x80131047)
When attempting to add a reference to a project this error kept appearing.
Power Apps
Pass XRM Ribbon Parameters Using JavaScript Array
Trying to pass the list of selected items from a grid using query parameters has limitations due to restrictions on the size of a URL.
Power Apps
Calculate Date of Birth in SSRS
You can utilize this code in an Expression to find the Date of Birth.
Power Apps
Increase CRM Paging Limit for User
Below is an unsupported method for increasing the number of records in each page of a view. This setting is individual to each users.
Power Apps
Create SharePoint Buttons on Administration Page
A long time ago I wrote a SharePoint administration page and had used the "Microsoft.SharePoint.Portal.WebControls" dll to create Ok and Cancel buttons at the bottom of the page.
Power Apps
Repeat Column Headers for Tablix in SSRS 2008
If you are having trouble getting the column headings to repeat on every page for a table/tablix in SSRS 2008 try this.
Power Apps
SQL - Add Header Row to SSIS Generated CSV Files
After generating a flat file in SSIS I needed to update that file with the column headers as the first row. In order to do this I used a SQL stored procedure.
Power Apps
SQL - Generate Scripts to Drop Tables/Views
You can use the commands below to create SQL commands which will drop tables/views. the were clause can be used to limit which tables/views are included in the statement.
Power Apps
SQL - Remove Non-Alpha Characters
This function will remove all non-alphanumeric characters.
Power Apps
SQL - Remove Line Breaks From Text
This function will attempt to remove line breaks from text in SQL.
Power Apps
Wake Up IIS Websites
One of the biggest issues I have found with using authentication methods like Kerberos Constrained Delegation is that the first person who hits the site in the morning gets a 500 error until the…
Power Apps
Get Times for CRM Import Jobs
This script will give you the times for CRM import jobs that have been run on your system.
Power Apps
SSIS Speed: DefaultBufferMaxRows
SSIS can sometimes take a long time to load. Try messing witht he DefaultBufferMaxRows setting in the package.
Power Apps
Reset Default Org for CRM Users
The script below will change the default org for users. This can be helpful if you have disabled the original default org and users are now getting the crm error that the organization has been…
Power Apps
CRM 2011 Performance Settings
Disable Loopback check HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Control/Lsa New DWORD Value: DisableLoopbackCheck = 1 (Decimal) CRM Settings HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/MSCRM New DWORD…
Power Apps
SQL Statements to Get Basic Info About Tables
Here are two scripts I found that will help you generate basic info about your database. This data can be useful when beginning the level of effort for a data migration. NUMBER OF COLUMNS PER TABLE
Power Apps
Fragmented indexes were detected in the Microsoft Dynamics CRM database
Re-index your CRM Org database if you receive this error.
Power Apps
Update Thumbprint in Web.Config After Updating ADFS 2.0 Certificate
Recently I had to replace an expired certificate on my ADFS 2.0 machine. I followed the instruction on the TechNet wiki found here.
Power Apps
Page Not Found 404 After Install or Uninstalling CRM 2011 UR
After uninstalling an update rollup and rebooting the machine CRM starting coming back with a 404 Page Not Found error when trying to access the site.
Power Apps
Deletion State Codes Fields Preventing Solution Import
If you have upgraded a CRM database from 4.0. to 2011 you may have some leftover fields that end in dsc.
Power Apps
Duplicate Detection Rules Unpublish After Solution Import
For the past few weeks something has been bothering me. I have been doing a lot of solution imports and also a lot of data imports.
Power Apps
ADFS 2.0 Default Claims Provider
In situation where you have multiple Claims Providers the HomeRealDiscovery.aspx page may confuse users.
Power Apps
Limited Access to Program Data folder in AD for ADFS 2.0
If you work in an environment where you have no write access to the ‘Program Data’ folder in AD you can still install ADFS 2.0 but you will need to use the command prompt.
Power Apps
CRM 2011 Dashboards Inside IFrames
If you are going to place CRM 2011 Dashboards within an IFrame make sure your URL points to:
Power Apps
CRM Setup and Org Import Logs
Location of CRM 2011 Setup Logs and Organization Import Logs.
Power Apps
ADFS 2.0 ID:4332 The SamlSecurityToken is rejected because the SamlAssertion
ID4223: The SamlSecurityToken is rejected because the SamlAssertion.NotOnOrAfter condition is not satisfied. NotOnOrAfter: '02/28/2012 1:15:04 PM' Current time: '02/28/2012 2:18:35 PM'
Power Apps
ADFS 2.0 Config Debug Tracing
Run CMD as Administrator- wevtutil sl "AD FS 2.0 Tracing/Debug" /l:5- Open Event Viewer.- To open Event Viewer, click Start, point to Programs, point to Administrative Tools, and then click Event…
Power Apps
Force Line Break in CRM 2011 Ribbon Labels
With really long title on CRM ribbon buttons the text will fill the entire space before going to the next line. In order to for text to the next line you can use the Zero Width Space.
Power Apps
Xrm.Page.ui Not Available on Primary Grid
While developing an EnableRule for some new functionality I decided to use an Async call. Here is a great link on how to use Async calls with EnableRule.
Power Apps
GetPickListProperty.name Returns Null in PreCreate
In CRM 4.0 using the Target.GetPickListProperty("fieldname").name property would return the string value of the pick list item display name even in a PreCreate plugin step.
Power Apps
Plugin Set to Use Offline but Entity Offline Settings Not Configured
While attempting to deploy a solution to CRM 2011 I received the following error during the import.
Power Apps
CustomRule - Just one at a time please.
When you define a CommandDefinition in the CRM 2011 and you want to use a CustomRule underneath an EnableRule just remember that your CustomRule will never fire if you have other EnableRules applied…
Power Apps
SharePoint 2010, Event ID 7043: Could not load type 'Microsoft.SharePoint.Portal.WebControls.TaxonomyPicker'
PROBLEM: Every time the application pool is reset the following error appears in the application log.
Power Apps
User Rights Issues in CRM using JavaScript
I needed to find a way to determine if a user did not exist in CRM or did not have any rights. The devError page is available in both CRM 4 and 2011 and returns the same errors.
Power Apps
Passing Parameters Between Web Part and User Control
When creating a web part which encapsulates a custom user control the following is one way to utilize the custom attributes for the web part within the user control.
Power Apps
System.ServiceModel.EndpointNotFoundException in OWSTIMER.EXE
I started getting this error every five minutes after the timer service would kick off.
Power Apps
CRM 2011 Publisher Policy / Redirection
While working on a CRM 2011 application I kept getting the following error even though I was not even using the CRM 4.0 SDK file.
Power Apps
CRM 2011 Ribbon XML Tips
foreach (EntityMetadata em in resp.EntityMetadata) { if (em.IsCustomEntity == true) { entRibReq.EntityName = em.LogicalName; if (em.IsIntersect == true) //check to see if the entity is a M2M…
Power Apps
Global Context for CRM 2011
When creating htm pages as webresources in 2011 there are many times you would want to get information about CRM such as the orgname and server url.
Power Apps
Microsoft Dynamics CRM 2011 Walkthrough Part 2
A great overview of what is new in CRM 2011
Power Apps
Collapse All Visual Studio Projects - PowerCommands
Tired of opening up a Visual Studio Solution and having to deal with collapsing all the project manually. Check out PowerCommands, it's free and offer these additional features.
Power Apps
CryptographicException Error Connecting SharePoint 2007 and ADFS 2.0 Using Domain App Pool User with SharePoint
When attempting to connect ADFS 2.0 and SharePoint 2007 most of the documentation assumes you are using the NetworkService account to run the application pools for the SharePoint content web…
Power Apps
Clean Up IIS and Active Directory After ADFS 2.0 Uninstall
The following is taken from the following KB article: <http://support.microsoft.com/kb/982813>. I have had to do this so many times though I found it easier to post it here :)
Power Apps
Display ADFS 2.0 Forms Authentication Login Page Instead of Windows Authentication Prompt
After installing ADFS 2.0 for SharePoint a Windows login prompt was shown when the SharePoint site forwarded to the ADFS server instead of the ADFS Forms Authentication login screen.
Power Apps
Using SQL Server 2005/2008 with ADFS 2.0
If you plan on using a SQL server 2005/2008 to host your ADFS 2.0 configuration database you must run the configuration using the command line.
Power Apps
CRM 4 to 2011 Javascript Converter
Project Description: CRM 4 to CRM 2011 Javascript Converter helps convert scripts to the latest CRM 2011 Form scripting model.
Power Apps
Errors Adding a Server to the Farm - Invalid List Template (0x8102007B)
Situation: Attempting to run the SharePoint Products and Technology Configuration Wizard on a server to add it into the farm. Our farm also has customized site and list definitions.
Power Apps
DLL Will Not Load in FxCop on Windows Server 2008
I was attempting to install the SharePoint dispose checker into my FxCop program using the rules dll found here, .
Power Apps
SharePoint List Definition Exporter
I was looking to create a schema file for a list I currently have in SharePoint. If you have done this before you can understand the pain.
Power Apps
SharePoint Server State Service
After adding the SharePoint 2010 Chart Web Part to a page I received an error that the Server State Service had not been configured.
Power Apps
Where did my Collaboration Portal go in SharePoint 2010?
When I went to create my first site collection in SharePoint 2010 I was surprised to find there was no site template for the Collaboration Portal.
Power Apps
PowerShell Script for Delete SharePoint Designer Cache
I have developed several workflow activities for use within SharePoint designer. Every time a SharePoint Designer workflow is opened a copy of the deployed DLL is downloaded into the WebSiteCache…
Power Apps
Remove Timeout When Debugging w3wp Process
One of the smart guys I work with posted some information about debugging the W3WP process that I though I should share.
Power Apps
SharePoint Kerberos Authentication wtih IIS 7+
When Microsoft designed IIS 7 they decided to add in a new feature that automaticaly uses the LocalSystem account for Windows Authentication by the kernel.
Power Apps
Add User As Local Administrator On Domain Controller
I recently was settting up a new Microsoft SharePoint 2010 machine and had promoted the machine to a domain controller before creating my SharePoint admin accounts.
Power Apps
Errors Saving and Checkin In Excel/PowerPoint files in SharePoint using CAC Card
Users accessing SharePoint using a CAC card may experienced problems with saving and checking in Excel and PowerPoint documents on the SharePoint servers.
Power Apps
Cannot Access SharePoint From The Server
Problem: Accessing sharepoint using the FQDN while on the server.
Power Apps
CRM Install Problem: instance name must be the same as computer name
Open a query window in the Microsoft SQL Server Management Studio and run the following command. It will display to you the current name of the SQL server.
Power Apps
CRM Asynchronous Process Failure Settings
One of the things I do when setting up a CRM 4.0 server is modify the Recovery settings of the Asynch process.
Power Apps
Changing the MOSS Service Account.... ughhhhh
Bad Idea... Changing the password of the SharePoint service account used to set up and run everything SharePoint. If you have done this read the next paragraph before touching your keyboard again.
Power Apps
Copy data between rows in the same table
So here was my issue. I needed to copy some from one row in a table to another row. I tried using the SQL Server Managment Studio but it does not allow you to copy and past binary information.
Power Apps
Creating a Visual Studio 2008 Results Repository
Learned a very important lesson. If you don't set up a results repository database before running a load test in Visual Studio you won't be able to pull up your reports later.
Power Apps
Get SPUser Information for the Document Creator
While working on creating a SharePoint 2007 event handler I needed to get the login name for the creator of the document I was trying to update.
Power Apps
Grouping Articles By Month
After creating a blog site I wanted to show a webpart that grouped the posts by month. To accomplish this I added a calculated field to my Posts list and used the following formula:
Power Apps
Moving a secondary site collection to a root site collection
I was recently tasked with migrating a secondary site collection to a new SharePoint server and making it the primary site collection.
Power Apps
Register Bamboo Calendar Web Part
I recently downloaded the Bamboo Calendar Plus Web Part v2.5. I ran the setup file and installed both the Calendar Plus Web Part and the Bamboo License Manager v2.7. Here are the issues I ran into:
Power Apps
Tool to embed HTML object directly into SharePoint content
Check out this cool Rick Text Editor add-in that will allow you to embed html such as YouTube and Flash videos. Finally something on codeplex that works!
Power Apps
Dynamics CRM Demonstration Tools (Data Generator)
When creating demo environments for sales presenations I like to add a lot of test data to my systems and make it relevant to the custom to which I'm presenting.
Power Apps
Blank Page With JavaScript Error 'Object Expected'
I had just installed reporting services and the reporting services connector. Suddenly my CRM web client is only showing me a blue screen and will not go to the main page.
Power Apps
CRM 4.0 - System Jobs always stuck in "Waiting"
I had just re-isntalled CRM so that I could set it up as an IFD (Internet Facing Deployment) server. Also CRM is set up through an ISA firewall and using SSL.
Power Apps
Excel Services Compatibility Checker
A while back I had a customer who wished to use Excel Services to do some project reporting dashboards.
Power Apps
Fix Error "Microsoft Dynamics CRM Mail Merge is already running"
When trying to do multiple mail merges I many time get a pop-up error stating "Microsoft Dynamics CRM Mail Merge is already running". Here is how to fix it.
Power Apps
No "Edit Page" link for standard aspx page in SharePoint
Many times user create aspx pages within SharePoint designer and then add web part zones to them so they can add data.
Power Apps
Set up CRM 4.0 Authentication in ISA Server
So you have CRM 4.0 and ISA server. You also want to use the IFD (Internet Facing Deployment) feature of CRM. Well here is what you need to know.
Power Apps
SQL Server Integration Services (SSIS) Development Tips
Here are some SSIS devlopment tips and tricks.