Launch URL from Sharepoint List Dropdown in PowerApps

This example is when you are using a dropdown in PowerApps and wanting to open a link that is in the list with a button.

The list will need to have the URL that you want to open in a proper format eg. “”.

This example below assumes that you already have the Sharepoint List connected to your PowerApp.


Dropdown1.Items = Distinct(SPList, Title)

Button.OnSelect = Launch(LookUp(SPList, Dropdown1.Selected.Value = Title, Link))

The SharePoint list’s name is ‘Site Links’ you will need to replace this so that the SP List’s name is correct.
Read More →
Replies: 0 / Share:

Charts on the Dashboard page are showing the error: “You do not have sufficient privileges to view this chart”.

As well as many of the entities such as calendars, contacts and accounts provided by default throughout the system are missing.

If this is a new tenant this can happen to users that have been given an Administrator login to Dynamics 365, to fix this problem you need to add some permissions to the user.

How to fix You do not have sufficient privileges to view this chart error in Dynamics 365

Click the three lines at the top, then select settings, then select security. Shown in image below.


Go into the Users menu

Select the user you want to add permissions to

Click the Manage Roles button

Add in the roles that you want the user to have.


Now if you go back to the dashboards you will be able to see the ones you have given the user permissions to see.




Read More →
Replies: 0 / Share:

Introduction to PowerApps

Microsoft PowerApps is a new enterprise service that empowers innovators everywhere to connect, create and share business apps with team members on any device in minutes.

PowerApps is new and still contains some bugs as it is new, but I expect that will be ironed out as time goes on.

PowerApps allows you to connect to your data with an easy to use interface.

This video will show you how to make your first PowerApp from a template and also how to navigate though the PowerApp desktop application.

You can find out more about PowerApps on

Read More →
Replies: 0 / Share:

While forgetting your domain admin password is not really something you should do you may come across a server that you don’t know the domain administrator password for this video will help you.

You will need a Windows Server installation disk to complete these steps.

Boot to a windows server 2012 r2 CD and hold shift F12 then run the bottom two commands

  • MOVE C:\Windows\System32\Utilman.exe C:\Windows\System32\Utilman.exe.bak
  • COPY C:\Windows\System32\cmd.exe C:\Windows\System32\Utilman.exe

Once that is done you can reboot the server and click on the “Ease of Access” button. This will give you a command prompt where you can reset the domain admin password using the net user command:

net user administrator *

It will then prompt you for the new password.

Type in the new password that you want and hit enter.

Now you have reset your domain administrator password and you can log into the server.

Read More →
Replies: 0 / Share:

How to Install Windows Server 2016

To install Windows Server 2016 you will need the installation media.

You can download a full evaluation copy of Server 2016 from the evaluation page.

This video shows you how to install Windows Server 2016 with GUI. I am using Hyper-V to virtualise the deployment of Server 2016.

Server 2016 looks the same as Windows 10 but still has the server manager app to control it.

There are three different ways to deploy server 2016, you can do it with a GUI, without a GUI or you can use nano server.

Once the Windows Server 2016 is installed on your server or virtual machine don’t forget to update it.

Some new features in server 2016 are:

  • Nano server
  • Windows Server Containers
  • Docker Support
  • Adding or removing memory from live virtual machines
  • Adding or removing network adapters from live virtual machines
  • Running VMs in VMs
  • Powershell Direct
  • Shielded VMs

Download your free copy of Windows Server 2016 evaluation to take it for a test run and practice your skills.

Read More →
Replies: 0 / Share:

How to Install Updates on Windows Server 2016

Microsoft have remove Windows Update from the Control Panel so now it has to be done through the settings app.

When I first when I went to update I couldn’t find Windows Update in the control panel then I figured out that it is only available through the Settings App or powershell.

Windows updates should generally be scheduled using group policy. However, should you need to apply a Windows update manually, follow the steps below.

To install updates in Server 2016:

  • Open the settings app
  • Go to updates down the bottom
  • Click check for updates
  • Install the updates

Once the updates are installed you may need to reboot your server.

This is a really good thing to do when you first install Windows Server 2016, before installing everything else. This will mean that your server is patched and any issues that have already been resolved by a patch from Microsoft will not happen.

Read More →
Replies: 6 / Share:

Sharing users calendars is one of the most used parts of an Exchange Server(which is included in most of the business versions of Office 365), this feature allows others inside of your organisation to view or edit calendars.

The old school way of doing this was to go around to each user and set the permissions directly on the calendar by right clicking on it and selecting properties, then navigating to the permissions tab where you could set the permissions for each user or group over the calendar.

