Know your people

A quick update from Team Acando.

Unfortunately, the team has had a shortage of people this weekend and the team has suffered further challenges due to sickness. But as the remaining team members still wanting to attend this awesome event, the ambition of the team solution has been scaled down to fit the capacity of the team. We even tried reaching a technology solution, but using only snow and pinetrees from the forest around the hotel didn’t really fly…

But scaled down ambitions still means using the most funky piece of gear present in the misty hills of Voksenåsen this weekend. The Hololens.

Who hasn’t had the experience of meeting people in the office, just having no clue who it is. Well, here comes the HolaLens solution (working name: Facer). With a convenient app you can quickly scan the person and send the image of the person to your company’s SharePoint site. The SharePoint site will check with the Microsoft cognitive services using the Face API and using the results there look up the information of the person in the Contacts list. Voila, you have all the information in a blink of an eye to casually greet the person. And Hololens being the casual eyewear it is, will of course spark new interesting conversations with the person you met.

Do we want everyone in the office to walk around with Hololenses?? Absolutely!!

We are crossing our fingers that we can deliver on this bold ambition.

Final Day Judging and Demos

We’ve had a few questions about the sequence of things today, especially since the agenda has shifted a bit from what’s on the back of the name tags.

1600 – Judging

We will be doing a round of judging at 16:00 again. Be prepared to update the judges on your progress against the categories as before. At that point, we’ll be looking to understand what you’ve accomplished since the last round of judging on Friday at 1600.

Then we all break, clean up the room, etc.

1700 – “Free time”

1900 – Meetup @ bar

1930 – Challenge fine dinner

2100 – Demos and awards

After dinner, each team will have 7 minutes to present their solution. It should be a “pitch”, with a demo of what you have, remembering that you are mainly pitching to the other teams and esteemed guests. (We judges will have seen most of what you are doing, right?) The categories don’t matter at this point; you should talk about the solution and your results.

Think of it as the first time everyone will be seeing your solution (in many cases this will be true!). Your mission is to convince everyone that your solution is the best. It’s up to you what you emphasize, but here are some angles you could take:

  • We built the coolest thing that reflects the theme
  • We took on the hardest technical challenges
  • We used the highest number of cloud services – the best “mash up”
  • We’re the team with the best jokes
  • We can do the best multi-media presentation

You won’t know which approach the other teams will take, so plan wisely, especially since we will stop you at 7 minutes. Period.

After the demos, we’ll have a popular vote. Scott has built a cool voting solution on Dynamics we’ll use for this.

Then we judges will deliberate and come back with the awards and WINNER(s)!!!!

2200+ ASPC Party

PowerBi – Dynamics 365

How to add custom fields to your power bi datasets.
As we know this is not supperted in powerbi online.
Found a neat little trick.
Get Power BI desktop
Add Data From Dynamics 365.


Go to developer resources in Dynamics 365
Copy the url to the organization service: for me that was
and make the endpoint OrganizationData.svc


Connect. Presto! You now have access to your custom field data.


Eport your dataset to powerbi online.

HR Manager -you got help!

Here is the >PS script to help HR! the Excel file inside Office365 for full control on the users. Get full control on licenses, whos leavin’ (your’ fired!) and whos hired, lisenses and assets.

We got an Excel file

Managers can easyli add new users or modify existing users. (also you got versioning and Nintex WorkFlos to support that)
Put the users in to that Azure AD as a dude with approp access rights (aka admin guy)
Simply just run this PowerShell script. That uses WebDav to add the Office365 dimenzione to yor laptop.

And offcourse a full data report on the users you entered metadata from AzureAD, huraiiij you can use this to modify users attribs

I have no Idea why MS got IsBlackBerryUser attrib inside Azure
Here’s the PowerShell script:
#PART 1 – Connect to MSOL
$Cred = Get-Credential # Create a variable $cred
Connect-MsolService -Credential $cred
# E3, E5, Small Business etc
# lookilook
# Get-MsolUser

#PART 1 – Connect to MSOL
$Cred = Get-Credential # Create a variable $cred
Connect-MsolService -Credential $cred
# E3, E5, Small Business etc
#  leave those things in your bag
# Set working directory to maped drive
cd i:\
# PART2 Map network drive against O365
$mappath = ‘\\\DavWWWRoot\SiteAssets’ #Replace yourtenant
        NET USE I: $mappath /PERSISTENT:YES
        Sleep -seconds 7  # this is just in case it takes a while
