Tag Info

New answers tagged

0

SharePoint List Synchronizer is working for me to restore automatically the two-way synchronization feature between Excel and SharePoint online lists. I found it very reliable and easy to use!


0

On the left navigation panel, click on Workflows. Up on the ribbon, in the Save group, click on Save and then click on Publish. You should then see your workflow showing up in your list.


0

Calculated Columns set to datatype=Number can output HTML. But only in Views So you could build your own link with ="<a href='" & [MYURL] & "'>" & [MYLINK] & "<a>" Note: you can't use an existing Hyperlink column in a Formula, because a Calculated Column can't expand complex Fields (for the same reason you can't use Created ...


4

Seems to me you have not a complete understanding of the logic you are trying to write? Let me give you an example of how your code works now: You have items 1 2 3 4 5 6 7 8 9 10 You retrieve them backwards (say you set RowLimit=5 for now) so you will get: 10 9 8 7 6 Then you save the 6 in a variable When the user click on "Show more" or whatever, ...


0

You can use CSOM (client object). You can use the ListItemCollectionPosition class to implement paging list item retrieval according to the position of items relative to their collection. Use the RowLimit element to specify the number of items to return per page. You can create a Excel with the Items using OpenXML. Some links: ...


0

I've ran into this as well. I believe I ended up having to use the OData Connection in Excel pointed to ListData.svc to get around it.


1

Correct, only the current version impacts the LVT.


0

#get web and ct $web = Get-SPWeb http://your/site/name $ct = $web.ContentTypes["CT name"] #get the column from the web $spFieldLink = New-Object Microsoft.SharePoint.SPFieldLink ($web.Fields["alias"]) #Remove the field from the ct and update $ct.FieldLinks.Delete($spFieldLink.Id) $ct.Update() #dispose the web-object $web.Dispose()


0

Open your SharePoint list in Microsoft Excel. To do this, navigate to your list in your browser > from the ribbon click the List tab > under the Connect & Export group click Export to Excel. In Excel, highlight all the data including the headers > click the Insert tab in the ribbon > click PivotTable > click OK in the Create PivotTable window that pops ...


2

It's because $lista is $null. Are you sure this is correct title of the list? In PowerShell you won't get error when you try load list with incorrect title. You also won't get exception executing follofing: $null.Something foreach ($a in $null) {} That's why you get an exception so late, on the Update() method. You should also use Get-SPSite instead of ...


2

I think you should check on 2 things In $item["title"] you should use casing, because SharePoint understands Title hence improve it to $item["Title"]. I guess you don't need $lista.update() Refer below updated code. #Add SharePoint PowerShell Snapin which adds SharePoint specific cmdlets Add-PSSnapin Microsoft.SharePoint.PowerShell -EA SilentlyContinue ...


0

Is it SharePoint Online (Office 365) or On Premises? If it's on premises, a timer job can be built that reads all user profiles and updates the list. However if it's Office 365, the options are limited. One of the ways is - Develop a Site Workflow that uses a REST call to fetch all site users, loops through site users, gets user profile info for these ...


0

2 Options SharePoint Object Model - http://msdn.microsoft.com/en-us/library/ms441339.aspx SharePoint Web Services - http://msdn.microsoft.com/en-us/library/ms479390.aspx specifically the Lists web service The web services is how Excel/Access communicate with SharePoint to integrate with its lists. Actually depending on where your solution is deployed, ...


0

in SharePoint Workflow 2010, there is action called "Replace", it will stop inheriting all parent permission to current item , and assign new permission to current list item in below i have replace Current item level permission , group XYZ with Contribute permission , Here is workflow action:- "Replace Contribute of item in Current Item" u can do same ...


0

Instead of using infopath, you could create 2 related lists. One for applicants, and the other for previous jobs. You could also add a 3rd for schools or whatever. The way the lists relate is via a lookup column. As for displaying them in a user friendly way, I went to a conference last year where Mark Rackley did a great hands-on session showing a simple ...


0

The best way to do this would be to use a form library and create a custom infopath form, where you can then add Repeating Sections for the areas you want to add. Build it in InfoPath and then upload it once you are ready and it will prompt you to add the correct reference fields etc... rather than trying to create the SharePoint columns first


0

Out of the box, there's not a way to create new fields for a list item on-the-fly, so you would need to setup those fields beforehand in the list (e.g. Job1Address, Job1Position, Job2Address, Job2Position, etc.). I haven't used InfoPath for creating forms, so I'm not sure of it's capabilities.


0

The display form had been customized to display in a Data Form webpart,after I made it to display it in List Form webpart,the issue got resolved.


2

Please make sure the person approving the item have enough rights on the list. If you are using a task list, approver would require contribute permission on it, else how would he be able to modify the status of the task.


0

I had this exact issue and never found an answer, but in continuing to just "try stuff out," I stumbled across a solution. Go to "Edit View" and scroll down to the "Folders" link (or if you're creating the view for the first time, be sure to scroll down after setting your parameters) Click the plus sign next to Folders Click the radio button next to ...


1

Use <FieldRef Name='Shelf'/> instead of <Field RefName='Shelf'/>


3

If I understood you correct you want to set your date as yesterday, two days ago, etc. and not just to see actual date 18.08.2015. If so, there is choice field when creating date column, name of that field is Display Format. you should choose Friendly option, default option is Standard. I do apologize if you meant something different to ask.


1

In case you use JavaScript: First of all you need a reference to SP.dateTimeUtil.js: <script type="text/javascript" src="/_layouts/15/SP.dateTimeUtil.js"></script> This file contains a JavaScript function called getRelativeDateTimeString() accepting four parameters: Date ISO8601 IncludeTime CalendarType AdjustToServersNowTime You call the ...


0

The formatting is done server-side, you would have to replicate it (and and the Today difference calculation) either in a Calculated Column or with CSR - Client Side Rendering This StackOverflow post explains why/how: How to use Today and Me in Calculated column


0

I’ve faced the same issue and nailed it down to the InlineEdit-Property of SPView. Apparently InlineEdit is not supported in 2013 and there is no option so reset/remove it via UI. I use a PowerShell script to set this property to $null on each view in every list after a site collection has been upgraded to 2013 look and feel: foreach ($web in ...


0

I had a similar problem when I migrated, most noticeably with image libraries not using the new thumbnail view. I fixed it by changing the view settings. My example is for an image library but hopefully it fixes the issue for your list too. Here are the steps: From the library, click on the Library tab Click "Modify View" Scroll way down to "Style" and ...


0

A little more background, AddItem() is the preferred method because as the list gets larger, it has to download all the items in the list when you call list.items.add() in order to add the one item. This is why MS created the AddItem() call so that you could add an item without doing a query of all items in the list. Avoid calling .Items off of a SPList ...


0

Posting comment as answer If I'm understanding this right, you need the actual video stored within the folder. Video content type is created as a folder in the asset library. You can use getfolderbyserverrelativeurl and get video information from there. See: How to get the full url of video uploaded to asset library SharePoint


0

User with Site Collection Permission will be able to grant you back your lost permissions.


1

It is true that I need to go for CSR. I went into the edit mode on the DispForm view for one of my items. Go into the Web Part attributes -> Miscellaneous Enter the JSLink to your file (in my case it is ~sitecollection/SiteAssets/logo.js) Sharepoint is showing my HTML code as a text string and for this I simply exchanged the innerHTML with my innerText. ...


5

Deploy your feature to Web Scope and enable the feature on your subsite. Register the event receiver (element.xml) with: <Receivers ListUrl="Lists/test">


1

Assigning a list guid to registration id is not possible. In your case you would need to have a specific list-template-id or content type assigned to this list and assign this to the registration id. You get a custom listtemplate-id if you create a list definition in a solution and create a new instance of this list. Otherwise you could use the ...


1

You can use the EnabledScript attribute to enable the action just for your Meeting List. <CommandUIHandler Command="Ribbon.ListItem.CustomGroup.Controls.BtnSayHello.Command" CommandAction="javascript:doYourStuff();" EnabledScript="javascript: function isEnable(){ if(SP.ListOperation.Selection.getSelectedList() == "meeting list GUID"){ ...


3

The Number trick to display HTML only works in Views, it shows the bare HTML on Forms and in Alerts. Full explanation and pros & cons at: http://viewmaster365.com/index.html#/How For Forms you have to go for Client-Side-Rendering (CSR) BTW Your Formula: =IF(Area="HR" ;"<div><img style='float: left' ...


0

Ask to someone who has higher permissions on the site. Or if you can access to the centra admin, set you as site collection administrator for that site.


1

ask someone who has permission to the site or the site collection administrator. There is no other way


0

The thing to consider is the context of where the expression is that calls the code behind function or performs any calculation. If you write an expression in a details table, the expression will be evaluated for each independent row of that dataset as each row is placed in the table. Similarily, if you write the expression in a plain textbox on the ...


1

If you're using SharePoint Foundation 2010, then this is a known issue where a custom list has a lookup field to another custom list that contains more than 20 items. If you set the value of the lookup field to "None," then you'll get the error. It looks like you'll need to apply an update to SharePoint to resolve the error. Here's more info: ...


-1

You may refer this link, if you can consider using the info-path form based solution. https://basquang.wordpress.com/2010/03/29/cascading-drop-down-list-in-sharepoint-2010-using-infopath-2010/


0

Add the following formula in column settings -> column validation: =(MONTH(ColName)=MonthNo) and give a custom validation message. For eg: for August, this will be (Month(ColName)=8).


1

You can use the PreSave() function in the newform.aspx. <script type="text/javascript"> var $j = jQuery.noConflict(); function PreSaveAction() { var dataValue= $j(":input[title='YourDataField']").val(); if(dataValue == yourValue){ return true; } return false; } </script> You can save the configurable value to a ...


0

Okey so I did a workaround. First i put the ID from the list into the document column on item created. Then I used a workflow to trigger on change in the document library, which checked two columns: fromApp and isSet. If both are true, it sets its own ID to the correct item in the first list, and changes isSet to true. Then, through code in the app, I set a ...


0

You need some programming skills to achieve this. SharePoint can not do it out-of-the-box. The usual approach was to use InfoPath for these type of (more logic) forms. The future of InfoPath is unsure, current versions will be supported till 2023 (or about) It is still the best tool for your requirement. Only you can weigh the investment versus the time ...


1

Updated Answer after question was updated with more understanding. Well as you have said that we can remove the Quick Edit link via list setting in Advance Settings option, but unfortunately that hides link for all users irrespective of admin or not. So I doubt you have any OOB solution which will take care of your requirement. You need some custom ...


0

possible duplicate of this question You can achieve this via SPUtility.Js as stated in the answer posted in the link. With that you can write the script as follow ​ <script src="/Shared%20Documents/jquery-1.10.2.min.js"></script> <script src="/Shared%20Documents/sputility.min.js"></script> <script> // wait for the window ...


3

You have to add two permission levels on the site. One level needs Add Items and View Items permissions. The other level needs View Items. Then assign the level to two different groups and it is done. User permissions and permission levels in SharePoint 2013 If you want to hide the Edit button in the quick edit mode, I would suggest you to use Javascript ...


3

Then in your list, you would want to make sure that the permissions are set so that only your administrators have Contribute, Edit, or Full Control access and everyone else has Read. This can be found by going to the List tab and selecting List Settings and clicking on Permissions for this list. You might have to break permissions inheritance and set ...


0

Versioning on lists can also be Enabled/Disabled using PowerShell. I have used this CSOM PowerShell function to enable versioning on a custom list. Since its a CSOM you need not run this on server, i.e. you can execute this function remotely provided you have installed Client APIs Try{ Add-Type -Path 'C:\Program Files\Common Files\Microsoft Shared\Web ...


0

Gary Lapointe has the article Loading Specific Values Using Lambda Expressions and the SharePoint CSOM API with Windows PowerShell which is providing lots of insight and also the function Load-CSOMProperties.ps1 over on github Utility PowerShell function that facilitates the loading of specific properties of a Microsoft.SharePoint.Client.ClientObject ...


1

Question resolved. The error message is completely misleading. It has nothing to do with the token - the problem lies within the strict POST message format SharePoint is requiring. If you use the following headers for your POST request, everything works fine. headers = {'X-RequestDigest': token, 'Accept': 'application/json; odata=verbose', ...



Top 50 recent answers are included