Shane Bartholomeusz

Technical Solutions Consultant

Page 2 of 8

Solved: Excel 256 Row Limit in MS Flow

Problem

When processing Excel files containing over within Microsoft Flow, you might notice that only the first 256 rows will be returned …

What The? What's Going On Here?

Microsoft Flow and Excel Logos
Continue reading

Handling Excel Dates in Microsoft Power Automate

Problem

Dealing with dates can be a real pain in the proverbial sometimes … and Microsoft Power Automate (aka Microsoft Flow) is no exception.

I recently had to bulk load some records from an Excel file into SharePoint Online using Microsoft Power Automate … you'd be forgiven to think that this would be a trivial task … WRONG!

Microsoft Flow and Excel Logos
Continue reading

How To: Set Azure App Service Time Zone

Background

We recently migrated a legacy .NET web service running on-premise to an Azure App Service. During testing we identified an issue with DateTime translations. Our application had a reference to DateTime.Now.

Previously, our app was running on-premise and therefore using Western Australia Standard Time (+8). However, following the migration to Azure, it was using UTC time by default, so we therefore needed to change the default time zone configuration.

In this post I’ll explain how you can update the time zone of your Azure App Service.

Azure App Service Logo
Continue reading

Hidden Dynamics 365 Diagnostics Console

Quick Tip

Dynamics 365 logo

Have you been in situations where your users are experiencing performance issues with Dynamics CRM that you cannot replicate?

Not many people know, but Dynamics CRM includes a hidden diagnostics page that enables you to troubleshoot client side issues including network performance issues and web browser compatibility issues.

Continue reading

MB2-716 Dynamics 365 Exam Guide

Overview

Having recently passed the MB2-716 Dynamics 365 Customization and Configuration exam, in this MB2-716 exam study guide I will share some of my thoughts and tips to help you pass the exam.

Dynamics 365 logo
Continue reading

How To: Backup Synology NAS to Azure Cloud

Overview

In this article we'll look at how to configure your Synology NAS to backup your data to the Microsoft Azure cloud.

Backup Synology to Azure diagram
Continue reading

How To: Create Dynamics 365 Entity Relationship Diagram

What is the MetaDiagram Utility?

When applying customisations to an existing Dynamics CRM environment, an understanding of the existing customisations is crucial.

Unfortunately manually mapping out complex relationships between custom entities can be a painful and time consuming exercise.

Dynamics 365 logo
Continue reading

Solved: Samsung Wireless Fast Charging Paused

Problem

I've been using a Samsung Fast Charge wireless charger with my Samsung Galaxy S8 for a while now, and really love the convenience of it.

After using the wireless charger for several months, all of a sudden, one day it stopped working …

I put my phone down on the wireless charger and it would start charging for a few seconds and then stop with the message “paused” on the screen. This cycle would repeat endlessly and the phone would never charge.

Samsung Wireless Fast Charging Paused Screenshot
Continue reading

How to: Repair Hard Disk Health

Some Background …

All modern spinning hard disks and SSD drives contain S.M.A.R.T technology which enables the monitoring of various hard drive parameters, as a means of checking drive health and predicting failure.

Ordinarily, this information isn’t visible to most end users through the OS, you can however access the S.M.A.R.T metrics of your drive using a tool such as SmartMonTools.

SmartMonTools can be used to monitor hard drive health and also to run various built-in hard drive self-test operations…

Hard Drive Image
Continue reading

Solved: Dynamics 365 Unable to Cast Object Error

Problem:

While testing an existing C# app that connected to our Dynamics 365 environment, we encountered an unusual error after updating the CRM SDK Nuget package used by the app.


System.InvalidCastException: ‘Unable to cast object of type ‘Microsoft.Xrm.Sdk.Entity' to type ‘XXXX.Xrm.Model.XXXX.'

Dynamics 365 logo
Continue reading
« Older posts Newer posts »

© 2020 Shane Bartholomeusz

Theme by Anders NorenUp ↑