Tech Community: Flow to notify based on column input

This blog post is inspired by the following Microsoft Tech Community conversation:

https://techcommunity.microsoft.com/t5/PowerApps-Flow/Flow-to-notify-based-on-column-input/m-p/812666

The user wants to send an email to users “assigned” to a document after it has been uploaded. In this demo I am using a standard document library with an additional site column called “AssignedTo”.

Within your Document Library, click “Flow” and select “See you flows”

Within Power Automate, click “New” and select “Automated – from blank”

Provide a Flow name, i.e. “Email assigned to”, select the SharePoint “When a file is created (properties only)” trigger and click “Create”

Point it to your site and document library

Add a “Condition” action and set “Value” to AssignedTo.DisplayName, condition is not equal to and choose a value to expression null

  • This condition action will check for empty “AssignedTo”

Set the “Yes” branch to the “Send an email (V2)” action with AssignedTo.Email in the “To” field

Set the “No” branch to the “Send an email (V2)” action with CreatedBy.Email in the “To” field

Any time a document is uploaded to the site an email will be generated notifying the “AssignedTo” of the document or it will email the “Created by” that the “AssignedTo” site column is blank.

This is a simple Flow but it showcases condition and error checking that is paramount for production workloads.

Thanks for stopping by.

Norm

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s