PowerApps RAW!

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 date fields. One issue i have been having is that the Datepicker does not call the blur even when it's closed which means the DirtyForm plugin doesn't pick up the change. In order to fix this issue I added an onClose handler to my DatePicker selector. DirtyForm: https://github.com/acvwilson/dirty_form Datepicker: http://jqueryui.com/datepicker/ Update 2014/05/13: I changed from using trigger to triggerHandler as the latter does not re-open the calendar control but still has the same functionality of calling the dirty form handler.

When debugging an app which connected to CRM using IFD connection I kept getting the following in the trace log. The issue was that debugging the call caused the time the ticket was generated to be off. In order to fix this I utilized a property that allows tickets to be off by a certain amount of time. The PowerShell command below will allow tickets to be out of the time range by 5 minutes.

  While attempting to load a .Net 4 website I kept getting a configuration error and the following item in the Event Log Exception information:     Exception type: ConfigurationErrorsException     Exception message: Could not load type 'System.ServiceModel.Activation.HttpModule' from assembly 'System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'. Turns our that IIS didn’t have all the .Net components installed.  To fix this you can run the following command which will update IIS with the correct .Net components.  Didn’t even require a reboot. c:\WINDOWS\Microsoft.NET\Framework\v4.0.30319\aspnet_regiis.exe -iru

When attempting to add a reference to a project this error kept appearing.  I though it was because I had switched the project from .Net 3.0 to 3.5 but it turns out it was something else.  The problem turned out to be that the assembly path contained a comma (eg. C:\Libraries\MyLibrary{1-1-14, Customer}).  Once I moved the assembly to C:\Libraries it added correctly.

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.  Instead use JavaScript to pass Ribbon parameters to a variable on the XRM page and grab the data in the popup window. Ribbon Command Setup Here we pass the SelectedControlSelectedItemIds which will pass an object array of all the record ids that are selected on the home grid. Ribbon JavaScript Web Resource The web resource will data the ids and post them to a new variable in the main XRM window then opens a popup window. AddApplicantsToCourse.htm This popup page will get the ids from the page that opened it.  In order to do so we need to do the following: -Include jQuery -declare the array to hold the id values -copy the values from the object in the parent page to the array you created

You can utilize this code in an Expression to find the Date of Birth. =IIF(IsNothing(Fields!dateofbirth.Value), "", IIF( ((Month(Now) - Month(Fields!dateofbirth.Value))

Below is an unsupported method for increasing the number of records in each page of a view.  This setting is individual to each users.  In the case below we are updating it for the user related to the DOMAIN\User account.  This is not recommended for normal user but I find it helpful when I need to add 2000 plugin steps to a solution. UPDATE US SET US.[PagingLimit] = 1000 FROM [Default_MSCRM].[dbo].[UserSettings] US LEFT JOIN [Default_MSCRM].[dbo].[SystemUser] SU ON SU.SystemUserId = US.SystemUserId WHERE SU.[DomainName] like 'DOMAIN\User'