Count File Rows with PowerShell – 365Knowledge
May07

Count File Rows with PowerShell – 365Knowledge

By365KAdmin Count File Rows with PowerShell Very quick post (more so I don’t forget how to do this!) Had a CSV file which I knew had a lot of rows!….. more than excel could handle to open, so I wanted to know the exact number, but without opening. PowerShell to the rescue: $lines = 0 $fileReader = New-Object IO.StreamReader… Continue Reading 365KAdmin’s Article on their...

Read More
Fun with Microsoft Flow, What3Words and Flic Button – 365Knowledge
Apr08

Fun with Microsoft Flow, What3Words and Flic Button – 365Knowledge

By365KAdmin Fun with Microsoft Flow, What3Words and Flic Button There’s some really cool IOT stuff going on, and its getting easier to get involved and have a go. I thought in this blog I would have a play with a couple of tools and see what we could do. Hopefully it’ll inspire you to have a go and improve! For this article I am going to… Continue Reading 365KAdmin’s Article on their...

Read More
Microsoft AZ-900 Certification – 365Knowledge
Mar08

Microsoft AZ-900 Certification – 365Knowledge

By365KAdmin Microsoft AZ-900 Certification I’m pleased to say I have just passed the AZ-900 exam. Although my main area of expertise is and always has been Dynamics 365 (CRM), I find myself getting more and more involved with the wider Microsoft Business Solutions Ecosystem, and that includes Azure.  Whether its Logic Apps for workflow, or Service… Continue Reading 365KAdmin’s Article on their...

Read More
Dynamics 365 User Access Report with FetchXml and Power BI – 365Knowledge
Mar06

Dynamics 365 User Access Report with FetchXml and Power BI – 365Knowledge

By365KAdmin Dynamics 365 User Access Report with FetchXml and Power BI Ok, so that’s not the snappiest of titles, but essentially it’s my lazy way of covering a couple of topics in one blog post: Need to report on Licensed Users and When they Last Accessed DynamicsShowing that in a Power BI Report using FetchXMLIt’s worth noting at this point, how… Continue Reading 365KAdmin’s Article on their...

Read More
You Say Flow, I Say Logic Apps – 365Knowledge
Feb24

You Say Flow, I Say Logic Apps – 365Knowledge

By365KAdmin You Say Flow, I Say Logic Apps I’ve been using Flow for quite a while, but recently started utilising Azure Logic Apps for some pieces of work. On one of the forums I frequent, someone asked the question “What’s the difference between Flow and Logic Apps”. Well the quick and simple answer is that in a lot of ways,… Continue Reading 365KAdmin’s Article on their...

Read More
Learn More With….. Microsoft Learn! – 365Knowledge
Feb13

Learn More With….. Microsoft Learn! – 365Knowledge

By365KAdmin Learn More With….. Microsoft Learn! I’m pretty well Microsoft through and through. However a few years ago I had a detour in to the depths of the realm know as Salesforce (It’s fine, I’m ok now)….. Seriously though, There are a few things that Salesforce do quite well, and one of the things I thought they did well was Trailhead…. Continue Reading 365KAdmin’s Article on their...

Read More
Integration With Dynamics 365 CE And Companies House API – Azure Logic App – 365Knowledge
Feb10

Integration With Dynamics 365 CE And Companies House API – Azure Logic App – 365Knowledge

By365KAdmin Integration With Dynamics 365 CE And Companies House API – Azure Logic App Introduction and Background Before I start the overview of this process, I think it’s worth noting that over the last few years, the options for integration, and to be fair, any sort of extension and development in Dynamics 365 has/is shifting from being a C#… Continue Reading 365KAdmin’s Article on their...

Read More
Show Image if field value equals… – 365Knowledge
Jan07

Show Image if field value equals… – 365Knowledge

By365KAdmin Show Image if field value equals… Before I start, a massive shout out to Charles Osei .As part of the TDG team, we had a discussion, and his solution totally solved the requirement I had. Also another great example of how a collaborative group can work. Had a requirement recently to show something a little more visual on a record form if a… Continue Reading 365KAdmin’s Article on their...

Read More
Using SSIS for Bulk Data Deletion in Dynamics 365 – 365Knowledge
Nov26

Using SSIS for Bulk Data Deletion in Dynamics 365 – 365Knowledge

By365KAdmin Using SSIS for Bulk Data Deletion in Dynamics 365 I had a situation recently that an instance (not one I managed I hasten to add!) had started to grow in storage, to the point that it was at nearly 200% capacity. I was asked to look at it. Turned out that Plugin Tracing had been switched on, and a plugin was throwing errors…. Continue Reading 365KAdmin’s Article on their blog

Read More
JavaScript to show Form Notification – 365Knowledge
Nov09

JavaScript to show Form Notification – 365Knowledge

By365KAdmin JavaScript to show Form Notification Just a quick one….. Needed to show a notification on a form if an option set value = x Used the following to get the text value, then show the Notification:     Add the function to an onload event, and the results: Continue Reading 365KAdmin’s Article on their blog

Read More
Anonymising Data in Dynamics 365 with SSIS – 365Knowledge
Nov07

Anonymising Data in Dynamics 365 with SSIS – 365Knowledge

By365KAdmin Anonymising Data in Dynamics 365 with SSIS So I don’t want to get in to the whole GDPR discussion in this article, but with GDPR in mind, I think it’s important, and potentially reduces risk, to anonymise data in a non production environment. Again, there are plenty of articles on whether it should be a process of anonymising or… Continue Reading 365KAdmin’s Article on their...

Read More
Check Back Soon! – 365Knowledge
Oct24

Check Back Soon! – 365Knowledge

By365Knowledge Check Back Soon! Thanks for checking out our new site! Check back soon to see our updated blog posts! I have decided to start again with the posts, as some of the old posts were for previous versions of Dynamics CRM/365 and not relevant.   Thanks, 365Knowledge Team Continue Reading 365Knowledge’s Article on their blog

Read More
Dynamics 365 Spring ’18 Release Notes – CRMconsult
Mar21
Read More
Are Certifications Still Relevant? – CRMconsult
Mar19
Read More
JavaScript to show Form Notification – CRMconsult
Aug01
Read More
CRUD Examples using a JQuery Web Application
Dec29
Read More
hello world! (The re-birth) – CRMconsult
May12
Read More