# PART 3 Bulkimport Users
# -DisplayName,FirstName,LastName,UserPrincipalName,Department,PassWord,UsageLocation,LicenseAssignment
$users = Import-Csv “Users.CSV”
$users | ForEach-Object {
New-MsolUser -DisplayName $_.DisplayName -FirstName $_.FirstName -LastName $_.LastName -UserPrincipalName $_.UserPrincipalName -Department $_.Department -PassWord $_.PassWord -UsageLocation $_.UsageLocation -LicenseAssignment $_.LicenseAssignment } | Export-Csv -Path “\UsersAdded\MatrixUsersCSV.csv” -NoTypeInformation
# PART 3 Bulkimport Users
# -DisplayName,FirstName,LastName,UserPrincipalName,Department,PassWord,UsageLocation,LicenseAssignment
$users = Import-Csv “Usersmore.CSV”
$users | ForEach-Object {
New-MsolUser -DisplayName $_.DisplayName -FirstName $_.FirstName -LastName $_.LastName -UserPrincipalName $_.UserPrincipalName -Department $_.Department -PassWord $_.PassWord -UsageLocation $_.UsageLocation -LicenseAssignment $_.LicenseAssignment } | Export-Csv -Path “\UsersAdded\MatrixUsersCSV.csv” -NoTypeInformation
# OPTIONAL PART 4 (Your’ fired says Donald, just simply delete users from the report file > achaaa that’s cool ai???
#XXX Bulk delete XXXX
# Remove the # if you like to delete the  users from the export file
#users = Import-Csv \usersadded\MatrixUsersCSV.csv
#$users| foreach-object {
#Remove-MsolUser -UserPrincipalName $_.userprincipalname -Force}
# XXX Delete non licensed users XXX
# Get-MsolUser -All -UnlicensedUsersOnly | Remove-MsolUser -Force

Thank You! Smilefjes

Power user functionality AKA User power LOVE

In Zion security is King!
Users of the Command Center change departments and floors all the time. As an effect, the elevators are in constant need of repairs. More importantly users should be able to retain their security groups and the security roles if they, by any chance, change departments. Straight outta the cocoon (meaning: out of the box), this requires system admins to re-assign security roles. This is a major hassle and a complete waste of time, especially in the face of the always imminent Agent threat!
In order to cope with this we have implemented a data model and business logic to handle these challenges. We have implemented a new entity called Security Group consisting of a set of default roles. Whenever a user changes its security group or it business unit, a plugin figures out which security group you belong to and also which business unit you belong to, and it figures out which security roles you are supposed to have, and assigns them to you.
This is a solution created during Artic SharePoint Challange.. Hope you like it! We know how confusing the security roles in Dynamics CRM can be! Why do we have to assign security roles after we move a user who have the same role in a different department?
So we created this to earn some POWER USER LOVE archivement points 🙂
Eat that, Mr Smith!




Using Office 365 Public CDN in SharePoint Online

In the void – bytes counts. You think that’s air you’re breathing? The Appsters wanted to improve their solution by using the public CDN functionality in SharePoint Online. It’s pretty easy to enable in a tenant. I recommend this  Office Dev Center guide for how to do it, and I’m not going into details of exactly that here.

What it does is that enables a library/folder of your choice to be reached from Office 365 using a specific path on the format<tenant host name>/<ID of the public CDN origin>/<sub-path under the origin>

The Appsters’ public CDN URL is

We wanted to share how we work with the Public CDN and Office PnP templates. We are incorporating this into our solution using the CDN URL as a parameter into our pnp-templates.

We are then able to use the parameter when specifying the URL to our JavaScript and CSS files (Of course we’re not referencing every single file – we use a JavaScript script-loader that uses the Sod-functionality to load dependencies (but that’s for another blog post :)). As an example, take a look at how we reference the script-loader from a custom action:

And for the site logo:

And with Chrome Source explorer you can see that our files are loaded from the CDN.

We’re using the public CDN for all of our JavaScript-files, CSS-files, images and logos etc. The only limitation we’ve hit so far is that Office PnP parameters doesn’t work in .spfont files, unfortunately needing us to have the CDN-URL multiple places.

That’s it – happy coding!

Geeky Bastards Club

Morpheus Pharmaceuticals is promoting new supplements using Machine Learning predictions, all you need to do is provide your weekly intake of the different food you consume and the algorithm will predict which supplement is best for you.

Now, this sounds easy! No, IT WASN’T!

Considering that we don’t have a data scientist in the house, we needed to have a dataset for machine learning that is:

  • Relevant
  • Connected
  • Enough (for punching out patterns)

however, this dataset was prepared manually and in house! Later on, the dataset was imported into SQL Azure to form the data source for our machine learning model.

This doesn’t stop here, a trained model is needed to have the right predictions so we tested a couple of ML algorithms before reaching to the final trained model.

Now, this is how this works, first you provide you weekly intake of the following:

  • Meat (KG)
  • Chicken (KG)
  • Vegetables (KG)
  • Fruits (KG)

then the model provides you with the best supplement that completes the needed nutrition to complete your diet.

Project automation in CRM

We are working on project automation in Dynamics 365. This in order to plan what agents with certain skill sets will be most fitted for the mission. We’re radomizing skill sets in order to use scheduleboards in locating required skill sets.

Randomizing skill sets when automatically creating bookable agents:
Leading us to  being able to filter agents by their skill sets and their abilities: