All posts tagged Office365

Building a Modern SharePoint Solution: Part 9 – Starting a Microsoft Flow from a PowerApp

This is the final post in my series of building a modern SharePoint Solution.  In this post, I will demonstrate starting a Microsoft Flow from a PowerApp.  There are many reason’s why you would want this, but the most often used would likely be to allow the user to update an entry, save it and hold off sending it until they have all the information in place.  There are alternatives of course; like having a Flow wait for a value to change, but I prefer the user experience a button submission gives you.  Special note: Because Flow doesn’t currently allow for multiple triggers for a flow, we won’t be able to use flow created in Part 9 of this series.  However, I do suggest you not remove not remove it because this allows multiple ways to kick off the WF.

Posts in this series:

Read more

Building a Modern SharePoint Solution: Part 7 – Creating a Multiple Approver Microsoft Flow

In my previous post I showed how to set up a flow to execute manually and not on an add or change event.  I have a reason for that we will get to in a future post, but for today I am going to cover creating a multiple approver Microsoft Flow.  In our requirements we have both a project\event approver as well as a manager approver.  One thing you don’t see on the form, but was mentioned in the requirements is the need for communications to also approve.  This will be going to a generic account (for now) that anyone in the communications team can deal with.  The process is the flow will request approval from the project approver first, then the manager and finally communications cause they are not checking for content just grammar and such.  No sense including them until the other approvers are ok with the message.

Posts in this series:

Read more

Building a Modern SharePoint Solution: Part 6 – Create a Flow to be Started Manually

Finally moving on to Microsoft Flow.  I really like Flow.  It’s a great replacement for the SharePoint Designer Workflow and in my opinion a strong competitor to 3rd party workflows.  Don’t get me wrong, those other tools are great and I have used them happily in the past, but so far Microsoft Flow has met all of my recent needs and already covered by the O365 license I have.  If I don’t have to spend extra or my client doesn’t either and Flow meets our needs, then to me that is a huge bonus.  In today’s post, I am going to illustrate how to create a workflow that does NOT fire when an item is added.  This is because, for the requirements of this solution, users will want to be able to save the item without a workflow being initiated.  So in other words, I am going to show how to create a Flow to be started manually.  This can be done from the list, or in a later post I will show how to do it from the PowerApp form itself.

Posts in this series:

Read more

Building a Modern SharePoint Solution: Part 2 – Integrating PowerApps as a Custom List Form

Welcome to the next part in my series about building a modern solution in SharePoint.  This post we are going to cover integrating PowerApps as a custom list form in your solution.  When PowerApps was first released, Microsoft made sure that everyone knew it wasn’t built for SharePoint.  In fact the first examples that Microsoft provided didn’t even involve SharePoint.  Since then SharePoint lists and libraries can be accessed by PowerApp forms using connectors into those environments.  Finally, in the final quarter of 2017 Microsoft provided the ability to integrate PowerApps directly into a list form, thus overriding the default forms of a list.  So like the InfoPath forms of days gone by, you can now use PowerApps for creating, editing and viewing data in your lists.  This post will cover setting up a PowerApp for these list forms.  The next post we will customize the form more to meet our needs for this solution.

Posts in this series:

Read more

Building a Modern SharePoint Solution: Part 4 – Setting a SharePoint People Picker Field Programmatically in PowerApps

Continuing my series on building a modern SharePoint solution using PowerApps and Flow I want to show how to go about setting a SharePoint people picker field programmatically in PowerApps.  This goes back to one of the requirements listed for my solution in part 1 of this series: “Requestor’s manager should be auto-populated as an approver”.  What’s nice about this is the manager field is filled in already by the company’s administration system.  It exists in Azure AD and thus within Office 365, which just so happens to have a connector that easily allows us to build with it.  I am getting ahead of myself though.  Let’s dig in and learn how to do this.

Posts in this series:

Read more