RoennesNet

Tag: SharePoint Online

  • Bulk update user profile properties in SharePoint Online

    Since the new User Profile Batch Update API is not available on all tenants yet I have been using the “User Profile Bulk Property Updater” from the OfficeDevPnP samples at https://github.com/OfficeDev/PnP/tree/master/Samples/Core.BulkUserProfileUpdater This bulk updates user profile properties in SharePoint Online through the use of a CSV file. I am a big fan of Office 365…

  • SharePoint column validation for only numbers with fixed length

    ,

    Here is how to set column validation formula for SharePoint field to contain only numbers and only two symbols (fixed length). You have to use a “single line of text” field because the number field won’t work this way. Here is the formula: =IF(LEN(CustomSortOrder)=2,ISNUMBER(CustomSortOrder+0),FALSE) This works for both SharePoint 2010 and 2013 and can be…