Anders Dissing

Connect to SharePoint online, with an account has multi factor authentication (MFA) enable

2019-02-08T08:48:00.000+01:00

When I deliver PowerShell script to a customer, that contains log in / credential, I normal use this line of code:

$user = "user@tenant.com"
$password = "ZXY" | ConvertTo-SecureString -AsPlainText -Force
$credential = New-Object -TypeName System.Management.Automation.PSCredential -ArgumentList $User, $password
$url = "https://tenant.sharepoint.com"

Connect-PnPOnline -Url $url -Credentials $credential

Or reading the password from disk like this:

$user = "user@tenant.com"
$password = Get-Content .\password.txt -Raw | ConvertTo-SecureString -AsPlainText -Force
$credential = New-Object -TypeName System.Management.Automation.PSCredential -ArgumentList $User, $password
$url = "https://tenant.sharepoint.com"

Connect-PnPOnline -Url $url -Credentials $credential

Or from Windows Credential Manager, https://github.com/SharePoint/PnP-PowerShell/wiki/How-to-use-the-Windows-Credential-Manager-to-ease-authentication-with-PnP-PowerShell.

But this will not work if the customer account is configured for use multi factor authentication (MFA). The PnP/PowerShell script will return with an error message:

“The remote server returned an error: (403) Forbidden”

Luckily, we can work around this errror, by using the UseWebLogin. When using the UseWebLogin parameter a Windows Form will open and show an IE control that navigate to the Office 365 log in page. And this process support MFA login.

$url = "https://ameq.sharepoint.com"

Connect-PnPOnline -Url $url -UseWebLogin

SPBG ERFA møde omkring Modern Office 365 Add-in

2018-03-22T07:59:00.000+01:00

Kom til SPBG erfa møde torsdag den 3. maj, i København, og mød Alon Ekelund. Alon er CEO hos iGlobe. Alon vil tale om hvad er en Modern Office 365 Add-in er, hvilke forskellige typer der findes, Sikkerhed i Add-in, udforinger omkring Office Store, så som, deployment og vedligehold og den nye corporate Add-in catalog . Samt give et oplæg omkring hvordan Office Add-ins kan give en bedre udnyttelse af Office 365 og dermed mere ud af investeringen i platformen. Vi afholder mødet hos ProActive A/S, Rosenørns Allé 1, 1970 Frederiksberg C fra kl. 17:00 til ca. 19 tiden. S.U den 30. april. Tilmelding sker på http://spbg.dk

Office 365, Security & Compliance og GDPR

2018-01-19T11:12:00.000+01:00

Kom til at gratis halvdags arrangement i SharePoint Bruger Gruppen (SPBG) omkring Office 365, Security & Compliance og GDPR, hvor Ole Kjeldsen fra Microsoft Danmark kommer.
Ole er Teknologi- & Sikkerhedsdirektør og er en af de førende i Danmark inden for sikkerhed i Office 365 og hvordan Office 365 understøtter GDPR.

Ole vil tale om:

Grundlæggende forståelse af GDPR og Office 365.
Security & Compliance Center.
Office 365 Secure Score.

Arrangement er den 22. februar 2018. Fra kl. 9:00 til 12:30. Morgenmad fra kl. 8:00.

Arrangement bliver holdt hos:
Symbion A/S
Fruebjergvej 3
2100 København Ø
Tilmelding sker via Meetup, på http://spbg.dk.

Tak til vores sponsorer. Pointwork for at sponsorerer lokaler og Viteco for at sponsorerer morgenmaden.

ESPC18 - 2 for 1 code

2018-01-16T08:20:00.000+01:00

Hvis du ikke allerede har hørt det, så godt nyt! Europe's største SharePoint, Office 365 & Azure Conference kommer til København i år! Konferencen er fra den 26.-29. november 2018. Hvis du og en ven meget gerne vil deltage, har jeg endnu bedre nyt. Hvis du skriver dig op til en ”2 for 1 code” og køber din billet torsdag den 23. januar og bruger din ”2 for 1” koden, får du en billet gratis.

