First of all, thanks for the great examples and all your efforts. I wanted to share this since it took me quite a while to debug (but it did force me to run/debug the SaaS Web app locally which I would do eventually anyways).

Microsoft Graph beta appears to have several additional user properties, including "userType". In my tenant userType = null which causes the following line of code to not return users.

var reuslt = await graphClient.Users.Request().Filter($"userPrincipalName eq '{identity}' and userType eq 'Member'").GetAsync();

Ultimately, if the sample apps are deployed as described, this will result in a 500 internal server error but the underlying problem is really the following line of code which fails since @model is null in SaaSSampleWebApp\Views\Shared\Components\User\Default.cshtml

<span>@Model.DisplayName | @Model.JobTitle</span>

Changing the failing line to the following fixes the problem:
var reuslt = await graphClient.Users.Request().Filter($"userPrincipalName eq '{identity}'").GetAsync();

I'm not quite sure how to get userType to not be null but, either way, for production apps it seems like this check should be optional since customers (of the ISV's app) may also have the field null.

Issue can be reproduced in Graph Explorer for any user with userType: null

https://graph.microsoft.com/beta/users?$filter=userPrincipalName%20eq%20'<user email>'%20and%20userType%20eq%20'Member'

Hope this helps.

Hello everyone,

First of all, I'd like to thank you guys for this code sample repository, it is very useful !

Context : I'm in charge of developing a SaaS offering for two brand new Excel add-ins. We already developed them. We are now at the monetization step.

I'm currently trying to replicate the tutorial from this repository. I managed to deploy the Mock WebAPI, Web App, AppSource and the Outlook Addin on Azure successfully. However, I'm stuck at the Testing step. I guess I did something wrong in the configuration, yet, sadly, I can't find/debug my mistake :(

As I follow along the documentation from this repo, I'm facing an issue when trying to connect to the MockAppSource for the first time. I attached two screenshots below :

• the first one with the first login error : Sorry, but we’re having trouble signing you in.
  AADSTS50011: The reply URL specified in the request does not match the reply URLs configured for the application: 'c9e36b1f-f193-40b0-92b6-3c383c7bba27'.

• the second one, with the Mock App Source redirect URIs setup : https://localhost:44381/ and https://localhost:44381/signin-oidc

Mock App Source First Login Error :

Mock App Source Redirect URIs Setup :

)

Here's the link of the MockAppSource I published if it can help : https://contosomonetizationoutlookaddin-cc1c-test3.azurewebsites.net/

Thanks for your help in advance !

i have finished everything in this tutorial ,and its works fine for SharePoint framework, now i need to setup "/api/Subscriptions/CheckOrActivateLicense/{contoso_o365_addin} API in SharePoint hosted app.

• when i call this API i get unauthorized response .

By following https://github.com/OfficeDev/office-add-in-saas-monetization-sample/blob/master/Deployment/DeploymentGuide.MD, after step:

Clean up

4 . Run the script .\RemoveApps.ps1 -config .\NewApps.json.

I'm receiving:

Get-MgApplication_List: C:\Users\nagao\sandbox\office-add-in-saas-monetization-sample\Deployment\RemoveApps.ps1:15:5
Line |
  15 |      Get-MgApplication -top 400|Where-Object {$_.DisplayName -eq $app. …
     |      ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
     | Insufficient privileges to complete the operation.

Remove Contoso Monetization Code Sample Web App Dev.
Get-MgApplication_List: C:\Users\nagao\sandbox\office-add-in-saas-monetization-sample\Deployment\RemoveApps.ps1:15:5
Line |
  15 |      Get-MgApplication -top 400|Where-Object {$_.DisplayName -eq $app. …
     |      ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
     | Insufficient privileges to complete the operation.

Remove Contoso Monetization Code Sample Web API Dev.
Get-MgApplication_List: C:\Users\nagao\sandbox\office-add-in-saas-monetization-sample\Deployment\RemoveApps.ps1:15:5
Line |
  15 |      Get-MgApplication -top 400|Where-Object {$_.DisplayName -eq $app. …
     |      ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
     | Insufficient privileges to complete the operation.

Remove Contoso Monetization Code Sample Outlook Addin Dev.
Get-MgApplication_List: C:\Users\nagao\sandbox\office-add-in-saas-monetization-sample\Deployment\RemoveApps.ps1:15:5
Line |
  15 |      Get-MgApplication -top 400|Where-Object {$_.DisplayName -eq $app. …
     |      ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
     | Insufficient privileges to complete the operation.

Remove Contoso Monetization Code Sample Word Addin Dev.
Get-MgApplication_List: C:\Users\nagao\sandbox\office-add-in-saas-monetization-sample\Deployment\RemoveApps.ps1:15:5
Line |
  15 |      Get-MgApplication -top 400|Where-Object {$_.DisplayName -eq $app. …
     |      ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
     | Insufficient privileges to complete the operation.

Remove Contoso Monetization Code Sample Excel Addin Dev.
Get-MgApplication_List: C:\Users\nagao\sandbox\office-add-in-saas-monetization-sample\Deployment\RemoveApps.ps1:15:5
Line |
  15 |      Get-MgApplication -top 400|Where-Object {$_.DisplayName -eq $app. …
     |      ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
     | Insufficient privileges to complete the operation.

Remove Contoso Monetization Code Sample PowerPoint Addin Dev.
Get-MgApplication_List: C:\Users\nagao\sandbox\office-add-in-saas-monetization-sample\Deployment\RemoveApps.ps1:15:5
Line |
  15 |      Get-MgApplication -top 400|Where-Object {$_.DisplayName -eq $app. …
     |      ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
     | Insufficient privileges to complete the operation.

Remove Contoso Monetization Code Sample App source Dev.

What should I configure to get the right permissions?

Thanks

I have been building an Excel addin for some time now with the hopes of adding it to the office store.

I'm finding some of the documentation a little unclear because it doesn't quite make sense to me when it comes to licensing.

Why do I need to create a database and manage username, passwords and subscriptions? this seems contradictory to using Microsoft as a provider.

I had assumed that I would submit my app then a user would login with their office 365 account, pay for the app (or subscription) and my client would submit the users token through an API and I would get a response to say they are authorised for the resource I have provided.

I'm not sure what my responsibilities are. Are there any good videos on YouTube or Microsoft that give a good and simple walkthrough how this works?

Any help is greatly appreciated thank you.

While approving the permission for WebAPI, getting following error -

And the sharepoint page giving following error -

How to fix this issue ?

.NET Core 3.1 Support ends December 13, 2022. It would be great if the samples were upgraded to the latest .NET 6 (LTS)

Also, adding code for SSO support (token from Excel client and OBO flow) in the Add-in web apps would be awesome -- maybe just Excel as an example.

Thanks!