Excel Sheet Read-Only

we have an issue that the user once clicked on the excel/word/PPT file it opens as Read Only, the changes made on the file can not be saved to the original file located on the SharePoint library !! but when you open the file uploaded on the SharePoint from the using “open with Explorer” you can edit the file and save the changes. Any one can assist? enter image description here

Disable the option to edit SP document library in Desktop Word Application

I want to change my document libraries in Sp Online to allow staff to view, download and open in Word Desktop App, however I do not want them to be able to edit the document once it opens in the Word Desktop Application — only to Save As another name on their PC. I want to prevent them from altering the form in SP in any way. What do I do? Thx. Caulene

Disable the option to edit SP document library in Desktop Word Application

I want to change my document libraries in Sp Online to allow staff to view, download and open in Word Desktop App, however I do not want them to be able to edit the document once it opens in the Word Desktop Application — only to Save As another name on their PC. I want to prevent them from altering the form in SP in any way. What do I do? Thx. Caulene

Connect-SPOService : Could not authenticate to SharePoint Online

I am unable to connect to SPO from SharePoint online management shell using my account. MFA is enabled.

I’m executing the following command:

Connect-SPOService -url https://[URL].sharepoint.com 

And I get the following response:

Connect-SPOService : Could not authenticate to SharePoint Online  https://[URL].sharepoint.com/ using OAuth 2.0     At line:1 char:1     + Connect-SPOService -url https://[URL].sharepoint.com     + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~     + CategoryInfo : NotSpecified: (:) [Connect-SPOService], AuthenticationException     + FullyQualifiedErrorId : Microsoft.Online.SharePoint.PowerShell.AuthenticationException,Microsoft.Online.SharePoi     nt.PowerShell.ConnectSPOService 

Can anyone help with this?

Thanks.

Google Analytics: Exit page report differs from conversions

I have an issue determining my checkout pages exit percentage.

Looking at the site’s database event information for a single day I am given the following information:

  1. Entered checkout – 306
  2. Completed Checkout – 249
  3. 81% completed (completed / entered checkout)
  4. 19% exited (remainder)

When I look at my reporting in Google analytics I am given the following information:

  1. Entered checkout – 304
  2. Completed checkout – 247
  3. Exits – 26
  4. Exit % – 0.09% (exits / entered checkout)

So what reason would there be for my Exit % to be different than the math between the difference of entered and completed checkout?

Thanks in advance!

Can I set the value of field for a custom list based on which custom form a user chooses?

New developer. Be gentle, please.

Constraints: I am using SharePoint Designer and SharePoint 2010 behind a firewall so I can’t upload pretty much anything without going to my helpdesk and getting a tech person to do it for me.

Situation: We track “Activities”. There are many points of origin for an Activity request. Different clients give us different information and are going to need custom forms (custom new item forms created through SPD). However, all these forms will create new items for the same custom list, “Activity Management”, and I have workflows already in place to create a new Activity Number each time one is created based on a batch of other stuff that is probably not super relevant. All these workflows were designed for only 1 custom form, though.

I need to create a second form and have it not trigger some of my workflows at this time. My idea is to have my new custom New form auto-fill/pre-populate on load/etc a field that identifies which form it is. Then I just have to make a condition at the top of my workflow to not activate for that form. Then we can do it later by changing that field to a value of my choice, now triggering the desired workflow.

I just can’t figure out how to simply set the value of a field within the html of the form – not hiding anything, not making the field a cascading anything, nothing fancy. I have a default inside the SharePoint List Settings that is “No Form” for when I do things manually. Once I figure this out for this form, I’ll imitate it for each custom Change or Activity request. And we can have as many entry points as my bosses need…

Potential Paths to a Solution: Can I do this within table row itself?

               <tr>                     <td width="190px" valign="top" class="ms-formlabel">                         <H3 class="ms-standardheader">                             <nobr>Form Used</nobr>                         </H3>                     </td>                     <td width="400px" valign="top" class="ms-formbody">                         <SharePoint:FormField runat="server" id="ff95{$  Pos}" ControlMode="New" FieldName="Form_x0020_Used"  __designer:bind="{ddwrt:DataBind('i',concat('ff95',$  Pos),'Value','ValueChanged','ID',ddwrt:EscapeDelims(string(@ID)),'@Form_x0020_Used')}"/>                         <SharePoint:FieldDescription runat="server" id="ff95description{$  Pos}" FieldName="Form_x0020_Used" ControlMode="New"/>                     </td>                 </tr> 

