Allow custom value as input in Power Apps

If you have a choice column in SharePoint, where you have enabled "Allow custom values",then Power Apps will not respect that setting. For that to work you need to update the Datacard for the column to use the search text as input if nothing else is selected in the choice list.

Break and change list item permission using Power Automate

Using Power automate (Microsoft Flow) to assign permissions on a single item, folder or file is fairly easy, but can quickly become complicated, if you traverse through many sites and lists. This is a simple guide for the very basic setup. I often start by restoring the permissions for the

Use One flow or logic app to trigger multiple SharePoint lists from multiple SharePoint sites

If you ever have to create a flow or a logic app where you need to listen for updates from several SharePoint lists, you actually need 2 flows. One flow to handle the subscriptions and reactiation of the subscriptions and one to act, whenever anything happens on one of the

Delete SharePoint List Items Permanently Using Power Automate in 3 easy steps

Delete SharePoint List Items Permanently Using Power Automate in 3 easy steps

Cancelling all running flows in Power Automate

How to stop a Power Automate Flow that just keeps starting new flows. Finding out that you have a scheduled flow in Power Automate, that just continue to run and then the next flow does the same and all of a sudden, you have a gazillion flows running and never stopping.

SharePoint - Create a view that only shows Minor Versions

In SharePoint it’s actually not that easy to create a view that gives you all the minor or major versions of a document library. Out of the box, it doesn’t seems like you can create a calculated field, which are using the “Version” column. But it is perfectly

SPD2013 Workflow - Activity 'DynamicActivity' has 51 arguments

Have you ever tried to publish a SPD2013 Workflow, only to be met with the error: Microsoft.Workflow.Client.ActivityValidationException: Workflow XAML failed validation due to the following errors: Activity 'DynamicActivity' has 51 arguments, which exceeds the maximum number of arguments per activity (50). This means that you use more

The "SharePoint Timer Service" service terminated with the following service-specific error: Unspecified error

In the event log every 2 minutes, this error pops up: The SharePoint Timer Service Service terminated with the following service-specific error: Unspecified error A quick look at the Performance indicator, tells me that the CPU is not having it. Every 30 seconds or so, it maxes out. Most likely

Moving versioned content to individual listitems in SharePoint

Often, it’s a good idea to version your content. And often it’s a good idea to simply, turn on versioning and the create a multiline field and selecting it to append the text. Thus creating a mini-log of something. But, when it comes to accessing that content across

Use Power Automate to automatically update calculated column on a SharePoint List

This is somewhat, what many will describe as a designflaw in SharePoint. It’s supposed to be “By Design”, but still, it’s just something that many people get very annoyed about. In SharePoint, if you create a Calculated column, which has a calculation that is based on something dynamic,

sharePoint Designer 2013 Workflow - Send email to shared or external mailbox

It’s long been an issue/feature with SharePoint Designer 2013 Workflows (yes, some people still use that today), that you cannot send an e-mail to an external email or a shared mailbox. SharePoint Designer 2013 Workflow can only send emails to organization users and a shared mailbox is not

SharePoint 2013 - Set executionTimeout value in web.config

Standard SharePoint Timeout Values are set to 360 seconds (6 mins). But sometimes you can have a request for added timeout values. If for instance you have a need to upload large files on slow networks. You can set individual timeouts for all SharePoint application pages under the Layouts folder.

Unable to open any documents in SharePoint

Ran in to this error the other day. The reasons to why it started happening I don’t know. Symptoms You cannot open documents via the Office WebAccess (OWA). The documents are fine and downloading them and the opening them works just fine. If there is no other errors and

Get Windows 7, 8 of Windows 10 (bootcamp) to Recognize a Thunderbolt-to-Ethernet Adapter

Note: This is a bit off-topic from my usual SharePoint ramblings, but I just needed to archive this information and most likely I’m not the only one with this issue. I use a Mac, but have Windows 10 installed via bootcamp. That is not always without issues and don’

Update SharePoint groups in all webs in a SiteCollection using PowerShell

Say you have a ton of subwebs in a sitecollection. Each web have unique permissions and unique groups. You would like to update alle membergroups to have Contribute permissions, instead of Edit permissions. If you need to update all ownergroups or visitorgroups, just change the script accordingly. You do it

Moving a SharePoint Document library to a new SiteCollection via PowerShell

Case Recently I ran into a typical SharePoint problem. A SharePoint 2010 site exploded in storage usage. Users was uploading like crazy to one single document library and I needed to move the document library and a few lists to a new site on a new SiteCollection. The source site,

Enable versioning on all SharePoint Document Libraries in a Site Collection

Enabling versioning on all document libraries in a site collection or disabling versioning is often quite useful. Write-Host Loading the SharePoint Powershell Snapin

Load Snapins

if ((Get-PSSnapin "Microsoft.SharePoint.PowerShell" -ErrorAction SilentlyContinue) -eq $null) { Add-PSSnapin "Microsoft.SharePoint.PowerShell" } Write-Host "Starting to update lists and Libraries" $webs = get-spsite http://intranet.domain.

DateDif in SharePoint

The function for calculating the difference between two dates in a calculated column in SharePoint, without counting the weekends: =(DATEDIF([Start Date];[End Date];"D"))-INT(DATEDIF([Start Date];[End Date];"D")/7)*2-IF((WEEKDAY([End Date])-WEEKDAY([Start Date]))<0;2;0)+1

Office 365 public website - going down

I’ve blogged about the discontinuing of public websites a while back and I promised that I would write an update, when there was something to update on. And guess what! Somethings updating. When the changes was announced, there was a small outcry from a few partners, but really nothing

Office 365 shuts down public website feature

Using Office 365 for a public website have always been a simple but not so sweet ride. Microsoft never got that one right and most likely, that is why they are discontinuing that part of Office 365. According to this support document existing websites will have two years to migrate

Formatting dates in Itemstyle.xsl

Insert this line at the top xmlns:ddwrt="http://schemas.microsoft.com/WebParts/v2/DataView/runtime" That will give you a header looking like this: By Ulrich Bojko Dec 23, 2014

SPEndpointAddressNotFoundExecption when publishing SharePoint 2013 workflows

Are you getting this error: (Microsoft.SharePoint.SPEndpointAddressNotFoundException: There are no addresses available for this application.) when publishing SharePoint 2013 workflows? try these steps to fix it: 1. If you use HTTP: Register-SPWorkflowService –SPSite “http://mysitecollection” –WorkflowHostUri “http://server.domain.com:12291” –AllowOAuthHttp -force 2. If you use HTTPS: Register-SPWorkflowService

Add ContentType to all documents in a SiteCollection using PowerShell in SharePoint 2013

I came across a need to change all existing documents in a Site Collection to another ContentType, but without changing data like, “modified by” or “modified date”. Why? I need to attach a column to all documents and it’s just not good practise to add columns to the default

Viewing Workflow for item, fails after installing Service Pack 1 for SharePoint 2013

If your workflows are working just fine, but you are unable to get UI-access to the workflows in SharePoint, because if this error: Sorry, something went wrong Method ‘StartWorkflowOnListItem’ in type ‘Microsoft.SharePoint.WorkflowServices.FabricWorkflowInstanceProvider’ from assembly ‘Microsoft.SharePoint.WorkflowServices, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c’ does

Office 365 Summit in Copenhagen is well underway

I am sitting here in Cinemaxx. For a brief moment, I managed to get some of the room to myself. Otherwise it’s pretty packed with around 600 IT-people. All which are interested in Office 365, Lync, Project, SharePoint, Sales etc. And so far it’s going great. The sessions

SharePoint Image Gallery that doesn't suck in 7 easy steps

[Update] I got an e-mail from Robert, who has refined the solution. Thank you for sharing Robert. Hi Ulrich, first I want to thank Ulrich for his great work and sharing it with us! I also don’t have the problem with more than 40 pictures in a picture gallery

Pop-up modal window SP2010

Code for adding pop-up links to list items and to Library items. Full Code For a List Item:  Submit Feedback Full Code for a Library Item: By Ulrich Bojko Apr 25, 2014

Create link to new folder and item actions in modal window in SharePoint 2013

Create link to “New Item” /_layouts/15/Upload.aspx?List={}&RootFolder=&IsDlg=1′,RefreshOnDialogClose,null,null,'