Link til “2 for 1” kode, https://www.sharepointeurope.com/?utm_source=ESPC+Members+Newsletter&utm_campaign=231ddf873c-EMAIL_CAMPAIGN_2018_01_08&utm_medium=email&utm_term=0_82a101e0da-231ddf873c-237375729

Skal du bruge input til din chef for at få lov til at deltage?

Fordele ved at deltage i ESPC18

På uge, opnå hvad der svare til et 1 år viden opsamling.
Kør forbi konkurrenterne når du lærer det nyeste fra de allerbedste globale eksperter.
Mød 2.000 kolleger fra hele Europa for at dele ideer og se, hvordan de løser de samme daglige udfordringer som dine.
Forbind prikkerne mellem alt hvad du har læst, hørt, overvejet eller arbejdet hele året.

Deploying my website to a Windows Virtual Machine aka deploy to an on-premise IIS webserver.

2018-01-11T08:21:00.000+01:00

The setup where working with Visual Studio Online and have a customer, how is running everything on-premise has been quite frustrating. But not anymore! After the release of the feature “Deployment groups” it is now the easiest thing to do.

To over simplify the tasks for configuring Deployment groups. You need only to create a new deployment group in Visual Studio Online, “register machine” and run some PowerShell. And you are done

The how-to guide to setup and create Deployment Groups can be found here https://docs.microsoft.com/en-us/vsts/build-release/apps/cd/deploy-webdeploy-iis-deploygroups

N.B. The how-to show you need two tasks to deploy the website. This is not correct. This remove these tasks and add the task “Deploy IIS Website/App”.

Before you can release anything, setup you build. By following this how-to guide for ASP.NET 4, https://docs.microsoft.com/en-us/vsts/build-release/apps/aspnet/build-aspnet-4?tabs=vsts

And this how-to guide for ASP.NET Core, https://docs.microsoft.com/en-us/vsts/build-release/apps/aspnet/build-aspnet-core?tabs=gitvsts%2Cweb%2Cdeploy-windows

Print all file in a folder

2017-12-15T19:22:00.001+01:00

Twice a year I have to print a lot of files in different formats. It's easy to do with a little PowerShell:

Get-ChildItem c:\receipt\ | ForEach-Object {start-process $_.FullName –Verb Print}

Deploying Office Online Server 2016 to a security hardened drive

2017-12-04T08:00:00.000+01:00

I was installing an Office Online Server. And properly the easy thing to install in a complete SharePoint farm setup After installing and configuring the OOS farm. I did a bit of testing. But I ended up with this error:

This error only occur on Word file, not PowerPoint or Excel file

After a lot a googling, I found the reason is I installed the OOS on to a D drive “a security hardened drive”.

https://blogs.technet.microsoft.com/office_web_apps_server_2013_support_blog/2013/11/26/deploying-office-web-apps-server-2013-to-a-security-hardened-drive/

Global Office 365 Developer Bootcamp - Cheatsheet

2017-11-16T13:00:00.000+01:00

List of useful links introduce doing the SPBG Global Office 365 Developer Bootcamp:

Test site to send cards through Groups connectors
https://connectplayground.azurewebsites.net/
Configuration site to setup Groups connectors
https://outlook.office.com/connectors/publish
Documentation for cards
https://docs.microsoft.com/en-us/outlook/actionable-messages/card-reference
Card playground. To test and see how cards looks like
https://messagecardplayground.azurewebsites.net/

Add Usage Guidelines Url for Office 365 Group

2017-10-23T08:30:00.000+02:00

While I was configuring Classification for Groups, when I sported the UsageGuidelinesUrl and GuestUsageGuidelinesUrl option. When set, a link appears in the Site Information box.

PowerShell to add, update, read and remove the guidelines urls

Add

