Skip to main content

O365: Meta Data - Auto Population for improved Search

 O365: Meta Data - Auto Population for improved Search


Having discussed the advantages of using meta data so far we have touched only on populating these fields using manual entry, either by typing or by selection from a drop list.

If we wish to auto populate meta data fields we can do this in one or two ways.

Default Meta Content.

This method populates a Meta Data field with content that can be changed, removed or enhanced.
Any Meta Data field that is created by adding a SharePoint list or library column will have a default value setting.

This can be set in the List/Library Settings page to any value you wish. In the above illustration I have set the DocType column in a Training Documents Library. The effect is that any document created from the template in this library will be flagged as DocType = Training:
  The content of the field can be subsequently changed or amended. So, A user could change "Training:" to "Training: SharePoint Library Meta Data"

You may note that "Training:" is an element of the taxonomy, as is "SharePoint Library" and "Meta Data". So, in this example you have a taxonomy with three levels of indexing, one created automatically and the other two added manually. 

Automatic Meta Data Content Using Power Automate

This method populates a Meta Data field with content specified in a process. The content will always revert to the value specified in the process whenever the process is run.

Some Meta Data columns in Libraries and Lists don't show a default value setting.
However, you can still populate these fields using Power Automate.

The Title column has no default value setting.

Click on 



the Automate icon and select See Your Flows

Select +Create from the left menu,


Then select Automated flow from the top gallery and skip the wizard


Type 'sharepoint' in the trigger search box


and scroll the triggers to locate the "When a file is created or modified (properties only)" trigger.

NOTE: SharePoint Triggers are very specific. If you are working with a List the triggers will be the ones that specify changes to an ITEM.
If you are working with a Library the triggers will be the ones that specify a change to a FILE.
In this case we are not seeking changes to either ITEM or FILE, but changes to the PROPERTIES of a file, i.e. Meta Data


From the drop lists choose the site and library. We can leave the folder entry blank as we want this to action for the entire library.

Click New Step and enter 'sharepoint' in the action search and scroll through the actions

to find the "Update file properties action".

From the drop lists choose the site and library, then click in the ID box. This will display dynamic content from the TRIGGER

That is, the data ID from step one which triggered the flow is available to identify which data item you wish the action to change. In this case we are changing a file property for the same item, so we can select the ID in the display to the right.

Now enter what you wish the Title field to contain.

Click on save and the flow will be ready to run.

Now whenever anyone makes a change to the Training Documents Library by creating a new document, or by changing the Meta Data for an existing document, the Title Meta Data field will be re-set to the value in the flow.

To Summarise 

Two separate and independent methods to automatically update data contained in a meta data field or column.

Which is preferable will depend on exactly what you wish to do with data for your business. There are no hard and fast rules. You can also add IF, AND, OR conditions to the workflow to ensure that auto updates always fulfil your requirements.



Don't be afraid to experiment, make Office 365 work for you.

We can show you how, or we can do it for you.











Comments

Popular posts from this blog

Electronic Document Storage and Management (EDMS)

EDMS is not just a means of storing computer files. A full EDMS system allows for the process of importing both paper and computer generated documents into a computer system and indexing the files for easy and swift retrieval. In effect you can dispose of your traditional paper filing system. No more gathering letters, invoices and orders into filing groups and no more slotting them into the correct folders. Of course, you only use a paper filing system because you know you may need that document again in the future. Equally, when you do want that document it's invariably missing, either misfiled, or on someone else's desk. With EDMS documents are where you placed them and they are available for you to use where ever you are. All you need is a computer, tablet or smart phone and an Internet connection.As most modern businesses already use the Internet for everyday interaction with banks, Inland Revenue, Companies House, insurance companies, suppliers and customers it no longer ...

Leadership: So you want to be Powerful?

Throughout my life, in both business and personal spheres I have found that individuals seeking answers invariably look for 'silver bullet' solutions.     In a recent post on LinkedIn a n Influencer wrote that she had been asked the question ' Who is the most powerful person you ever met? '     The question was posed by a 17 year old and the author guessed that the answer being sought was the name of some sort of X-Factor figure, This strikes a cord with me. Throughout my life, in both business and personal spheres I have found that individuals seeking answers invariably look for 'silver bullet' solutions. This applies to all generations, 'Boomer, X-Gen and Millennial, it applies to individuals of all levels of intelligence, and to individuals at all levels of authority.     The desire for someo ne to appear, like a genie from a lamp, wit h either ' the answer' to a problem , or ' the power' to solve the problem, or...

Law and Order: The Anonymous Text Tip-Off

The following article came out of an interview conducted with Max Doleh - Law enforcement organisations and Crime Stopper programs are turning to technology which enables text tip-off from the public to facilitate a police response. In September 2007 Master Sergeant Charles Phillips of the Oklahoma City Police Department published an item on the Oklahoma City Crime Stoppers web site (http://www.okccrimetips.com/ ) calling for increased resources to bring this technology to OKC. In November 2007 it was announced that Crime Stoppers of Oklahoma City have engaged technology company ProductiveT to develop an SMS system that is radically different to others in use in the country. Max Doleh, ProductiveT president and CEO answers questions – 1 . What makes the Oklahoma City system so different? The ProductiveT technology differs greatly from other offerings. The police department have their own dedicated number for receiving the messages and unlike most systems there is no need for the sender...