Categories: Microsoft 365

SharePoint Online – Required info and Flow, is this really needed?

Recently the Attention views were introduced in SharePoint Online. This is a great feature but does this all work as expected?

Let me start with what explaining what the attention view is.

When documents have required fields that haven’t been completed then there will be a very visible yellow “Required Info” where ever there is information missing.

Ok, this is great, although I do question what required means if you can still create the document without the required info!

Then I created a new Required Column as a site collection column within my SharePoint online site collection. This column is required, however in my document library this column seems to be ignored. The list columns appear as attention seeking fields, but site collection columns are not marked as attention seeking columns. Is this again a confirmation of my previous post, Are Content Types Dead? Or is this simply something that was missed during the development.

Then to confirm what ‘required’ really means I decided to create a Flow. When I create my document the document is left checked out as you would expect and my Flow is as expected not triggered. Once I complete the missing data I would expect that my Flow would be kicking in. So the required fields do not stop you from creating a document that isn’t visible to anybody else, but it does stop you from publishing the document. Well that is how I expected things to work. So I created a flow with a trigger “When a file is created …”, but my flow never starts.

Ok, so maybe I’m wrong in my initial understanding. So now I’m creating a new flow, but this one works on the document being created or modified and this time I’m having more luck.The email is being sent.

I had a look at the content of the email that was sent:

2017-11-13T12:49:21Z  Document 2017-11-13T13:39:40Z

The modification time is indeed now and the created data is when I originally created the document without the required fields being completed.

Ok, time for my final test. I’m removing the required column, before I create another document. I’m using Microsoft Word online to create the document. A Document2 is now created and I straightway receive multiple emails. So this is at the stage where I would expect that the document isn’t really created yet.

So far my conclusions. Before creating a flow, make sure that you know if there are required columns or not. Also when there aren’t, make sure that your flows don’t start before the document has been completed.

Pieter Veenstra

Business Applications and Office Apps & Services Microsoft MVP working as a Microsoft Productivity Principal Consultant at HybrIT Services. You can contact me using

View Comments

Recent Posts

Calculate the Sum for a SharePoint column in Power Automate

Last week Shane Young asked me about calculating the Sum for a SharePoint column in…

3 hours ago

Object must implement IConvertible in Power Apps

In Power Apps when you do a Patch to create a new item or to…

4 days ago

Get started with adaptive cards in Power Automate

Getting started with adaptive cards can be difficult. In this post i have written some…

1 week ago

Create PDF documents from data in Power Automate

In this post I will look at how to create PDF documents from data. Use…

2 weeks ago

Unnest nested arrays in Power Automate

We all know this problem, you have a nested array in Power Automate but how…

3 weeks ago

Advanced settings not loading in Power Platform

Yesterday one of my clients showed me an issues where the Advanced settings didn't load.…

4 weeks ago