# get the settings id default template for Groups
$settingTemplateID = Get-AzureADDirectorySettingTemplate | ? -Property "DisplayName" -Value "Group.Unified" -EQ | select -ExpandProperty ID
#get the tempalte object
$Template = Get-AzureADDirectorySettingTemplate -Id $settingTemplateID
#create a setting object
$newSetting = $template.CreateDirectorySetting()
#set the property
$newSetting["GuestUsageGuidelinesUrl"] = "http://guestguideline.com"
$newSetting["UsageGuidelinesUrl"] = "https://guideline.com"
#save the settings object back to Office 365
New-AzureADDirectorySetting -DirectorySetting $newSetting

Update

#Get the setting id for Groups
$settingID = Get-AzureADDirectorySetting | Where-object -Property Displayname -Value "Group.Unified" -EQ | select -ExpandProperty ID
#Get current settings object with the Groups ID
$setting = Get-AzureADDirectorySetting –Id $settingID
#Update the property
$Setting["UsageGuidelinesUrl"] = "https://my-tenant.sharepoint.com/"
$Setting["GuestUsageGuidelinesUrl"] = "http://public-url"
#Save the settings object back to Office 365
Set-AzureADDirectorySetting -Id $settingID -DirectorySetting $Setting

Read

#read all settings
(Get-AzureADDirectorySetting -All $True).Values

Remove – All settings for Groups!

#remove all settings
$settingID = Get-AzureADDirectorySetting | Where-object -Property Displayname -Value "Group.Unified" -EQ | select -ExpandProperty ID
Remove-AzureADDirectorySetting –Id $settingID

Global Office 365 Developer Bootcamp

2017-09-19T08:00:00.000+02:00

If you work with Office 365 development, the Danish SharePoint User Group (SPBG) has an event that is interesting to you. The event is free, about developments in Microsoft Graph and Microsoft Teams. November 16, 2017. Arrangements consist of theory and hands-on labs. Read more about event and registration at https://www.meetup.com/Danish-SharePoint-User-Group-SPBG/events/243080575/

SPBG ERFA møde omkring Microsoft Teams

2017-07-04T08:00:00.000+02:00

Kom til SPBG erfa møde torsdag den 24. august, i København, og mød Peter Lunding Smith. Peter er Director Cloud & Innovation fra ProActive. Peter vil give en introduktion til Microsoft Teams og fortælle om hvordan du kommer i gang med at bruge Teams og hvad man kan bruge i forretningen. Vi afholder mødet hos Executives' Global Network fra kl. 17:00 til ca. 19 tiden. S.U den 20. august. Tilmelding sker på http://spbg.dk

The lazy man’s Select-Object Expression

2017-03-27T09:00:00.000+02:00

I have known the Select-Object Expression pattern since I started with PowerShell. Where the syntax is this:

select-object @{Name="Property1"; Expression={$_.PropertyObject.Property1}}

But a new PowerShell tip I lean this week is a syntax:

select-object {$_.PropertyObject.Property1}

The big difference is the headline on the column. In the first example, I control the column headline and the second example the headline will be:

$_.PropertyObject.Property1
-----------------------------------------

Microsoft Office Developer Community Events, SPFx, MS Graph og Teams

2017-03-10T09:00:00.000+01:00

Kom til et gratis heldags arrangement omkring udvikling i SharePoint Framework, Microsoft Graph og Microsoft Teams i København den 11. maj 2017.

På dagen bliver der givet en introduktion til udvikling i det nye SharePoint Framework, Microsoft Graph og Microsoft Teams. Kendskab til SharePoint/Office 365 udvikling ikke nødvendig, dog en fordel hvis du kan kode noget i forvejen!

Agenda:

SharePoint Framework.
Microsoft Graph.
Microsoft Teams: Bots, Connectors og Tabs.

Format:
Formatet for dagen vil være, at der bliver en del teori, i form af PowerPoint og demo. Men en rigtig stor del af dagen vil gå med demo, hvor deltagerne selv koder med (hands-on-labs).

Du kan læse mere her og tilmelde, https://www.meetup.com/Danish-SharePoint-User-Group-SPBG/events/238107058/

