Set Lookup Fields in Edit Forms for Large Lists in SharePoint

A couple of weeks ago I blogged about automatically setting the lookup field in a new item form when that lookup field exceeded the list view threshold: Automatic Parent/Child List Relationships for Large Lists in SharePoint I wanted to follow that up with a “plug and play” script that would allow you to update the value of a lookup field on an Edit Form. Additionally, I wanted this to work for both single selection and multi selection fields. Now, in an ideal world you would not implement this script, you would have a developer on staff or a third party Continue reading Set Lookup Fields in Edit Forms for Large Lists in SharePoint

Automatic Parent/Child List Relationships for Large Lists in SharePoint

Maybe another title for this blog post would be “Setting lookup fields when you get the ‘This is a lookup column that displays data from another list that currently exceeds the List View Threshold defined by the administrator (5000).’ Error”. Yeah, large lists are a pain in SharePoint. You can be trucking along for months, everything working great, happy users, life is good and then BAM… you create that 5001st entry. List views break, look up fields break, your world becomes painful. And what’s the right response?? The obvious answer is “don’t create large lists”, but unfortunately we live in Continue reading Automatic Parent/Child List Relationships for Large Lists in SharePoint

Renewed for Microsoft MVP in 2016!

I woke up the morning of July 1st to the email I will now be anticipating for hopefully years to come. This was my first MVP renewal and even though I had no reason to believe I wouldn’t be renewed there’s always that “what if…” in the back of my mind. I’m grateful to Microsoft for giving me the opportunity to be an MVP for another year; to learn and hopefully grow, and to add more value to the community and my clients. Now that I’ve been an MVP for a year I have a much better understanding of what Continue reading Renewed for Microsoft MVP in 2016!

Integrate Your Office 365 Video Portal with SharePoint Online

One of the cool features of Office 365 is the Video Portal. Using the Video Portal you can create different channels, upload your videos (almost any format) and Office 365 will process those videos and allow you to stream them without forcing your users to download them or wait forever for them to start playing. Whether you want to store training videos, messages from your CEO, marketing materials, or bootleg movies the Office 365 Video Portal makes it easy for users to view your videos. The problem is that if you are in SharePoint and want to view a video Continue reading Integrate Your Office 365 Video Portal with SharePoint Online