Category Archives: Office 365

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

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

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

Validation item in Sharepoint

…this post was published on 2017 March 03. How we can force users to fill a secondary line text if another column ( yes/no ) is checked as Yes Suppose that , the Yes/No column with the name yesno, and as single line text column … Continue reading

Posted in CalculatedColumn, Sharepoint, Sharepoint Online, Validation | Comments Off on Validation item in Sharepoint

Upload local folder structure with files on Sharepoint Online

…this post was published on 2017 February 12. IF you would like to upload a complete structure of folders and subfolders on Sharepoint Online you can do it using Powershell and CSOM, using the following script. You need to know the – … Continue reading

Posted in Files, Powershell, Sharepoint Online, upload | Comments Off on Upload local folder structure with files on Sharepoint Online

Restoring multiple files versions in Sharepoint Online using Powershell

…this post was published on 2017 January 28. Starting from this post, I attached a zipped document with the scripts needed to do the request. The .zip file contains the files: Online_RestoringFiles.ps1   – this is the main file which will use the second … Continue reading

Posted in Powershell, Sharepoint Online | Comments Off on Restoring multiple files versions in Sharepoint Online using Powershell

Download all images from all picture libraries on Sharepoint Online

…this post was published on 2017 January 19. You can use following script. Save it  on your PC or run it directly using .ISE. All Images will be saved in specific picture library​. You need to download locally 2 libraries , if … Continue reading

Posted in Powershell, Sharepoint Online | Comments Off on Download all images from all picture libraries on Sharepoint Online