You can manually view your calendar permissions in outlook by right clicking on your calendar and selecting properties then going to the permissions tab.
You can manually view your calendar permissions in outlook by right clicking on your calendar and selecting properties then going to the permissions tab. This is useful if you want to share a single calendar but if you want to edit bulk calendars then PowerShell is the way to go.

But there is a better way. We can use PowerShell to set these permissions in bulk on either exchange or office 365.


So what are the different exchange calendar permission levels?

Straight out of the box calendars come with a bunch of preset permission levels, this makes your life easier because you can allow a bunch of different controls over the calendars from not being able to see them or being able to set users to be able to book meetings and delete meetings if needed. The different permission levels are as follows:

  • None – FolderVisible
  • Owner – CreateItems, ReadItems, CreateSubfolders, FolderOwner, FolderContact, FolderVisible, EditOwnedItems, EditAllItems, DeleteOwnedItems, DeleteAllItems
  • PublishingEditor – CreateItems, ReadItems, CreateSubfolders, FolderVisible, EditOwnedItems, EditAllItems, DeleteOwnedItems, DeleteAllItems
  • Editor – CreateItems, ReadItems, FolderVisible, EditOwnedItems, EditAllItems, DeleteOwnedItems, DeleteAllItems
  • PublishingAuthor – CreateItems, ReadItems, CreateSubfolders, FolderVisible, EditOwnedItems, DeleteOwnedItems
  • Author – CreateItems, ReadItems, FolderVisible, EditOwnedItems, DeleteOwnedItems
  • NonEditingAuthor – CreateItems, ReadItems, FolderVisible
  • Reviewer – ReadItems, FolderVisible
  • Contributor – CreateItems, FolderVisible

What are the PowerShell commands used to manipulate calendar permissions?

The basic PowerShell commands you can use to edit the permissions of calendars are(each one has a link to the official Microsoft documentation):

Notice that all of the commands are to do with MailboxFolderPermission, this is because Exchange actually treats the calendar as a folder, so whatever we are doing to the calendar we are actually doing to an exchange folder.

Using PowerShell to Edit Calendar Permissions

So now lets get into it, if you are using Microsoft Exchange installed on your server then you can just open the Exchange PowerShell application, if you are using Office 365 you will need to first connect to office 365 in PowerShell, you can follow the instructions in that article to connect.

Once you are connected to exchange in PowerShell it is time to run some commands.

Getting a users calendar permissions

To get a users calendar permissions we will use the Get-MailboxFolderPermission command in PowerShell.

Get-MailboxFolderPermission -Identity [email protected]:\Calendar -User [email protected]


Some final notes and recommendations with folder sharing in office 365

  • When setting permissions it is best not to set owner permissions for the calendars as this will allow other users to delete the calendar on someone else’s mailbox. This could lead to a real headache as the users calendar will just disappear and they wont know why.
  • Setting PublishingEditor permission will allow users to have all permissions except to delete the actual calendar.
  • Setting default sharing is usually a pretty handy thing in smaller businesses that are using the service. This will allow for more collaboration and a more open workplace.
Read More →
Replies: 0 / Share:

Deploying Windows 10 from a DVD in a business environment is time consuming, while it may be very good for a one off installation of Windows 10 when you need to deploy images often there is a better way.

Deploying Windows 10 using Windows Deployment Services(WDS) with your windows server 2012 R2 server is the way that you can speed this up. WDS is a Microsoft server technology for deploying network based installation of Windows.

To use WDS the following requirements will need to be met:

How to install and configure WDS

Sign into the server and open the Server Manager if it does not open automatically.

Click the Manage button in Server Manager and select Add roles and features.

On the Select installation type page, select Role-based or feature-based installation and select next.

Select your server and click next

On the Select server roles page, tick Windows Deployment Services box, a box will pop up saying Add features that are required for Windows Deployment Services? click the Add Features and click next.

On the Select features page, click next.

On the role services page, make sure both Deployment Server and Transport Server are ticked and click next.

On the Confirm installation selections page, click the install button.

When the installation process completes successfully, click the Close button and go to the Server Manager screen.

Now the Windows Deployment Services role is installed.

Configuring Windows Deployment Services

In the Server Manager click the Tools button in the top right hand corner and select Windows Deployment Services, this will open the WDS console.

Expand servers, right click on your server name and click Configure Server.

Read over the Before you begin screen and confirm that your configuration meets the requirements and select next.

On the Install Options page you will need to select integrated with Active directory and click the next button.

On the Remote Installation Folder Location, select the location where you want to keep all of that Windows Images and configuration files and select next. – The Remote Installation Folderis recommended not to be on the system partition of your server, you should also make sure there is enough storage space to store these files as you add more to it.

