This spring I had the great privilege of speaking in front of a great room of people at SharePoint Saturday Montreal. At this conference i outlined how easy it was to build a great solution from conception to implementation using just PowerApps, Flow and a few connectors. In the space of half a session (I had to do some talking too ;-p ) I build a full solution using PowerApps, Flow, SharePoint and Azure Database. As promised here is the slide deck from my presentation.
Today I was trying to build a flow that kicked off from the Flow Launch Panel in my library. To do this for a list you simply need to create a flow based on the trigger “for selected item”. Once published the Flow Launch Panel is enabled on the list and you can now launch any flows that are attached to the list manually. You can do this for a library as well. The difference however is for a library you want to use “for selected file”. Seems really straight forward and easy right? Sure if it worked as expected.
Problem: Microsoft Flow Trigger “For Selected File” Missing
So here’s the problem. When you create a new flow a lot of people select the platform they are working with to decrease the count of the items to choose from. This one little step is what causes the problem. Allow me to illustrate. I created a new flow and wanted my trigger to be when a SharePoint file is selected in a library. So I created the flow, selected SharePoint and started to type “select” to filter the list. Here’s what I got:
Resolution: Easy, But a Workaround
The fix\workaround is so simple I hope Microsoft can fix it soon. To select the missing trigger, DON’T select SharePoint as the platform. When you start to type in your filter, it will actually show up before the “for selected item” trigger.
Thanks for reading!
So today I started creating a new custom approval using Microsoft Flow. I had been working for about 15 minutes or so and thought to myself that it may be a really good idea for me to save my work because we all know that if I didn’t do it soon something would cause me to lose everything (because initial save hadn’t been accomplished yet. When I clicked on the save button I received an error I hadn’t received before. “Tag value to large. Following tag value…exceeded the maximum length. Maximum allowed length for tag value – ‘256’ characters.
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.
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.
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.