Microsoft Tech Summit Copenhagen

2017-03-07T09:00:00.001+01:00

Microsoft Tech Summit is comming to Copenhagen. If you have not already seen it, Microsoft is organizing a Tech Summit. The event is free. The event is on March 30-31, 2017. You can read more about the event and sign up for it there https://www.microsoft.com/da-dk/techsummit/copenhagen.aspx

Filter on multible coluFilter on multiple columns in SharePoint rest API

2017-02-28T09:00:00.000+01:00

I’m build a small JavaScript/REST base application for a customer. Where we to filter on three columns. Filter on one column is easy and straight forward. $filter=MyColumn eq 'myvalue’. But filtering on multiple columns is not as apparent. When I was read the documentation on it. It seems you need to add $filter multiple time to the query. But that is not true. The $filter operator shall only be added one time. Insert added AND/OR between them yours filters. Like $filter=MyColumn1 eq 'myvalue’ AND MyColumn2 eq ‘myvalue’. Or in my case, where I need to find an item between a minimal value and a maximum value.

"$filter=BodyRef eq '" + result + "' and Min le '" + size + "' and Max ge '" + size + "'"

Get SharePoint logs

2017-02-27T08:45:00.001+01:00

It is getting old PowerShell script but did need it recently. The script collection log files from all the servers in the farm for a given period.

Tip: $time is the copy/paste value from the SharePoint error message box.

$time = "23-02-2017 11:26:52"
$time = $time.Trim()
$timeToAdd = 10
$startTime = [Datetime]::Parse($time)
$endTime = $startTime.AddSeconds($timeToAdd)
$path = "c:\temp\log $($time.Replace(":", [String]::Empty)).txt"
Merge-SPLogFile -StartTime $startTime -EndTime $endTime -Path $path -Overwrite

Invalid JWT token. Could not resolve issuer token.

2016-09-19T08:42:00.000+02:00

For the second time in three years. I have had the pleasure of encounter a "Invalid JWT token. Could not resolve issuer token." Error. The error comes from a provider-hosted add-in which worked fine the day before. The last time I got the error, I ended up recreate my client ID and client secret both in SharePoint online and need to update my web.config. But this year I was keen on finding a solution! After some time to even understand the error message. I found this article "Replace an expiring client secret in a SharePoint Add-in" https://msdn.microsoft.com/en-us/library/office/dn726681.aspx. Article goes step-by-step how to update your client secret. I have updated the script, as I allready knew my add-in name.

#set the name of my add-in
$displayName = "governanceapp"
Connect-MsolService
$appentry = Get-MsolServicePrincipal -all | ? { $_.DisplayName -eq $displayName}
$principalId = $appentry.AppPrincipalId
$bytes = New-Object Byte[] 32
$rand = [System.Security.Cryptography.RandomNumberGenerator]::Create()
$rand.GetBytes($bytes)
$rand.Dispose()
$newClientSecret = [System.Convert]::ToBase64String($bytes)
New-MsolServicePrincipalCredential -AppPrincipalId $principalId -Type Symmetric -Usage Sign -Value $newClientSecret
New-MsolServicePrincipalCredential -AppPrincipalId $principalId -Type Symmetric -Usage Verify -Value $newClientSecret
New-MsolServicePrincipalCredential -AppPrincipalId $principalId -Type Password -Usage Verify -Value $newClientSecret
#this go into the web.config
$newClientSecret

New event in the Danish SharePoint community SPBG ERFA omkring SharePoint Framework

2016-08-27T02:33:00.001+02:00

A new event in the Danish SharePoint community has been posted on the user group website. Read more about SharePoint Bruger Gruppe (SPBG): Møder at http://ift.tt/2bnC4n9

SPBG ERFA omkring SharePoint Framework

2016-08-25T08:00:00.000+02:00

Hej SharePointer

