New answers tagged list
0
Best way to handle permission is create a SharePoint access group name as access database group with Read or Contribute permission as per your your need - add all the authorized users there, then as Rune suggested in previous answer, go to the list permissions setting page, stop inheritance to break the parent permission structure, remove all users and ...
0
If you go to List Settings, then Permissions for this list, you will see how the permissions for the list is configured. It is probably inheriting permissions from the site (that is the standard setup).
What you want to do is to click the button Stop inheriting permissions. This will leave the permissions intact, but any changes to the permissions to the ...
2
Assuming playerID field is of type Single Line of Text (If data type is different then let me know. I will change query accordingly),
Try your query in below format:
<View>
<Query>
<Where>
<And>
<Eq>
<FieldRef Name='Title'/>
<Value Type='...
0
According to your description, you can use the action populate a word template to do so. Here is a tutorial about creating a simple word file with a template and send it in an Email.
https://www.youtube.com/watch?v=Zzm965PlYl0
Note: The actions with word needs premium
As for SharePoint list, you can use triggers like When an item is created to trigger the ...
0
You can do this with "Format this column" in modern list views!
Here, the "Branch" choice column has applied the following JSON:
{
"elmType": "span",
"txtContent": "@currentField",
"style": {
"text-transform": "uppercase"
}
}
Strangely enough, there is a toLowerCase() function - but no toUpperCase(). CSS to the rescue!
0
You could try calculate column.
Additional steps would need for SharePoint 2016/2019
https://www.sharepointdiary.com/2019/01/format-calculated-column-as-hyperlink-in-sharepoint-online.html
0
Use the SharePoint designer workflow or if you have Nintex workflow. Create a column in the task list name as something open task with hyperlink type. Using workflow after creating the task, update this new column(hyperlink) with the SiteURL +taskid (what user entered).. this will be linking to the task but this link should be displayed just as the number ...
0
I found that if I right click on a modified item, then click on the version history, then click on one of the modified dates, then I get the restore version option. I assume this only works when we have at lease one approval in place. I mean if the first insert is rejected, then this restore version does not work. Well it acutely should not, because there ...
1
colListItem will be empty until you execute the query at the end of your function. You need to execute it before you can delete the item(s), and then once again when the delete commands have been placed.
Check following code, I included comments on the bits I modified:
deleteFromHistory: function(){
console.log("deleteFromHistory called!")
let ...
1
In your camel query in the set_viewxml there is a plus sign (+), remove that and try again. The best recommended way is - execute that query using camel query builder, then just copy paste the query inside set_viewxml.
You can download the camel query builder tool from here :
https://www.u2u.be/software
Refer to the below article how we can use :
https:...
0
Below script works fine in my local.
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.0.0/jquery.min.js"></script>
<script language="javascript" type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/jquery.SPServices/2014.02/jquery.SPServices.min.js"></script>
<script type="text/...
0
As I you are using the SharePoint 2013 version, in this version Microsoft has introduced a beautiful feature for this kind of requirement i.e content search web part. This works on the search level meaning the data source could be of sites but finally after crawling this will be a single data source that is search result.
So, in order to customize the ...
1
You can use the camel query to get the list item based on your column value which will load only those list items which meet that criteria, then do the delete operation as usual way.
Sample Example: Using JSOM
To filter SP.ListItem's on multiple conditions, there are no single methods that take the arguments as multiple filter fields. Instead, you'll have ...
0
The typical method would be to create a list with three columns: project, month, and projectedStaff. Adding a new estimate would just involve adding a row.
Power BI or Excel could connect to this list and do a "pivot" to output the data as you have in your example, where each month is in a different column.
Optionally, you could create a power app to ...
0
I assume you want to use the lookup column to link to a list with a few hundred records. For such situation, a common option is to use the JS link and make users be able to search for the record they want. Here are examples you can have a check:
https://ravisoftltd.wordpress.com/2014/05/05/convert-lookup-field-to-token-input-with-jslink/
https://...
0
I think in this case we need to use any of the third party tools like sharegate, Metalogix etc. Don't worry about the licensing, you can use the trial version.
Using the third-party tool, need to perform the delta/incremental migration, however, before the migration you need to create the additional columns in the prod those are not available in the prod ...
0
I recently found another much simpler way to do this.
Simply modify the view's filtering and sorting using the column header drop downs, and then click the Save This View link. It does allow you to select more than 10 filter options, and the Save This View saves them!
0
If you add another executeQuery after oitem.update(); this will work.
The reason it works on the second+ run is because the queued update then will be part of your initial executeQuery!
Modified, the end of your script should look like this:
oitem.update();
ctx.executeQueryAsync();
});
}
1
The problem you are facing is because SharePoint loads those groups dynamically via JavaScript, so if you are adding classes to elements, those elements don't initially exist when the page has officially finished loading, so executing on document.ready is "too soon".
I have a snippet of code I use when I need to execute something after a grouped view has ...
0
Power Automate does have a built-in SharePoint action named Add attachment. More detailed explanation included below this sample screenshot:
If you configure the Site and List parameters of this action identically to the values you use in your Create item action, then you can use the ID returned from Create item to populate the ID parameter of Add ...
1
You can try the below code for conditional color formatting code in SharePoint :
$(document).ready(function(){
$Text = $(“td .ms-vb2:contains(‘Approved’)”).filter(function() {
return $(this).text() == “Approved”;})
$Text.parent().css(“background-color”, “#00FF66”);
$Text = $(“td .ms-vb2:contains(‘Decline’)”);
$Text.parent().css(“background-color”, “#...
1
You can as long as you have Version History turned on for the list.
While it is not a built-in function, you can use the Send HTTP Request to SharePoint action in Power Automate to call the Versions REST API and restore the previous version.
Start by using the Send HTTP Request to SharePoint action to call /_api/Web/Lists/getbytitle('NameOfTriggeredLibrary')...
0
Technically once you commit the changes in SharePoint we can't rollback it directly but through some work around we can do it.
Create another as example temp column, update this with the original column value through the workflow, so here original column value will be retained.. now when approver reject the request update the original column value through ...
1
To create a link to the document (in the library) in the list, there are some options:
Create a hyperlink column in the list.
Use the "Attach File" option from the actions menu.
Create a lookup column type. In the "Get information form:" select the document library you wish to link to.
Reference:
https://www.epmpartners.com.au/blog/how-to-link-a-list-...
0
There is no such thing in SharePoint as "versioning for the delete process". When an item is deleted, the item and it's entire version history move to the recycle bin, and eventually disappear into oblivion.
You cannot hook an approval process to the delete process, and there wouldn't be any history to that either. If you trigger your Flow on item deleted,...
1
You can do this by adding a hyperlink field and a workflow to your target list.
When an item is updated, check if the lookup field has a value. If it is not blank, update the hyperlink field to have the server relative url from the lookup list:
Filename here is the hyperlink column.
3
I found the problem, the create item is in the "Apply to each 2", when I removed it it worked fine. I guess the reason was copying it from the update item. Because when I created the "update item", flow puts it in "apply to each", so when I copied it to "yes", "Apply to each" was also copied, while it should not be. However, I am sure I will be corrected if ...
0
I got the issue.
Solution - Create only one workflow which will contain all conditions and actions.
Issue - Your second workflows is running twice, once when someone changes the item and then when the workflow first workflow get completed, this triggers second workflow to run again.
You can verify this issue form item level workflow history.
0
The sample you proposd only works for Title field i added Edit (link to edit item) But the links only appeared on the Title field. Also changed to a different column but no luck
1
You can develop a workflow on the library which should trigger on item creation and create item action and in the configuration of create item select the custom list and map all document library columns (document properties) with the custom list column (the custom list should have the needed mapping columns). That's it - on item creation on document ...
2
As a short answer, Yes, you can use List Workflow to update list item in another list based on condition in the first list
By using Update List Item Action below List Actions
You can specify Which list you need to update its related list item as shown below
After specifying the list, specify the field that you need to update based on the condition in the ...
3
You could set the calculated column as below：
4
Try to use Round function to rounds a number to a specified number of digits.
Round Syntax = ROUND(number,num_digits)
Where the num_digits the number of digits to which you want to round the number.
In your case, try the following:
=ROUND(MAX(0,TodayDate-[Contract Commencement Date])/([Contract End Date]-[Contract Commencement Date]), 1)
Read details ...
2
The first approach in your link could work, you only need to download SharePoint Designer from Microsoft to your computer to set that up. That is a legacy workflow.
In Power Automate it is not possible to do this directly unless you also set up an Azure Function to handle setting item level permissions.
I included the word directly because there might be ...
1
You cannot do it by using the SharePoint Online PowerShell directly, that is mainly for maintenance tasks.
Luckily we have the PnP PowerShell Library that makes these kinds of operations quite easy:
Connect-PnPOnline -Url "https://domain.sharepoint.com/sites/sitename" -Credentials (Get-Credential)
$listname = "TestUpdate"
$items = Get-PnPListItem -List $...
1
You can achieve this using list Validation settings. use below formula:
=IF(OR([report type]="A",[report type]="AB"),IF(ISBLANK([Type A due date]),FALSE,TRUE),TRUE)
Calculated Field Formulas.
0
You need to select the list that you add the parameters in the connections list.
And get the parameters in the connection field name.
2
Currently there is No way to use target Audience in SharePoint Modern List view.
Workaround:
Go to your SharePoint list.
Click on Return to classic SharePoint (You can find it below left side navigation - bottom left corner of the page).
Click on Settings (Gear icon) --> Edit page.
Then Edit Web Part.
In web part properties panel, expand Advanced section.
...
0
To be able to set this using Power Automate you will also need the term label to be able to format it properly.
Expected format for a custom value is:
Term Label|Term Guid
Example: Test|c9579a6a-c0b2-4aa0-84b8-869d53901231
You can either update your current text field to include the term label, or incorporate some lookup in your flow if that is not an ...
-1
I realise it's an old post, but one that comes up high in Google when searching for this type of query.
In case it helps others, for SharePoint Online, I found this can be done through PnP, without iterating over files.
e.g.
Connect-PnPOnline -Url https://myspo.sharepoint.com/mysite -UseWebLogin
$Measures = Measure-PnPList LibraryOrListName
$Measures....
0
Manually added values will not be included in the drop-down list, if you uncheck the "Can add values manually" option, the previous values still exist in list items.
-1
"Find an Item" box: To hide this, go up to the Gear icon at the top of the page, and choose "Edit Page" to put the page into edit mode. Once in edit mode, the upper-right-hand corner of the List will have a little drop-down arrow. When you click that arrow, you can choose the option to "Edit Web Part".
This will open the web part properties pane on the ...
Top 50 recent answers are included