On the PXE Server Initial Settings page Select the appropriate setting that you want. We are going to use respond to all client computers(known and unknown) because we want to be able to deploy images to any computer on the network.

Tick the box Add images to the server now and select Finish. This will now pop up with the options to Add images to your WDS server.

Adding Images to Windows Deployment Services

Insert your Windows 10 DVD into the server(or mount the ISO image for a Windows 10 installer to your VM if you are using a Virtual Machine)

We will now add the install.wim and boot.wim file to WDS from the Windows 10 installation media.

The boot.wim file is a Windows PE image that you boot from a client computer to install an operating system

Inside of the Windows Deployment Services pane expand out your server name in the left hand side, right click on Install Images and select Add Install Image…

Name your image group and click the next button.

Click browse on the Image Files page and navigate to your DVD drive, go to the sources folder and select install.wim

Click open and select next.

This page will give you the Available images, your installation media may have more than one image available, select whichever ones you want to be able to deploy and then click next.

On the summary page, click next. This will now take a little while to check the integrity of the images

Once that is finished you will be able to look inside of the Install Images folder and see you image group, if you select your image group it will have the install images that you have added in there.

Now all you have to do is add the boot.wim file. To do this right click on Boot Images, and select Add Boot Image, then run though the same steps that you did when adding your install.wim except select boot.wim.

Now you will be able to deploy Windows 10 using WDS!!


Just use PXE boot and you will be able to install Windows 10 using your new WDS Server.


Read More →
Replies: 0 / Share:

This tutorial shows you how to Install Active Directory, DNS and DHCP to create a Domain Controller. You can watch the video or follow the steps on the page.


Server 2012 R2 System Requirements

Minimum: 1.4 Ghz 64-bit processor
Minimum: 512 MB RAM
Minimum: 32 GB or greater

I recommend using better specs then that but it will work on a computer or VM that has those specs.

Installing Active Directory and DHCP Server Roles

This assumes that you already have a fresh installation of Windows Server, if you don’t yet follow the steps on how to install Windows Server article.

Set a static IP address on the network adapter, to do this:

  • Open the network and sharing center
  • Click on Change Adapter Settings
  • Right click on the network adapter
  • Select Properties
  • Select Internet Protocol Version 4
  • Click Properties
  • Type in your Static IP address configuration
  • Click OK

static IP address config server 2012 r2

Open the server manager.

Select Add Roles and Features

add roles and features


On the Before You Begin screen select next

add roles and features wizard welcome page

Select Role-based or feature-based installation and click the next button.

select role based install

Select the server that you want to install the role on and click the next button

select serverPNG

On the next screen tick Active Directory Domain Services and DHCP Server.

ad and dhcp

On the next screens leave the default settings and select next and then install.

Once the installation of DHCP and Active Directory roles is complete you will get a notification in the Server Manager console to “Promote this server to a domain controller” and to “Complete DHCP configuration”. You can to run the “Promote this server to a domain controller” first, click on that.

promote server to dc

This will bring up the Active Directory Domain Services Configuration Wizard. You want to select “Add a new forest” and give the domain a name. It is better to use the <domain name>.local or a subdomain of a domain that you control. Then select next.

ad config wizard domain name

Next choose the forest function level. If you are just using server 2012 R2 then select that otherwise select the lowest version of Windows Server that you are going to have joined to the domain, give the domain a DSRM password(make sure you document this password) and select next.

forest function level

Leave the rest of the settings as default and keep clicking next though the wizard. At the end of the configuration wizard you will be signed out and the server will be rebooted. Once the server is rebooted it will be a domain controller.

domain controller login


Log into the server and open DHCP in the start menu. You will notice that it is not configured yet.

Right click on IPv4 and select “New Scope”.


This will open the “New Scope Wizard”, give the scope a name and description and click next.

new scope wizard dhcp

Now you will need to set the IP range. To do this enter a start IP and end IP that is on the same subnet as you.

You will want to make sure that these IP addresses are available.

scope ip dhcp

The next screen allows you to add any exclusions to the IP range. If there is some IPs allocated for something(maybe phone system) then exclude them from your DHCP. Select next.

Then you can set your lease duration time, set this and select next.

Then you will want to configure your scope options, this is where you configure your router and default gateway address and anything else that needs to be allocated by DHCP. Go though these settings and allocate as needed for your network.

Now you will be able to see your DHCP scope in the DHCP console.

dhcp settings

All done, now you have a domain controller that also runs DHCP.




Read More →
Replies: 2 / Share: