sharepoint server – Kerberos Authentication not working in IE

We enabled Kerberos authentication for our on -premise SharePoint web application.

After enabling kerberos, users are able to access the sites in Chrome without issues.

However in Internet Explorer, they get repeated password prompt screen and end up with a error message saying

“Not authorized HTTP Error 401. The requested resource requires user authentication”

I followed all the troubleshooting steps in this article but still get same error:

https://support.microsoft.com/en-us/help/4551934/kerberos-failures-in-internet-explorer

SharePoint Online – Link to Item – Calculated Column

You can CONCATENATE an a tag at the calculated column formula

Something like this Ref

=CONCATENATE("<a href="http://server/sitename/Page.aspx?PageTitle=",Title,">",Title,"</a>")

But you must use the available fields that listed when you build your formula. and unfortunately the Link To Item require ID field that is not available !

Check also @Danny answer at Calculated column with ID removes ID number on update
, URL in calculated column

Unable to load workflow actions from the server. Please contact your server administrator: Sharepoint 2013

When we try to open the workflows in the SharePoint Designer, sometimes we receive the below error:

enter image description here

Symptoms:

You can access the workflow from the SharePoint UI. Other workflows in different web applications are editable.

Cause:

Cannot be same in all the scenarios but should be specific to the features

Capture a fiddler trace while opening the SharePoint designer and you should see a 505 error with the below error tag:

<errorstring xmlns="http://schemas.microsoft.com/sharepoint/soap/">Failed to find the XML file at location
     '14TemplateFeaturescustom solutionfeature.xml'</errorstring><errorcode
     xmlns="http://schemas.microsoft.com/sharepoint/soap/">0x80131600</errorcode></detail></soap:Fault></soap:Body></soap:Envelope>

This is due to the feature which is not available at ’14TemplateFeatures’. If you have a custom solution whose web parts are placed in a web site and the solution files are missing or the solution is retracted, you see this error.

Solution:

Remove the web parts that the solution adds to a site collection using PowerShell/code or deploy the solution back to the farm to get the feature.xml.

Read more about this:

Unable to load workflow actions from the server. Please contact your server administrator

SharePoint Designer 2010 – “Unable to load workflow actions from the server…”

sharepoint enterprise – Incorrect Time on File for date modified in search results

There are several crawled properties for saving the modified date in SharePoint. Read this article for more information (it also has been mentioned in your article).

For the default “Modified” column that contains the last modified date and time information in the list/library, you can move up “ows_Modified” crawl property to the top of the mappings for “LastModifiedTime” managed property. Or, you can create a managed property, map “ows_Modified” crawl property to this managed property and use this managed property instead of “LastModifiedTime” managed property in display template. Run a full crawl after changing managed properties or add new ones.

Besides, you can create custom manage properties, map each of these crawl properties to different manage property. Make sure the managed property is retrievable. Using a Content Search web part to see the value of each managed properties, check the differences between values of these properties.

Central Administration -> Manage Service Application -> Search Service Application -> Search schema -> Create a managed property -> Add mappings.

sharepoint online – How can I create different view based on Different Folder

Create three views like below:

Folder 1 View

Filter “Name” equal to “Folder1”

Folder 2 View

Filter “Name” equal to “Folder2”

Folder 3 View

Filter “Name” equal to “Folder3”

Filter condition should be like below for all the three views:

enter image description here

We can see that three views are created and based on the view selection folder is getting displayed in the content area:

enter image description here

Note:

  • The above UI based view creation can also be done thru the coding using camel query builder.

sharepoint online – slick slider slides are not reducing when we add it in SP Page small section

I am using react slick slider, if i add it in a SP Modern page full section(3 slides) it works perfectly.but if i placed it in the One-third right sections. The same 3 slides appeared with conjusted width even in al sections but i want it to reduce into 2 or 1 slides as per the placed section width.

What should i do to reduce the slides when it is placed on different sized zones.

    export default class ReactSlickSlider extends React.Component<IReactSlickSliderProps, {}> {
  public render(): React.ReactElement<IReactSlickSliderProps> {
    var settings = {
      dots: true,
      infinite: false,
      speed: 500,
      slidesToShow: 4,
      slidesToScroll: 4,
      initialSlide: 0,
      responsive: (
        {
          breakpoint: 1024,
          settings: {
            slidesToShow: 3,
            slidesToScroll: 3,
            infinite: true,
            dots: true
          }
        },
        {
          breakpoint: 600,
          settings: {
            slidesToShow: 2,
            slidesToScroll: 2,
            initialSlide: 2
          }
        },
        {
          breakpoint: 480,
          settings: {
            slidesToShow: 1,
            slidesToScroll: 1
          }
        }
      )
    };
    return (
      <div>
        <h2> Responsive </h2>
        <Slider {...settings}>
          <div className={styles.card}>
            <h3>Lorem Ipsum is simply dummy text of the printing and typesetting industry.</h3>
          </div>
          <div className={styles.card}>
            <h3>Lorem Ipsum is simply dummy text of the printing and typesetting industry.</h3>
          </div>
          <div className={styles.card}>
            <h3>Lorem Ipsum is simply dummy text of the printing and typesetting industry.</h3>
          </div>
          <div className={styles.card}>
            <h3>Lorem Ipsum is simply dummy text of the printing and typesetting industry.</h3>
          </div>
          <div className={styles.card}>
            <h3>Lorem Ipsum is simply dummy text of the printing and typesetting industry.</h3>
          </div>
          <div className={styles.card}>
            <h3>Lorem Ipsum is simply dummy text of the printing and typesetting industry.</h3>
          </div>
          <div className={styles.card}>
            <h3>Lorem Ipsum is simply dummy text of the printing and typesetting industry.</h3>
          </div>
          <div className={styles.card}>
            <h3>Lorem Ipsum is simply dummy text of the printing and typesetting industry.</h3>
          </div>
        </Slider>
      </div>
      
    );
  }
}

SharePoint Online – Explorer View asking for selection of certificate

We have seen this with our customers also. Windows 7 computers that this WebDAV connection has worked fine on stopped working, asking for a certificate first and then a regular “windows native” login prompt that doesn’t seem to have anything to do with Office 365.

It doesn’t ask for a certificate if the personal certificate store is empty. But since there usually is a Skype-certificate there that’s what they can choose.

We’ve tried to use settings both in trusted sites and local intranet zones, as well as reset all Internet Explorer (for the handling of login/certificates in different zones) settings without any luck. WebClient service is running of course and they are logged in with “Remember me” setting. Their colleagues doesn’t have the problem so it seems a bit random. We haven’t been able to recreate it either.

I tried to experiment with adding settings to WebClient in the registry but that doesn’t seem to affect anything (added “*” as AuthForwardServerList for example, also the different domain names that could be affected xxx.sharepoint.com login.microsoftonline.com login.windows.net)

The only thing the computers seem to have in common is Windows 7 (not even windows update level is equal).

Doesn’t feel good at all…

sharepoint online – Help with JSON to format column to show picture instead of URL

I have a contact list created in SharePoint Online.

My list has a column called “Picture URL”.

The “Picture URL” column is formatted as “Single line of Text”.

I have formatted the “Picture URL” column with:

{
   "$schema": "http://columnformatting.sharepointpnp.com/columnFormattingSchema.json",
   "elmType": "div",
   "children": (
     {
       "elmType": "img",
       "attributes": {
         "src": "@currentField",
         "title": "=if(@currentField == '', 'No picture available', @currentField)"
       },
       "style": {
         "position": "relative",
         "top": "50%",
         "left": "50%",
         "width": "48px",
         "height": "auto",
         "margin-left": "-50%",
         "margin-top": "0%"
       }
     }
   )
}

This in the hope that the URL will show as a thumbnail picture.

But all I see is a black square with a White Cross.

SharePoint Modern List view threshold error for Some users

I have migrated the SharePoint list (Exceeds threshold limit) from MOSS 2007 to SP 2019 using ShareGate tool. When I open that list using User A (Same permission as User B) account the List was rendering without any issue but when I open that same list using User B, it show “Something went wrong. List exceeds threshold limit”

Check List

  1. Same List View.
  2. List Permission
  3. List View filters
  4. Indexed Columns (Same as source)
  5. Does not have any view filter like (Me)

Can anyone help to find out the issue

How to get content of file in sharepoint using sharepoint rest api

We need to use the below API:

GET https://mysite.sharepoint.com/<site_name>/_api/web/lists(guid'<list-id>')/items(<item-id>)/File

api of sharepoint using list id and item id obtained from /getchanges api. Then use the ServerRelativeUrl field of response to obtain file contents by calling :-

GET http://mysite.sharepoint.com/<site_name>/_api/web/getfilebyserverrelativeurl('<url>)/$value?binaryStringResponseBody=true

Reference URL:

How to point to/get the file contents or file from SharePoint changes api call

how to get file content from sharepoint list using restapi in java

Similar question discussed here:

https://stackoverflow.com/questions/48422868/how-to-get-file-content-from-sharepoint-list-using-restapi-in-java