Archive for April, 2018

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 Flow – Updating a OneNote Book from Outlook

I continually get frustrated because there are so many great blogs and tidbits of information out there that I want to keep up on, but there isn’t enough hours in the day. On social media I often see great blogs posted by colleagues and friends, or in my day to day while looking for solutions, I will come across other blogs on my own. The problem is that during the day I simply don’t have enough time to read all of them. So I simply leave my tabs open to come back later during lunch or a break. Except that never seems to happen as something always comes up. I usually have plenty of time to read them in the evening once everyone is settled down at home, but I always forget what I was looking at. I have tried emailing them home, but they get lost within all the other emails I received. I set rules, but even if I come back to them, I like to take notes and emails aren’t the best place to do that. So after reading Tracy Van Der Schyff’s blog on moving notes to Planner and Teams I had a thought. What about going the other way?

Read more

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

Microsoft PowerApps – Configure Your Data Cards to Look Like Data Cards

When building your data views in PowerApps, the items can look a bit blended together.  You can add separators, but things may still not look quite as nice.  For example, a simple view of the data (in this case the contents of a list) may look like this:

Configure Your Data Cards to Look Like Data Cards - No Formatting

This looks ok, but I would prefer to have each item be a bit more distinct.

Read more