Kom til SPBG erfa møde onsdag den 21. september, i København, og mød Per Jakobsen. Per er Principal Developer fra ProActive. Per vil give en introduktion til det nye SharePoint Framework og om de nye teknologier som det bygger på. Vi afholder mødet hos KMD fra kl. 17:00 til ca. 19 tiden. S.U den 19. septmenber. Tilmelding sker på https://www.meetup.com/Danish-SharePoint-User-Group-SPBG/

Husk vi flyttet til meetup.com, se mere her https://www.meetup.com/Danish-SharePoint-User-Group-SPBG/

SPBG Office 365 Dev Camp 2016

2016-06-24T08:30:00.000+02:00

Kom til et gratis heldags arrangement omkring udvikling i Office 365 i København den 16. august 2016.

På dagen bliver der givet en introduktion til ASP.NET Core 1.0 og gennemgår Office 365 Dev Patterns & Practices (PnP) (http://dev.office.com/patterns-and-practices). Kendskab til SharePoint/Office 365 udvikling ikke nødvendig!

Agenda:

ASP.NET Core 1.0 introduktion niveau.
Hvad er Office 365 Dev Patterns & Practices (PnP) og basis operationer.
PnP Timer Job Framework.
Authentication Manager.
Site Provisioning Framework og PnP PowerShell.

New event in the Danish SharePoint community SPBG Office 365 Dev Camp 2016

2016-06-23T18:58:00.001+02:00

A new event in the Danish SharePoint community has been posted on the user group website. Read more about SharePoint Bruger Gruppe (SPBG): Møder at http://ift.tt/28RJ25l

SharePoint dinner 09/06/2016

2016-05-10T07:30:00.000+02:00

Så er det tid til SharePoint dinner i København, mere præcist den torsdag 9. juni. Denne gang afholder vi det på TGI Fridays (http://www.tgifridays.dk/).
Læse mere om event her http://spbg.dk/Lists/Mder/DispForm.aspx?ID=85
Hvis du ikke ved hvad SharePoint dinner gå ud på kan du læse om det her "Hvad er SharePoint dinner" (http://sharepointbrugergruppe.dk/Pages/Hvad%20er%20SharePoint%20dinner.aspx)

Obs! Tilmelding sker på https://spdinner20160609.eventbrite.com og seneste den mandag den 6. juni.

New event in the Danish SharePoint community SharePoint dinner 09/06/2016

2016-05-09T19:10:00.001+02:00

A new event in the Danish SharePoint community has been posted on the user group website. Read more about SharePoint Bruger Gruppe (SPBG): Møder at http://ift.tt/1rD7Kdm

Use “runas” when testing different user roles

2016-04-27T08:30:00.000+02:00

A common scenario when testing SharePoint is to switch between multiple user accounts to imitate different user roles. A normal way to do this is to use SharePoints “sign in as a different user” function or right click on a browser/program and use the “run as a different user” function in windows.

The first method can result in you are sign in as the current user when you are browsers other resources dependent on your internet explorer settings.

The second will solve this problem. But you need to enter username and password each time you start a new browser session.

To overcome you need to enter username and password each time. You can use the “runas” program call from a .bat file. With the syntax like this, can you indicate the username. And you only need to enter the password the first time you run the .bat file:

runas /user:[domain\username] /savecred “[path to browser/program]”

e.g.

runas /user:domain\SP13TestAO1 /savecred "C:\Program Files (x86)\Google\Chrome\Application\chrome.exe"

And create a .bat file for each user role, it is easy to switch between user session:

WebAPI plain text response

2016-04-25T08:01:00.000+02:00

I got a problem where the solution was to create a globe JavaScript object and I need to render the data on the server.

I would like to use the JavaScript object like:

<span id="text"></span>
<script>
var d = document.getElementById("text");
d.innerText = resources.hello;
</script>

I started by creating a WebAPI controller and return a string through the Ok method. And end up with this:

This is not JavaScript and there for I can’t use it.

I found an article by Mike Wasson (http://www.asp.net/web-api/overview/getting-started-with-aspnet-web-api/action-results). Where he creates a new IHttpActionResult.

With this new class. I can control the output. So it will be like this: