All posts in SharePoint Online

SharePoint Business Connectivity Services in SharePoint Online

I have always been a strong supporter of the SharePoint Business Connectivity feature.  I find that in many cases it allows for easy access to data you would normally have to develop custom solutions for or even pay large amounts of money in licencing for (SAP, PeopleSoft, etc).  BCS brings the ability to present data located in other systems into SharePoint.  A tool that many understand and use daily.  In this presentation I discuss using Business Connectivity Services within SharePoint Online as opposed to on premises.  You can find the slide deck here.  Thanks for attending my session on this topic.

 

Thanks for reading!!

SharePoint Site Architecture – Flat, Deep or Something In The Middle

Hi recently had the privilege to do another presentation with Joanne Klein.  This time we built a presentation off of a post that she had written around whether we should use flat or deep structures with our site collections and sub sites or if we should have something in between when designing a SharePoint site architecture.  It was a lot of fun and we probably could have done entire presentation on just a portion of it.  Either way, I promised our attendees that I would post our slide deck.  You can find the slide deck here.  Thank you very much to everyone who attended.

 

Thanks for reading!

Microsoft PowerApps – Updating a Data Card from a Button

So the other day I was playing around with some field manipulation in PowerApps and thought about a use case I saw often with respect to updating fields when code from a button or some other action occurs.  Say for instance you wanted to update a hidden field with some information when a user clicked a button or completed some task on the form.  Maybe it isn’t a hidden field, but whatever the case may be, you need to be able to update that field.  I was surprised to note that it isn’t very intuitive in PowerApps, nor could I find much out there in the forums.  I did find some information around doing it with a Text Input field, but nothing specific to a data card.

Read more

Best Practices in Waiting for a Value to Change in a SharePoint Designer Workflow

Back in October I did an overview of the different ways to wait for a change in a SharePoint Workflow.  You also have the option to wait for a certain time, there are two options which are waiting for a set duration or waiting until a set date.  Either of which are easy to control or set.  I am not focusing on these actions in this post, but just a quick note if you want the date to be dynamic when using wait until a date, then you will have to set the date you want in a workflow variable prior to setting the wait value.  Otherwise your date is going to have to be static and that’s probably not going to work for you in 99% of your workflows.

Today, however I want to discuss waiting for a value to change on the list your workflow is attached to.

Bit of a disclaimer: Why am I still talking about SharePoint Designer?  Why not Microsoft Flow?  Don’t worry, I have some Flow blogs planned.  However, Designer is still widely used and will be for some time.  I encourage others to use flow where they can, but remember that not everyone has access to that yet.  Designer is free and anyone with a SharePoint environment can make use of it.  Hence, I still see providing insight and knowledge on this product very important.

I have a bit of a TLDR here as you may be just looking for the answer, and not WHY it is occurring.  I strongly urge you to read the whole post to understand why things are the way they are and to make you a better person ;-p, but if you are in a hurry or think I talk\write too much, just click here to find out what you need to do.

Read more

Another Cause of a SharePoint Workflow Stuck at Starting or Started

There are already a ton of posts out there where a SharePoint 2013 workflow becomes stuck at started or starting.  Well I have another one.  This problem actually originated in a SharePoint 2013 farm.  If you are using SharePoint Online, the cause is actually pretty easy to determine.  So for those of you not lucky enough to be working with SharePoint Online, I will go through the symptoms you could come across and a possible resolution.

Read more