sharepoint online – Get Display names of Direct reportees in Office 365

I need to get display names for all the direct reportees under a manager. I am using below code to get direct reporteees using rest in SPFx using react.

getReportees = () => {
    var reportees = ();
    var reactHandler = this;
    var drReportess = ();
      url: this.siteUrl+"/_api/SP.UserProfiles.PeopleManager/GetPropertiesFor(accountName=@v)?@v='" + encodeURIComponent(accountName) + "'&$select=DirectReports",
      method: "GET",
      headers: { "Accept": "application/json; odata=verbose" },
      crossDomain: true
      let length: Number = data.d.DirectReports.results.length > 0 ? data.d.DirectReports.results.length : 0;
        $.each(data.d.DirectReports.results, function (i, value: string) {
            url:  this.siteUrl+"/_api/SP.UserProfiles.PeopleManager/GetUserProfilePropertyFor(accountName=@v,propertyName='PreferredName')?@v='" + encodeURIComponent(value) + "'",
            method: "GET",
            headers: { "Accept": "application/json; odata=verbose" }
              Title: data.d.GetUserProfilePropertyFor,
              LoginName: value
          directReportees: drReportess

problem with this code is the render function is loading first before completing the rest call so DOM is empty.

office 365 – Can I embed an excel file in a sharepoint page so it can be used, but not downloaded?

I have an instructor who teaches excel, and wishes to administer an exam, but doesn’t want the students to be able to download the file.
Is there a quick way to embed the excel document into a SharePoint page and remove the ability to click a button to download?

Sharepoint 2016 crashes after MS Office 2016 64bit installation


Have been stumbled upon a very unusual issue – after MS Office installation all web applications (bad practice, i know), including central admin, return a 503 error. Reason is application pools in stopped condition. Any attempt to start up application pool fails.

There are no errors in Sharepoint Logs – only in event viewer. This and this

Faulting application name: w3wp.exe, version: 10.0.14393.0, time stamp: 0x57899b8a
Faulting module name: KERNELBASE.dll, version: 10.0.14393.2457, time stamp: 0x5b7e2adb
Exception code: 0xc06d007e
Fault offset: 0x0000000000033c58
Faulting process id: 0x1fcc
Faulting application start time: 0x01d63281c5b132ed
Faulting application path: c:windowssystem32inetsrvw3wp.exe
Faulting module path: C:WindowsSystem32KERNELBASE.dll
Report Id: ef188be8-b68e-4cbd-b7e3-82279f93967e
Faulting package full name:
Faulting package-relative application ID:

and this

The Module name SharePoint14Module path C:Program FilesCommon FilesMicrosoft SharedWeb Server
Extensions16isapiowssvr.dll returned an error from registration. The data is the error.

I looked up a little bit – Enable 32-bit application is set to false, manipulations with ApplicationHost.config doesn’t bring anything.

Does anyone have any idea what is source of this troubles?

Thanks in advance!

outlook – Office 365 migration PST

I’have a little problem… I can’t migrate from Outlook to Office 365. Infact to be precise, I can’t get into the cloud. my version of 365 is E1

He tells me that I am not authorized to identify myself on Azure while it is my admin account.

I am not added as an external user at the level of Tenant in AzureAD what do you think about that ? do you have the seem problem ?

ms office – Microsoft Teams Camera Shows Black Screen

Having tried a Mac Mini and MacBook Pro, Microsoft Teams shows a black screen in the video preview during calls. Others on the video call see the same black screen.

This issue has manifested on the MacBook with built-in camera, and with a Mac Mini using an external Logitech C922 camera connected via USB.

On iPhone and iPad using the Teams app, the same user can make video calls perfectly.

How can this be fixed?

office365 – Open Office 365 documents in view mode by default

Is there a way to set the default mode to view-only in Office 365 online apps (word, excel…etc)? I usually work with documents written by others, and I want to open them all in view-only mode to prevent accidental changes. Google didn’t really help. It seems people either have the opposite problem or the suggested solution is to update individual document protection status, which isn’t feasible in my case.

Office Mobile not installed yet opening PDF files

I have a Samsung A50 phone, stock Android which came with the device (from Comcast), everything up to date and not rooted. I have not registered for the Samsung Galaxy store or whatever is called, and therefore never installed anything from it.

I never installed Office Mobile on my phone, and looking at the list of installed apps in Google Play shows no Office Mobile.

Yet, starting today, attempting to open some (but not all!) PDF files (by tapping their name in the Document folder) opens them in Office Mobile rather than the “Google Drive PDF viewer” where they did open till the day before yesterday (I did not try yesterday).

There is not an option to force opening the files in “Google Drive PDF viewer”. For a test, I installed the “Google PDF Viewer” (I wish they chose less similar and less confusing names). After that Android allows me to open the files with “Google PDF Viewer”, but it fails with “Cannot display PDF (no file received)”. After a reboot, the files were gone.

What may have happened? I can guess that the files corrupted and the “Google Drive PDF viewer” magically knew (and therefore was not proposing itself to open them), whereas the other two apps did.

Yet, why is there an app which I never installed and does not show up in the list of installed apps? Heck, if I search for it in Google Play, I even find it, and it shows me the option to install it!

Can I have multiple "farms" under a single tenant on SharePoint Online / Office 365?

Migrating to Office 365 soon and wanted to know if I could have multiple SharePoint ‘Farms’ under one Tenant? We have 3 business units we want to keep separated, but allow smooth User experience if a User needs to hop around to different ‘farms’.

ms office – If And formula not throwing right response, but pieces of formula work fine separately

I’ve been working on some spreadsheets and previously the formula for returning a value based on some if and conditions would look like this:

IF(AND($NR4 '2010-06-02'="x",$2D PATTERN CO '2010-06-02'=D$1,$High '2010-06-02'>($Open '2010-06-02'+$Stretch '2010-06-02')),$Close '2010-06-02'−($Open '2010-06-02'+$Stretch '2010-06-02'),"No Pattern")

Basically the formula is looking for a pattern in column D in this case, from a selection along row 1, and this formula is done for patterns of varying length and days. If the pattern matches for that day, and the other conditions are met, the formula calculates a value, if not then “No Pattern” is returned. It works absolutely fine on its own, no problems here.

Like this I have to redo the formula for all sorts of different combinations of different length patterns, ranging from 2 to 5 characters in length. For example, the following, copied from the second And condition in the formula above, is for 2 characters:

$2D PATTERN CO '2010-06-02'=D$1

If I wanted to change this to 3 characters, I would have to change that formula to:

$3D PATTERN CO '2010-06-02'=D$1

I then paste this over to the other 3 character patterns, and repeat for the other lengths.

Sometimes the other 2 conditions in the main If And formula will change. If I want to redo the formula to meet those different conditions for all cells, instead of changing the formula once and pasting it to match style all over the data, I have to first do the change for patterns of length 2, then length 3, and so on…

That was getting kind of long, so I figured I’d add nested if conditions to make that easier based on the length, so that the formula could automatically pick the right column from the other sheet automatically based on pattern length, which looked like this:

IF(LEN($D1)=2,$2D PATTERN CO '2010-06-02',IF(LEN($D1)=3,$3D PATTERN CO '2010-06-02',IF(LEN($D1)=4,$4D PATTERN CO '2010-06-02',IF(LEN($D1)=5,$5D PATTERN CO '2010-06-02',"ERROR - LENGTH OF STRING COULD NOT BE DETERMINED"))))

Added to the above formula, this would look like:

IF(AND($NR4 '2010-06-02'="x",IF(LEN($D1)=2,$2D PATTERN CO '2010-06-02',IF(LEN($D1)=3,$3D PATTERN CO '2010-06-02',IF(LEN($D1)=4,$4D PATTERN CO '2010-06-02',IF(LEN($D1)=5,$5D PATTERN CO '2010-06-02',"ERROR - LENGTH OF STRING COULD NOT BE DETERMINED"))))=D$1,$High '2010-06-02'>($Open '2010-06-02'+$Stretch '2010-06-02')),$Close '2010-06-02'−($Open '2010-06-02'+$Stretch '2010-06-02'),"No Pattern")

However, the formula always outputs “No Pattern” now. I already have a completed spreadsheet where I did the data based on length manually, so when I paste this across all that data should be identical, just that it selects the correct cell discussed before on its own.

The strangest bit is, if I do the nested if conditions on their own in a separate cell, the formula returns the right result. I’ve tried surrounding the formula in its own brackets, thinking maybe it was a bug and it didn’t like all those ifs, but that didn’t do anything.

I’d really appreciate some help on this as it would save me a LOT of time; I need to do about 10 different combinations of conditions with the data, and that is the only condition that doesn’t change over the 10. If I had to do it manually for each length that 10 would turn into 40 and a hell of a lot more clicking!

Thanks in advance, and stay safe out there!!!!


sharepoint online – CSOM Utility.SendEmail() will only send email to office 365 email addressees… is it a limitation?

I have the following code inside my CSOM console application to send email:-

static private void sendemail(ClientContext context, string subject, string body, string email)
            var emailp = new EmailProperties();
            emailp.Subject = subject;
            emailp.Body = body;
            List<string> toUsers = new List<string>();
            emailp.To = toUsers;

            Utility.SendEmail(context, emailp);

now the email will be sent correctly incase the to email is defined inside office 365,otherwise no email will be sent. any idea why?