Microsoft SharePoint

37K

Solutions

19K

Contributors

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.

Share tech news, updates, or what's on your mind.

Sign up to Post

I am trying to get list item using REST API syntax in SP Designer workflow.
The url format is as follows:

https://example.com/_api/web/lists/GetByTitle('List%20Name')/items(2952)?$select=Description

When I open this link in browser it shows correct data in XML format

    <?xml version="1.0" encoding="utf-8"?><entry xml:base="https://example.com/_api/" xmlns="http://www.w3.org/2005/Atom" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" xmlns:georss="http://www.georss.org/georss" xmlns:gml="http://www.opengis.net/gml" m:etag="&quot;1&quot;"><id>Web/Lists(guid'67dabfd0-ebde-4b62-82d8-bab80a78386d')/Items(2952)</id><category term="SP.Data.Trainings_x0020_CalendarListItem" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" /><link rel="edit" href="Web/Lists(guid'67dabfd0-ebde-4b62-82d8-bab80a78386d')/Items(2952)" /><title /><updated>2018-07-20T09:08:47Z</updated><author><name /></author><content type="application/xml"><m:properties><d:Description m:null="true" /></m:properties></content></entry>

When I am trying to use same url in SP Designer Workflow in *Send Http Get Request**(HarePoint - workflow extensions - https://www.harepoint.com/), I am always getting *404 not found error**

 

    Response Code: 404
    Response Text: <?xml version="1.0" encoding="utf-8"?><m:error
0
Cloud Class® Course: Certified Penetration Testing
LVL 12
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

Migrating from SP2010 to O365. Issues with some stuff "publishing" (I think).  People see different stuff.  It's not security related.  Do you know a PS Script or some way as an Admin to check in an entire Site Collection so I do not run into issues where I am searching for the one file that is not checked in?  I have tried the "All Contents" admin section but it is behaving like SharePoint 2010.  I am aware it may cause disruption but I am not concerned as this is a fresh migration.
0
I am using SharePoint online (365), and am having an issue inviting 'external' users to a site collection. A few months ago, inviting users to the site worked without issue. We were able to share the site with multiple users on different domains, and each was able to view with the proper permissions they were assigned (invited from a group in "People & Groups"). I recently encountered an issue using the "Share" command, or trying to add users to groups. Doing so resulted in a pop-up error "Could not resolve memberid, (followed by the user i was inviting)"; after clearing the browser cache, this issue ceased, and I was able to invite people without getting any errors. The user would show up in the SharePoint groups & Office 365 "People" as 'user_domain_com#ext#sharepointdomain.onmicrosoft.com' after sending the invitation, and the link would send to their email; however when they use the link, they get the following:

If I invite 'user@domain.com', the message is:

"Access denied, the user 'user_domain_com#ext#sharepointdomain.onmicrosoft.com' does not have permission to view the site."

The user's email, name, and info seems to be correctly adding to the groups I assign & invite them to. External sharing is turned on at the top site collection level, and on the site itself. I have checked both via the SharePoint admin center, and the "Site Settings". Additionally, Azure AD shows them as "Users" with their proper email addresses.

Thanks
0
I have a formula for a sharepoint calculated field that has worked great but I now need to adjust it and its a bit more complex than I can figure...

Current Formula
=IF(ttl_qsr>0,"L1",TCVDealCat)

In the formula above basically my field is set to L1 if ttl_qsr>0 otherwise it is set to TCVDealCat value

Now I need to accommodate the following:
Set field to L1 if L1esc > 0 IF L1esc is blank then Set field to L1 if ttl_qsr > 0
Set field to L2 if ttl_qsr > 0 AND if TCVDealCat is not = L1
otherwise set field to TCVDealCat

Will this work?
=IF(ttl_qsr>0,"L1",IF(AND(L1esc>0,TCVDealCat<>”L1”),”L2”,TCVDealCat))

Also I need to make sure that if scenerio 1 is hit that scenrio 2 does not override
0
Hi Experts,

I wrote a SharePoint(2013) web parts using visual studio(2017) and deployed in windows server 2012.
Only co-worker and I accessed it, but a few instances of iexplore.exe are spawning like every hour in task manager and it gets more than 60 over night and we had to perform clearconfig cache and iisreset /noforce on the servers in farm,
However, I found out that if I deploy this web parts app thru the visual studio and test, this is NOT happening.
I am not 100% sure but I don't think this is code issue, but server issue. I googled, but couldn't find any SharePoint web parts and IE spawning multiple processes issue.
 
Any comments or tip will be appreciated.
Daniel
0
I have a Date Time Field in SharePoint 2013, and I am using it in a calculated field as below:
example data:  6/4/2018 8:31 AM

Below Calculated field:
=HOUR([Date Closed])-7

Problem: This returns only numeric hour based on 24 hour clock.  

For example when I use formula: TEXT(HOUR([Date Closed])-7,"hh:mm" ) ,  The result is (20-7) and results are 13 hours, which would be incorrect based on 12 hr. clock.

I would like to subtract actual time of (8:31AM-7AM)  with result in format hh:mm    -   1:30

Can anyone please assist with how to get result of  this in hh:mm based on 12 hour clock.

thanks,
0
Heads-up: Though its little tricky to explain my scenario i will still try my best to explain as clearly as possible.

I have 4 RadGrids(with Column Picker for each RadGrid) on same page & switching between Radgrids doesnt load the current RadGrid name when looking in view source. Though the Data is loaded for different RadGrids.
Issue is with Column Picker.

Requirement: On Change of a RadComboBox List value a different RadGrid has to loaded. Each RadGrid has a COlumn Picker too.
Column Picker -> (list of columns in RadGrid is bided on serverside to a RadListBox and shown in a RadWindow invoked using Javascript )

Basically i have 4 RadGrids(RadGrid1 through RadGrid4) each of which has CommandIteamTemplate -> & asp:LinkButton OnClientClick opens a RadWindow with list of RadGRid Columns whose Display value is True.
Also these 4 RadGrids are 4 seperate user controls with their own unique Javascript methods and Radwindows.

But When ever i chaneg my RAdCombobox value though a different RadGrid is loaded ... Column Picker still shows from the previous RadGrid. At this moment when i look at the view source it still shows previous RadGrid name with java script methods from the same previous RadGrid.

Example: On my Main Page,
Step 1: on page load, RadGrid1 from first user control is loaded with Column picker1 - which was loaded using Javascript1.
sample code in CommandTemplateItem.. <asp:LinkButton ID="lbtnCP" runat="server" …
0
Need to override lock file in sharepoint 2013. Users will open a file and then lock their system which locks the open file and need the ability to override the lock file?
0
cannont publish from sharepoint using INFOPATH 2013 on windows 10.
could publish from sharepoing using infopath 2013 on windows 7.

"infopath cannot save the following form: "*********"  network problems are preventing this file from being saved.
InfoPath cannot save teh following form:  "******" This document library was either renamed or deleted, or network proglems are preventing the file from being saved.

what are the easiest, most low cost solutions to this?
0
I had this question after viewing SharePoint 2010 Calculated Column Calculate Business Hours Between 2 Date/Times.


Can you provide a detailed explanation of your parameters for the numeric values that you are providing.
My business day is from 7am - 8pm :  total 13 hour day.
0
Cloud Class® Course: C++ 11 Fundamentals
LVL 12
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

Hi,

Is there one example in SharePoint list that one date change would trigger one defined alert automatically? For instance, I put deadline column to beJuly18, and after two days, alert message would be automatically sent out.
0
2 questions:

1.  When using Sharepoint online, if i go into Admin centers and then Sharepoint there is a list of sites, I assume they are default sites. I assume those are for the whole company? If i create a new site I assume by default is is private and only i can see and access it unless i share it out or give someone else permissions correct?

2. is it possible to do the following create in a site
- 1 site that contains multiple folders
- each folder is assigned to a different administrator outside of the default administrator
- the 2ndary administrator is allowed to assign permissions to files within that folder to users
- each folder and files in there will have it's own permissions and enforced by azure AD
0
Looking for help with a javasript to help control fields on a sharepoint custom list form...

Variables are:

F01-a
F01-b
F01-c
F01-d

All questions are drop downs with initial allowable selections of Yes, No or N/A

if F01-a is No then F01-b , F01-c & F01-d either don’t show or are forced to N/A only
if question F01-b is No then F01-c & F01-d don’t show or are forced to N/A only
if question F01-c is No then F01-d don’t show or is forced to N/A only


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<html dir="ltr" xmlns="http://www.w3.org/1999/xhtml">

<head><meta name="ProgId" content="SharePoint.WebPartPage.Document" /><meta http-equiv="Content-Language" content="en-us" /><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><title>
	Untitled 1
</title>
<!--mstheme--><link id="onetidThemeCSS" rel="stylesheet" type="text/css" href="../../_themes/Breeze2/Bree1011-65001.css" /><meta name="Microsoft Theme" content="Breeze2 1011, default" />

<style type="text/css">
.style14 {
	text-align: center;
	font-size: 11px;
	border: 1px solid #808080;
	background-color: #F3F3F3;
	font-family: Arial, Helvetica, sans-serif;
}
.style14a {
	text-align: center;
	font-size: 11px;
	border: 1px solid #808080;
	background-color: #A8C0DB;
	font-family: Arial, Helvetica, sans-serif;
}
.style15 {
	font-family: Arial, Helvetica, sans-serif;
	font-size: 12px;
	background-color: #FFFFFF;
}
.style16 {
	

Open in new window

0
Trying to troubleshoot Problems with SharePoint environment. Server: Windows 2012R2 Standard. SharePoint 2010 server version 14.0.7015.1000. We might have more than one issue here haven't narrowed down.

We have a user complaining that their Version history on Excel Does not display history or version on desktop apps example: Excel. (See Attached). When viewing on the SharePoint web portal we can see the modified and revision history.

We started looking into the logs and found countless numbers of Event ID 10016 errors:
The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID
{8BC3F05E-D86B-11D0-A075-00C04FB68820}
 and APPID
{8BC3F05E-D86B-11D0-A075-00C04FB68820}
 to the user **domain\username** SID (S-1-5-21-3100772813-4073630589-3070870144-1537) from address LocalHost (Using LRPC) running in the application container Unavailable SID (Unavailable). This security permission can be modified using the Component Services administrative tool.
File_History_All_Blank.JPG
Developer-tab-version-history-excel.JPG
0
Hello,

I want to send remainder mail to the employee who apply for the leave only when his joining report is pending.
Having two list Leave request and other is for Joining report list.

1. Leave Request List:


2. Joining Report List:

Send remainder mail after 3 day of Reporting Duty only if he/she not fill his joining report.

Please give some solutions.
0
I am attempting to create a Powerapp from existing Sharepoint list. I am stuck on trying to get a drop-down list working with a column that has choices setup on the sharepoint list. Any tips? Datasource is fine, i can choose the correct columns but error is not very helpful
0
need connect different database as such Mysql and Oracle to the sharepoint by web service
but the issue is oracle cannot connect
i need online help
0
I want to be able to stop my o365 users from accessing one drive, SharePoint and teams from their home pcs and mobiles.

Conditional access and in tune seems to be the way to go. For mobiles it looks straight forward that the user must enroll their device. But what about laptops and pcs.

I want my company laptops (which are not all joined to the same AD domain) to be able to access where ever they go but I do not want these sane users installing on their home machines.

What should I do and please I can google : ) this question is specifically around pc access, thanks
0
The company I work for recently began deploying Office 2016 upgrades to end users previously using Office 2010. We've found that the accidental use of working with files directly from online SharePoint/OneDrive repository opposed to working from local files (which automatically upload to OneDrive) causes various issues with file upload conflicts, slowness working in files, etc.

Microsoft support provided a solution with a combination of a couple registry key creations/edits and Office settings to basically remove/hide OneDrive for Business and SharePoint from the File>Open and File>Save menus in Office 2016 suite applications for Windows 10, they unfortunately could not provide any solutions for Windows 7 and stated that this was not possible. Has anyone else ran in to this challenge that can give their insight and/or workaround?
0
Cloud Class® Course: Microsoft Office 2010
LVL 12
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

We are using Sharepoint with OneDrive. We need to make it so that only the files we are using sync to our computers and then synced to back to Sharepoint and removed when we are done with it. Right now, everything in OneDrive cloud storage keeps trying to sync and it is filling up our local hard drives. Is OneDrive the correct tool, or is there a better way to accomplish this?  

When I install OneDrive I see the option to select which folders will sync, but cannot get down to the file level. Also, there are no options to have documents removed from local drive once we I am done working on them.
0
A consultant created our sharepoint site using livetiles. (Site creation was done, then they sent me out for back end sharepoint training.)
While I was getting training, I asked the instructor about livetiles, and his statement was that, based off of what he could see, anything we were using livetiles to accomplish, could be done natively in sharepoint online.

I mentioned this, and now have been tasked with creating the site without using livetiles, but maintaining the same look.
I don't know how livetiles is changing the top navigation bar, as shown in the image.
Navigation bar with Livetiles
When I create a new page, the navigation bar looks normal, like this:
without-livetiles.JPG
How do I mimic the livetiles look using native Sharepoint online?

Bartender_1
0
ImageHello Experts,

I have an Article Content Type that I'd like to display all of the Articles, on separate pages based on a Choice Field Item.  Any help on how I can achieve this is very much appreciative.
Using SharePoint 2013 On-Prem.  I don't need help on creating the content type, only on how to get them to display on their own pages that are page-able.  To also include the Title, an image, and part of the Body.
 
0
Looking for some assistance with a sharepoint calculated field formula...

Four Fields
f01-a
f01-b
f01-c
f01-d

If f01-a=Yes & f02-b=Yes & f01-c=No
If f01-a=Yes & f02-b=Yes & f01-c=Yes & f01-d=No

in both cases field should be set to Yes if neither combination is true then field is No
0
SharePoint 2016 - Customize "Web Pages/Sites"?

My company started using SharePoint 2016. We (my team) were given a "Team Site/Portal" with pretty much full control.
I want to customize the look and feel and build it out.

Question is, what are the "boundaries/limitations" of what I can customize/ cannot customize? As in, can I create an
html page in an external text editor and upload it, etc. (as I'd do with a website/domain), or am I limited to having to edit
and make changes (as is) with what's there in the built-in edit controls?

Basically, just trying to get an idea of what I'd be able to do - supported web languages i.e. HTML5, Javascript, CSS, C#, etc.
and what kind of editors I could use i.e. VS Code, Sublime, or SharePoint "built-in" only?

Thank you!
0
I have the code below that I dug up here is the setup and what I am trying to accomplish

Q1A field- _x0046_47 Q1B field- _x0046_46 Q1C field- _x0046_45 Q1D field- _x0046_44

If Q1A = No then Q1B,Q1C & Q1D = N/A
If Q1B = No then Q1C & Q1D = N/A
If it gets to this point Q1C & Q1D should show Yes, No or N/A

$().ready(function () {
function getCascadingByDropdown(CascadingListTitle, LookupFieldName, DropdownValue, IsMock) {
    var dfd = $.Deferred();
    //Set IsMock as False in real ENV
    if (!IsMock) {
    } else {
        var values = [];

        values = ["Yes", "No", "N/A"];

        if (DropdownValue === "Yes") {
            values = ["Yes", "No", "N/A"];
        } else if (DropdownValue === "No") {
            values = ["N/A"];
        } else if (DropdownValue === "N/A") {
            values = ["N/A"];                
        }

        dfd.resolve({ 'values': values });
    }

    return dfd;
};
function FillInCascadingQ1B() {
    var Q1a = $("select[title='_x0046_47']").val();
    getCascadingByDropdown("Q1b", "Q1a", Q1a, true).done(function (data) {
        $("select[title='Q1b']").empty();
        for (var i = 0; i < data.values.length; i++) {
            $("select[title='Q1b']").get(0).options.add(new Option(data.values[i], data.values[i]));
        }
    });
};
function FillInCascadingQ1C() {
    var Q1b = $("select[title='_x0046_46']").val();
    getCascadingByDropdown("Q1c", "Q1b", Gate, true).done(function (data) {
        

Open in new window

0

Microsoft SharePoint

37K

Solutions

19K

Contributors

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.