4

As a short answer: No. There is no such parameter to export a list or Library to Excel / CSV from URL. Behind clicking on Export List to Excel from the above ribbon, you will get a URL like http://your site /_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List={638D72C3-264C-4797-9812-67544942EFEB} This link requires at least the List ID, and ...


2

I can reproduce your issue in my SharePoint Online. It seems the default behavior in modern list view now, there is a blank option in the choice column even we set the default value. You can also check the thread:Spurious blank entry at top of a choice column entry


1

I don't think it is possible to manually delete linked item in the calendar. You were creating calendar item based on the run workflow when a new item is created or run workflow when edit item. I would suggest you to automate the deletion process. Set a flag in the sharepoint list which is set through workflow when the item is ready to be deleted. Add a ...


1

While a JSON column format can use the value from another column to conditionally color the current column, including checking against the modified and created dates to see if it has been updated since it was created, there is no way for the formatter to tell what field was modified. But if you could potentially set up a Flow in Power Automate to do this. ...


1

If you are using SharePoint OOTB form and your Remark field is multiple lines of text: You can save the existing remarks from all the Approvers and will be able to get the empty text-box when next approver tries to add his/her remarks using cool feature in SharePoint called Append Changes to Existing Text. For using this first you need to enable the ...


1

The following code for your reference. <script src="https://code.jquery.com/jquery-1.12.4.min.js" type="text/javascript"></script> <script type="text/javascript"> var url = _spPageContextInfo.webAbsoluteUrl; var listName="CL1120"; var sourceItemId=1; var targetItemId=2; function getAttachments() { var requestUri = url + "/_api/web/...


1

Please go through the below articles where I have explained about the list view 5000 threshold issue and its possible solution: https://www.c-sharpcorner.com/article/detailed-insight-on-the-sharepoint-5000-list-view-threshold-limit-issue/ https://www.c-sharpcorner.com/article/overview-of-sharepoint-column-indexing/ https://www.c-sharpcorner.com/article/...


1

This Article should help you a lot. There are different solutions explained aiming your problem. For example remove filters or grouping:


1

Shared list is not supported in SharePoint. One common workaround is to use SharePoint designer workflow or Microsoft Flow to update contents between lists. Here are some references for you. Copy data between two SharePoint lists (or any two data sources) efficiently. How to use Flow to copy items between two data sources. SHAREPOINT LIST WORKFLOW: ...


1

Short answer is this is not possible. What I would suggest doing is If you have a list in Site A, and Site B users need to access the list in Site A, create a link on Site B that points to the Site A list, then give permissions to the Site B users to the Site A list. Your users are changing sites but they won't really notice. You could also use workflows ...


1

You can read excel in jquery and after that you can store that data into SharePoint using rest api or client context, using client context you can store data in bulk. Read excel using jQuery: <script src="jquery-1.10.2.min.js" type="text/javascript"></script> <script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.7.7/xlsx.core.min.js">...


1

Contribute permission is not having create list or delete list capabilities, Edit permission is having both capabilities, to remove those permission use following steps. Go to top level site settings -> Site Permissions Click on permission level: Uncheck Manage list option: Above steps will disable create and delete functionality.


1

You need to create your own Permission level in SharePoint according to your need. Either you can create a new permission level from start or you can copy an existing permission level and make some changes like removing deletion capability. Check below article: Create a Permission Level.


1

By looking at the errors, I think this issue is because your JSLink file is not loaded properly. There is some specific syntax to give the path of .js file in JSLink, check below: Path: Save this JSLink.js file in same site and add path to miscellaneous --> as ~site/SiteAssets/JSLink.js. OR Save this JSLink.js file in same site collection and add path to ...


1

You need modify the code as below. (function () { var statusFieldContext = {}; statusFieldContext.Templates = {}; statusFieldContext.Templates.Fields = { // Apply the new rendering for Priority field on List View "Status": { "View": statusFieldTemplate } }; SPClientTemplates.TemplateManager.RegisterTemplateOverrides(...


1

Lists only have one attachment field. You could create a InfoPath form library. This would store the data as an xml file in the library, rather than in a list. This mechanism also supports multiple attachment controls, each bound to their own field (or, a repeating field that stores multiple items). Before you go down this road, please be aware that the form ...


1

You can use Microsoft Flow for generating a PDF file based on a SharePoint list item: https://flow.microsoft.com/en-us/blog/intermediate-flow-of-the-week-create-pdf-invoices-using-word-templates-with-microsoft-flow/


1

Spelling of "Approved"/"Aproved"? =IF([Aproved]="",DAYS(TODAY(),[Created]),DAYS([Created], [Approved])) But do keep in mind Hellofiona_MSFT's point about TODAY().


1

If you want the number of days between two days then you have to use DATEDIF function in SharePoint calculated columns: DATEDIF([Column1], [Column2],"d") Try using below formula: =IF([Approved]="", DATEDIF(NOW(),[Created],"d"),DATEDIF([Created],[Approved],"d")) To check if column is blank you can also use ISBLANK function(I am not sure why you are using ...


1

Use the formula: =IF(ISBLANK(Approved),DATEDIF(Created,TODAY(),"d"),DATEDIF(Created,Approved,"d")) Notice that Today() in the calculated column cannot update automatically, you need to update the column manually or use tools such as workflow to update.


1

You can edit the list form using InfoPath. Open the list form in InfoPath, click "New View" in the PAGE DESIGN tab, give a view name and it will open a new form to customize.


1

Fun question! You can use a Power Query feature named "Extract Values" to do this. In my example, I renamed the Title column in each list to Project_ID and Tasks_Title. When these are brought into Power BI they are displayed with the original Title name and will need to be renamed. Steps: In your Project_Tasks list, update the Project_ID lookup to also ...


1

Have a look at the SharePoint REST API. The documentation has a special section on how to work with lists and items. Essentially you would call something like http://site-url/_api/web/lists/GetByTitle('Test')/items Also there seems to be JShare.


1

No direct way to do this, you would need customization. Below are some high level techniques to achieve same. Using MSFlow - What you need to do is create a flow for your Invoice list when a item is created/updated. In Flow add logic to query list item from Budget list from based on your column(may be Section column) which is holding relation ship between ...


Only top voted, non community-wiki answers of a minimum length are eligible