All posts tagged SharePoint Online

Microsoft Flow – Determine The Approval Status of a SharePoint List or Library Item

When the business wants to control the data that is displayed to users a great way to do this is with content approval.  It’s easy to implement and use.  Simply enable the option in version control and anyone with Full Control, Design or Approve role is able to approve the items.

Determine Approval Status of SharePoint List or Library Item - Enable Content Approval

There is a great write-up by Chakkaradeep Chandran on how to automate the approval process of these items.  However, what Microsft Flow is missing is the ability to see what status the approval process is at.  There are many requests for this information in the Flow forums with no solutions beyond statements that Flow is lacking in this ability.  I was able to come up with a working solution to achieve this.  So read on to learn how to determine the approval status of a SharePoint list or library item.

Read more

Leading Practices for Building Anything SharePoint or O365

The other day a friend of mine, Daniel Glen, asked if I could step in last minute to help out remotely for a presentation to the Nashville O365 User Group.  I of course said yes and then promptly dumped all the stuff I had to do that night on my wife (oops).  I sent Daniel the tickle trunk of presentations that I was ready to do last minute and I was surprised when he selected Leading Practices for Building Anything SharePoint or O365.  It’s an older presentation and one I was actually considering pulling out of my active list.  However, as I was reviewing it I found that the core of the presentation still held true with anything you should do with O365 and SharePoint.  In many cases, any project could use some or all of the concepts I discussed.

Well the presentation went over very well.  It’s a really good group of people there in Nashville and even though I was 2600km (1615+) miles away I can honestly say that session was the most fun I have had yet giving that presentation.  Thanks Nashville.  Let me know when you need another speaker.

 

As promised, here’s a copy of the slide deck.

Capture Comments from the Approver in Microsoft Flow

Now that I have completed my series on building a modern solution with SharePoint, PowerApps and Flow I want to start building on that solution.  The next enhancement I wanted to do was allow the capture comments from the approver in Microsoft Flow.  So whether the approver approved or rejected the request I want to be able to capture the comments if they provided any.  Because this is building on my previous solution you can see how that was built by clicking here.

Read more

Parsing JSON in Microsoft Flow

Something that is used a lot in Microsoft Flow is the HTTP request.  Whether you are calling a site’s REST endpoint or an Azure function, or in the case of today a SharePoint REST endpoint you need to be able to do something with the data returned.  The steps to do that are very simple and only require a free tool called Fiddler.  You can download Fiddler here (please note: I have nothing to do with Telerik, it’s just a nice tool I use often).  Go ahead and download the tool and we’ll move forward with the steps parsing JSON in Microsoft Flow

Read more

Business Connectivity Services – It’s Not Dead… Yet

I had a great time recently presenting at CalSpoug’s SharePoint Saturday.  The first session I presented was on SharePoint Business Connectivity Service.  I have done this session quite a few times and I always have at least one attendee state they have never heard of BCS before.  This session was no different.  One of the things I cover is the importance of BCS in different environments.  Many will argue it is an old, unnecessary system.  I do not necessarily disagree with this.  However, I argue it isn’t dead yet.  If you are working with simple data in a SQL Database or even more complex but well-organized data in a database the ease of use within BCS is quickly seen.  In 5-10 minutes you can connect to your data and present it within SharePoint utilizing built-in forms (no custom form development).  Users will be able to read and update the data immediately (assuming permissions are configured already).  There’s more to it than just this and you can take a look at my slide deck to see.

Having said that, I do believe that I see an end to BCS.  PowerApps and Flows make accessing data just as easy and more configurable through the many, many connectors available.  As these connectors mature and the tools grow, the use cases for BCS will slowly disappear.  However, we aren’t there yet.  BCS is still there and still very easy to use.

 

Take a look at my slide deck and if you have questions, please reach out.

 

Thanks for reading!