All posts in PowerApps

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:

  • Preparing SharePoint
  • Integrating PowerApps as a Custom List Form (this post)
  • Customizations All List Form PowerApps Should Have
  • Setting a SharePoint People Picker Field Programmatically in PowerApps
  • Cascading Drop-down Lists and People Picker in PowerApps
  • Create a Flow to be Started Manually
  • Creating a Multiple Approver Microsoft Flow
  • Sending a Tweet from Microsoft Flow
  • Starting a Microsoft Flow from a PowerApp

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

Building a Modern SharePoint Solution: Part 3 – Customizations All List Form PowerApps Should Have

In this third post in my series on modern SharePoint solutions, I will cover customizing PowerApp forms to meet the requirements of the business.  We’ll first start off with some basic customizations that need to be done for most form integrations.  When I started to write this post I initially had planned to discuss the modifications you should make for all and then move on to the custom modifications for the solution requirements.  The “default mods” quickly filled up this post, so I have moved the custom mods to the next one.

Posts in this series:

  • Preparing SharePoint
  • Integrating PowerApps as a Custom List Form
  • Customizations All List Form PowerApps Should Have (this post)
  • Setting a SharePoint People Picker Field Programmatically in PowerApps
  • Cascading Drop-down Lists and People Picker in PowerApps
  • Create a Flow to be Started Manually
  • Creating a Multiple Approver Microsoft Flow
  • Sending a Tweet from Microsoft Flow
  • Starting a Microsoft Flow from a PowerApp

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