Real-time mail tracking in PowerBI with SendGrid and Azure

Hello,

Mail marketing are more and more important now in companies.  Marketers want to have a lot of data in order to take the best decision for the company they work for.

SendGrid is a cloud platform that help you to monitor a lot of information, such as open, click on link, delivered etc from your mails.

It provides you out of the box reports, but you will definitely want to go beyond and have your own reports.

In this blog post, I will explain you how to setup in PowerBI a real-time mail tracking, so you can make your own reports.

Continue reading

Posted in Azure, C# Solutions, Office 365 | Tagged , , , , , , , | Leave a comment

Office 365: Main SkuId’s of licenses

Hello,

In this post, I would like to share with you main SkuId’s of Office 365 licenses, in order to perform license assignation programmatically.

I know that some licenses are missing here and this is why if you find/have others, feel free to comment this post 🙂

License

SkuId

Visio Pro for Office 365 c5928f49-12ba-48f7-ada3-0d743a3601d5
Project Pro for Office 365 a10d5e58-74da-4312-95c8-76be4e5b75a0
Microsoft PowerApps and Logic flows 87bbbc60-4754-4998-8c88-227dca264858
Power BI Pro f8a1db68-be16-40ed-86d5-cb42ce701560
Office 365 Enterprise E3 6fd2c87f-b296-42f0-b197-1e91e994b900
Power BI (Free) a403ebcc-fae0-4ca2-8c8c-7a907fd6c235
Enterprise Mobility Suite efccb6f7-5641-4e0e-bd10-b4976e1bf68e
SharePoint Online (Plan 1) 1fc08a02-8b3d-43b9-831e-f76859e04e1a
Rights Management Adhoc 8c4ce438-32a7-4ac5-91a6-e22ae08d9c8b
Flow for Office 365 in E3 76846ad7-7776-4c40-a281-a386362dd1b9
PowerApps for Office 365 in E3 c68f8d98-5534-41c8-bf36-22fa496fa792
Office 365 Enterprise E1 18181a46-0d4e-45cd-891e-60aabd171b4e
Microsoft Teams 57ff2da0-773e-42df-b2af-ffb7a2317929
Exchange Online (Plan 1) 9aaf7827-d63c-4b61-89c3-182f06f82e5c
Power App for Office 365 in E1 92f7a6f3-b89b-4bbd-8c30-809e6da5ad1c
Flow for Office 365 in E1 0f9b09cb-62d1-4ff4-9129-43f4996f83f4
Skype Enterprise Online (plan 2) 0feaeb32-d00e-4d66-bd5a-43b5b83db82c
Office Online e95bec33-7c88-4a70-8e19-b10bd9d0c014
Microsoft Forms (plan E3) 2789c901-c14e-48ab-a76a-be334d9d793a
Microsoft Stream for O365 E3 SKU 9e700747-8b1d-45e5-ab8d-ef187ceec156
Microsoft Planner b737dad2-2f6c-4c65-90e3-ca563267e8b9
Microsoft StaffHub 8c7d2df8-86f0-4902-b2ed-a0458298f3b3
Posted in Office 365 | Tagged , , , , | 3 Comments

Cannot perform change in Style Library on SharePoint Online with Tenant/Site Collection Admin account

Hello,

Even on SharePoint Online, it’s now more and more important for companies to brand their sites.

So you might need to use the SharePoint Style Library in order to store your style documents.

But in Office 365 if you don’t activate the feature of “Custom Script” you won’t be able to edit, create or upload document(s) into the Style Library.

You will then figure issues, such as the one illustrated below:

1Sorry, your files couldn’t be uploaded. The upload might be too large or the server might be experiencing high network traffic.

Or

having “You don’t have permission to perform this action” error message, even if you’re tenant administrator!

I agree those error messages are not really meaning full, if you know to what they are related.

To solve this issue:

  1. Go to your SharePoint Admin Center (https://MYTENANT-admin.sharepoint.com)
  2. Go to the settings menu
  3. Scroll down until you see the “Custom Script” menu
  4. Allow users to run custom script as showed on the image below:

snip_20160422194347

 

Posted in Office 365, SharePoint | Tagged , , , | Leave a comment

Azure Active Directory and Microsoft Graph API: Solution to PageToken Expiration Issue When Enumerating Directory objects.

Hello,

Before starting this post, I want to make a special thanks to Stephane Eyskens who helped me to troubleshoot this particular issue.  

When trying to enumerate Directory object via the Microsoft Graph API, by default only 100 items are returned. You need then to use the SkipToken returned in the response to be able to continue to iterate and collect next objects. Basically the SkipToken, store the index of your iteration (“current page number”)

Continue reading

Posted in Azure, C# Solutions | Tagged , , , , , , | Leave a comment

SharePoint Online: Mandatory fields for Custom Tile view in Promoted List

Hello,

I have seen a strange behavior on SharePoint Online when I tried to create a custom view for Promoted List.

Even if you select Standard or Datasheet view it doesn’t matter.

You must select fields:

  • Background Image Location
  • Link Location
  • Background Image Cluster Horizontal Start
  • Background Image Cluster Vertical Start

To be able to have your view working, otherwise you will have the error: “TypeError: Cannot read property ‘indexOf’ of undefined”.

Which is quiet logic if you keep in mind that SharePoint needs those properties to display tiles.

This is good to know that Title field is not mandatory, especially if you want to make a “links-launcher” with your tiles.

To create a view in Promoted Links the best way is to start from the existing view: “All Promoted Links”, then you can select all wanted fields to display.

Posted in SharePoint | Tagged , , | Leave a comment

How to use Azure Deployment Slots? It’s all about a DNS game!

Hello,

It’s now more difficult to work on release life cycle and specially in Azure if you work with others.

Microsoft made a concept called Azure Deployment Slots, I will explain you in this post how this working.

Basically, Deployment Slots consist of having another container where you can deploy your code, a staging container for instance.

Continue reading

Posted in Azure | Tagged , , , , , , | Leave a comment

The Truth about OneDrive Next Gen Client Boundaries and How to Edit Them.

Hello,

In this post I want to summarize some defaults boundaries of OneDrive for Business next gen sync client.

You will find that by default the next gen sync client do not support upload of file bigger than 2GB. You will have to edit corresponding property to let the tool able to sync files up to 10GB.

Continue reading

Posted in OneDrive, SharePoint | Tagged , , , , , | 3 Comments