Dynamics 365 Finally Adds ‘Not In’ Queries!

For those of you who make use of Dynamics Advanced Find functionality, there is some good news.

With Dynamics 365’s 9.0 update Microsoft will be rolling out a ‘Not In’ query which will allow you to search for records which don’t contain a specific value. This is definitely a highly requested feature and something which should make a good quantity of queries a lot simpler.

More information can be found on Microsofts Dynamics 365 Help Center.

Dynamics 365 – Inline Editable Grid Views

A very overlooked (and I think it’s safe to say ‘underutilised’) piece of functionality in Dynamics is the ability to make lists for most entities inline editable, Ie. the ability to provide an ‘Excel-like’ experience for your users.

This can aid greatly in data entry and modification allowing users to work their way down a list updating records without the tedium of the opening, editing, saving, closing workflow most users have come to expect.

In this article, I am going to cover how to set up the Editable Grid View for accounts and list some of the limitations.

Continue reading “Dynamics 365 – Inline Editable Grid Views”

Dynamics 365 – Populating Test Environments with Sample Data

An often overlooked feature of Dynamics CRM is the ability to quickly and efficiently add sample data and to remove said sample data once you’re happy with your setup, which is a great help to any form of testing.

In this short article, I’ll go over adding and removing Sample Data from your deployment.

Continue reading “Dynamics 365 – Populating Test Environments with Sample Data”

Dynamics 365 – Email ‘From’ Field Grayed Out/Locked/Read-Only

With new updates come’s new bugs and this one certainly caught us off guard when we realised that we could no longer set the ‘From’¬†field of emails in our Dynamics system. This article will go over the details of a workaround to this issue until the problem is resolved with a future update.

Continue reading “Dynamics 365 – Email ‘From’ Field Grayed Out/Locked/Read-Only”

SharePoint – Update-SPProfilePhotoStore UserProfileApplicationNotAvailableException Error

SharePoint’s method for updating user profile pictures can’t exactly be classed as the most straightforward process and I’ve seen a few issues with it over time.

In this article, I will cover the UserProfileApplicationNotAvailableException error and how to resolve it.

Continue reading “SharePoint – Update-SPProfilePhotoStore UserProfileApplicationNotAvailableException Error”

SharePoint 2013 – Contributor Doesn’t have Access to Add Scriptable Web parts

You would normally expect a user with Contribute access to be able to add web parts to pages and the likes in SharePoint but this isn’t always the case depending on your current security settings in the SharePoint Central Admin.

This is a problem I came across recently and here’s how I fixed it. Continue reading “SharePoint 2013 – Contributor Doesn’t have Access to Add Scriptable Web parts”

SharePoint 2013 – How to Automatically Remove Disabled Active Directory Users

I’ve recently had a requirement to remove disabled Active Directory users from our SharePoint deployment so that organograms and the likes are correct. As part of this, I’ve been looking at the options available in SharePoint and stumbled upon a method that should automatically maintain our SharePoint deployment.

Continue reading “SharePoint 2013 – How to Automatically Remove Disabled Active Directory Users”