Or, maybe there is a really nifty javascript thing that could be used…

<script type="text/javascript" language="javascript">     function setff95() {         Something     } </script> 

SharePoint Online profile picture sync from AAD

Hope someone here can help with an issue which is strange and new to me.

We have hybrid environment, running both SharePoint on-premises and Online. We have lot of services running in our organization. One of it is, employee directory where user has an option to change their profile picture. (This is the only place if they want to change any profile related information including profile picture). We have blocked users to change profile picture everywhere using exchange policies. Also, we have modified the default option for editing picture in SharePoint Online user profile service – “Picture” property and unchecked the option “Allow users to edit values for this property”.

Now, as a result if they are going to skype for business, exchange or SharePoint they do not see option for change the profile picture.

Problem:

When user updated the profile picture in Employee Directory application, the profile picture will be updated in AAD. Once AAD has the latest image all service in O365 gets the updated image except SharePoint Online.

Is this because we unchecked the property of “Picture” in user profile service? As I understood, this option is just to disable the option for upload picture in Delve. But it is also not syncing picture from AAD.

Anyone has anything to say?

thanks in advance

-Praveen.

The property or field ‘ItemCount’ has not been initialized. It has not been requested or the request has not been executed

I have the following code inside our server-side event receiver, the code should connect to a sharepoint online list and get the total number of items, here is the code:-

   try    {      currentItem["Status"] = "Pending";      if (currentItem.ContentType.Name.ToLower().Contains("project"))         {             using (ClientContext context = new ClientContext("https://***.sharepoint.com/"))            {              string s = "***";              SecureString passWord = new SecureString();              foreach (var c in s)              passWord.AppendChar(c);              context.Credentials = new SharePointOnlineCredentials("admin@****.onmicrosoft.com", passWord);              List list = context.Web.Lists.GetByTitle("Project");              context.ExecuteQuery();              var countItems = list.ItemCount;            }          }    }    catch (Exception e)    {      var errormessage = e.Message;    } 

but i am getting this exception:-

Microsoft.SharePoint.Client.PropertyOrFieldNotInitializedException was caught   HResult=-2146233079   Message=The property or field 'ItemCount' has not been initialized. It has not been requested or the request has not been executed. It may need to be explicitly requested.   Source=Microsoft.SharePoint.Client.Runtime   StackTrace:        at Microsoft.SharePoint.Client.ClientObject.CheckUninitializedProperty(String propName)        at Microsoft.SharePoint.Client.List.get_ItemCount()        at OrderManagement.EventReceiver1.EventReceiver1.ItemUpdated(SPItemEventProperties properties)   InnerException:  

So can anyone advice how i can fix this issue?

SCSS in Sharepoint Framework Library Project

Looking for the proper way of constructing my projects. I decided to use 1 project per web part however is have a number of classes and react components that are common to all projects. So I created a library project and moved my common classes there. I used npm link to link both projects and all seems to be working well. My question is around SCSS files. Again I have a few that are common across all webparts. I know I can use the cdn to serve these files but i was wondering if i could use my current library project. If so, how do i “export” the SCSS as i do my ts and tsx files in the index.js? Any help is greatly appreciated

hide webparts via JQuery on SharePoint Online

I have a page with multiple web parts. I have four buttons in a web part

<div id="buttons">    <div class="gmcButton" id="About GMC">About GMC</div>     <div class="gmcButton" id="Key Features">Key Features &amp; Changes</div>     <div class="gmcButton" id="Implementation And Rollout">GMC Implementation<br/>and Rollout</div>     <div class="gmcButton" id="GMC Resources">GMC Resources<br/></div> </div> 

In a second web part zone are the four list view web parts. On page load, I have a Jquery function that loops through the four web parts and hides all but the default part.

function loadPanels(){  $  ('.js-webpart-titleCell').each(function (j){     var title = $  (this).find('h2.ms-webpart-titleText').text();     if(title!="About GMC"){                 $  (this).parent().parent().parent().addClass("hidden");             } }); 

}

This works. All but the default “About GMC” web part hide. What happens though when I click the buttons on the page is that the title of the web part changes to the appropriate title, but the contents of the web part do not change. If I examine the CSS in the DOM explorer, the entire web part has the correct class applied, but it is not changing the display from the default web part content. What am I doing wrong?