Monthly Archives: May 2017

Search for user or group in Sharepoint groups with Powershell

If you would like to search for a user o domain group in your SharePoint on-premises groups, the following script will help you The needed mandatory paramaters are: $searchelement , which is the name or a port of the name … Continue reading

Posted in Powershell, Sharepoint | Leave a comment

Calculated Column – get first Monday on the next month

If you have a column Data1 – DateTime type column , only date – and you need to get first Monday of the following month, the needed formula in a calculated column will be: =IF(WEEKDAY(DATE(YEAR(Data1);MONTH(Data1)+1;1))=1;DATE(YEAR(Data1);MONTH(Data1)+1;1+1);IF(WEEKDAY(DATE(YEAR(Data1);MONTH(Data1)+1;1))=7;DATE(YEAR(Data1);MONTH(Data1)+1;1+2);IF(WEEKDAY(DATE(YEAR(Data1);MONTH(Data1)+1;1))=6;DATE(YEAR(Data1);MONTH(Data1)+1;1+3);IF(WEEKDAY(DATE(YEAR(Data1);MONTH(Data1)+1;1))=5;DATE(YEAR(Data1);MONTH(Data1)+1;1+4);IF(WEEKDAY(DATE(YEAR(Data1);MONTH(Data1)+1;1))=4;DATE(YEAR(Data1);MONTH(Data1)+1;1+5);IF(WEEKDAY(DATE(YEAR(Data1);MONTH(Data1)+1;1))=3;DATE(YEAR(Data1);MONTH(Data1)+1;1+6);DATE(YEAR(Data1);MONTH(Data1)+1;1))))))) Depending on your regional settings, … Continue reading

Posted in CalculatedColumn, Sharepoint Online | Comments Off on Calculated Column – get first Monday on the next month

Deleting specific files from Sharepoint on-premises library

Starting from this request, bellow you will find the script needed to try 2 option The first one , the Powershell script will read the csv file and for each entry, fill parse the SharePoint library for the file The … Continue reading

Posted in Powershell, Query, Sharepoint | Comments Off on Deleting specific files from Sharepoint on-premises library

User experience in utilizarea fisierelor din Sharepoint Online

In nou episod, al 10-lea din seria de tutoriale despre Office 365 a fost publicat pe youtube. Acest episod este destinat utilizatorilor cu in nivel mic de cunostinte, la un prim contact cu platforma SharePoint Online din cloud-ul Office365 de … Continue reading

Posted in Sharepoint Online, YouTube | Comments Off on User experience in utilizarea fisierelor din Sharepoint Online

Backup site collections from a .csv file using Powershell

Assuming that you have a .csv file which contains a list of site collections in this format URL,path http://site1,path1 http://urlpath/site2,path2 the line you need to backup them is this one: Import–Csv yourfile.csv | ForEach-Object { Backup-SPSite $_.URL -Path $_.path -force} … Continue reading

Posted in backup, Powershell, Sharepoint | Comments Off on Backup site collections from a .csv file using Powershell