{"id":3579,"date":"2020-08-31T07:35:00","date_gmt":"2020-08-31T14:35:00","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/run-a-flow-when-a-sharepoint-column-is-modified\/"},"modified":"2020-08-31T07:35:00","modified_gmt":"2020-08-31T14:35:00","slug":"run-a-flow-when-a-sharepoint-column-is-modified","status":"publish","type":"power-automate","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/run-a-flow-when-a-sharepoint-column-is-modified\/","title":{"rendered":"Run a flow when a SharePoint column is modified"},"content":{"rendered":"

Power Automate and SharePoint can be combined to create numerous automations to match your business needs. But one of the most common requests we\u2019ve gotten is to enable a way to trigger a flow when a column is modified<\/a>. Today were glad to announce a new trigger and action that makes it simple for you to create flows based on list of file modifications .<\/p>\n

New \u201cWhen an item or file is modified\u201d trigger.<\/h2>\n

With SharePoint lists and files, earlier you needed to rely on the \u201cWhen an item is created or modified<\/em>\u201d<\/a> trigger to get changes to an item. This meant that you had to add complex logic within your flow in order to get the exact event that took place within the list.<\/p>\n

We\u2019re now introducing a new dedicated \u201cWhen an item or file is modified\u201d <\/em>trigger that lets you filter to just the list or file modifications, making it much simpler to create a flow that\u2019s tuned to the right events.<\/p>\n

\"\"<\/p>\n

New \u201cGet changes to an item or file (properties only)\u201d action.<\/h2>\n

The new trigger can be paired with the new \u201cGet changes to an item or file (properties only) action<\/em>\u201d<\/a> to get the exact set of changes that might have occurred to a list or file.<\/p>\n

\"\"<\/p>\n

The action outputs helpful tokens such as \u201cHas Colum Changed:<Column name><\/em>\u201d that can be used to filter your flow to just the column(s) you care about<\/p>\n

\"\"<\/p>\n

Prerequisites<\/h3>\n

Note that in order for the action to function you need to enable versioning for your list or library<\/a>.<\/p>\n

Tutorial video<\/h2>\n

Here\u2019s a video that walks through the new action and trigger in detail along with a sample scenario where you can use modifications to a list to notify you in Teams and create a work item in Azure DevOps<\/p>\n