All posts in Office365

Creating Dedicated PowerApps Forms for Each Mode in a SharePoint List

The other day I was tinkering around with a request to have different fields hidden based on the mode (New, Edit, View) the SharePoint form was in.  The process seemed to be pretty straight forward, but for some reason it didn’t quite work out as expected.  I finally figured out the cause and thought sharing the steps for creating dedicated PowerApps forms for each mode in a SharePoint list might help others out.

How Not To Do It

So first off let’s start with how not to do it.  The settings are located as properties of the SharePoint Integration object in your solution.
Creating Dedicated PowerApps Forms for Each Mode in a SharePoint List - SharePoint Integration Properties
Properties of the SharePoint Integration Object
I had thought that by simply  calling the EditForm function and passing the form I had used for editing, it would automatically load for me: Unfortunately this did nothing.

Creating Dedicated PowerApps Forms for Each Mode in a SharePoint List

So above we are telling the form that we want to declare our edit form as the SMRequestForm_Edit, but we aren’t actually telling PowerApps how to get there.  So we just need to add a little bit of code that tells it to move to that particular screen: As you see in the screenshot below, I have actually done something similar for all of the forms.  However, I haven’t created a View Form yet so it is looking at the EditForm.
Creating Dedicated PowerApps Forms for Each Mode in a SharePoint List - How To Transition
Check out the transition in action:

Preparing for Updates

One thing I would like to suggest you do is add a bit of code at the beginning of the transition component that tells your form what stage you are at.  This is to assist with any custom code you might want to add depending on the form stage you are at (I will be covering this in a future post).  Simply modify your code by adding the initializing and setting of a variable (I called it formStage). Thanks for reading!!

Updating a List Item from Microsoft Flow

In this post we will cover the steps needed in updating a list item with Microsoft Flow.

Read more

Setting SharePoint List-Item Level Security With Microsoft Flow

As I stated in my previous post I wanted to demonstrate how to do something in SPD Workflows as well as with Microsoft Flow.  In this second part, I am going to be setting SharePoint list-item level security with Microsoft Flow.  The steps are very similar, but I still wanted to provide examples for anyone just working away at some of these types of requirements within their own environments.

Read more

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 8 – Sending a Tweet from Microsoft Flow

In my previous post, I showed you how to set up multiple approvals in a workflow. This post is going to continue along the requirements I set out in part 1 of this series.  I’ll be walking through sending a tweet from a Microsoft Flow.  It’s pretty straightforward.  Microsoft even has it as a template I believe, but I still wanted to illustrate how to do it because this is actually part of a bigger flow and an item in a solution’s requirements.  We’ll be continuing on from where I left off in part 8 of this series, but the steps I have here can be picked up and added to any flow you will be working on.

Posts in this series:

Read more