Author Archives: romeodonca

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

Deleting empy folders in Sharepoint Online using Powershell CSOM

starting from this post I propose you following script It will search all folders and subfolders  and if some of folders doesn’t contains files it will shows you these folderfs and it will ask you if you would like to delete … Continue reading

Posted in Powershell, Sharepoint Online | Comments Off on Deleting empy folders in Sharepoint Online using Powershell CSOM

Sum of time values for two DateTime columns

Starting from this post let’s suppose that your two DateTime Columns are COL_DAT1 COL_DAT2 and the request is to sum the time values. The final value  ( as a text ) will be in this format hh:mm. For this you will need … Continue reading

Posted in CalculatedColumn, Sharepoint Online | Comments Off on Sum of time values for two DateTime columns

Add domains in Office 365 with Powershell

If you would try to add a new domain to your Office 365 tenant , using Powershell, the steps are ( of course after you install Windows Azure Active Directory Module for Powershell ) Step 1. Connect to your tenant … Continue reading

Posted in Office 365, Powershell | Comments Off on Add domains in Office 365 with Powershell

Create a library in each subsite in SharePoint Online

Starting from this post, bellow is the script which will create a library in each site for a specific site collection. $url = “your site collection URL” $description = ” This is my library” $Title = “00My List Title in … Continue reading

Posted in CSOM, Office 365, Powershell, Sharepoint Online | Comments Off on Create a library in each subsite in SharePoint Online

Le roi est mort, vive le roi!

      Because public sites on SharePoint Online will be not anymore supported starting to first of April 2017, some changes will arrive. The new domain is here romeodonca.com ! The old one romeodonca.ro is still running on the old platform and it will … Continue reading

Posted in WWW | Comments Off on Le roi est mort, vive le roi!