SOLVED
Home

Flow to notify based on column input

%3CLINGO-SUB%20id%3D%22lingo-sub-812666%22%20slang%3D%22en-US%22%3EFlow%20to%20notify%20based%20on%20column%20input%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-812666%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20have%20a%20SharePoint%20document%20library%20with%20bunch%20of%20folders%20(custom%20content%20type)%2C%20which%20belong%20to%20one%20employee%20each%20(mandatory%20input%20person%2Fgroup%20column%20named%20%22Employee%22).%20I%20want%20to%20create%20flow%20so%20that%20every%20time%20someone%20crates%20or%20uploads%20a%20file%20to%20that%20folder%2C%20email%20notification%20goes%20to%20the%20person%20who%20is%20defined%20in%20the%20%22employee%22%20field.%26nbsp%3B%3C%2FP%3E%3CP%3E%22Send%20a%20customized%20email%20when%20a%20new%20file%20is%20added%22%20template%20could%20work%2C%20but%20how%20to%20I%20create%20dynamic%20input%20that%20will%20extract%20value%20of%20custom%20column%3F%20Or%20maybe%20there%20is%20a%26nbsp%3B%20better%20way%20by%20setting%20up%20ownership%20of%20each%20folder%3F%3CBR%20%2F%3EAny%20suggestions%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-812666%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-812841%22%20slang%3D%22en-US%22%3ERe%3A%20Flow%20to%20notify%20based%20on%20column%20input%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-812841%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F260738%22%20target%3D%22_blank%22%3E%40btasevski%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20possible%20in%20Flow.%20High-level%20steps%3A%3C%2FP%3E%3CUL%3E%3CLI%3Ecreate%20new%20Automated%20flow%3C%2FLI%3E%3CLI%3Euse%20the%20SharePoint%20-%20%22When%20a%20file%20is%20created%22%20trigger%3C%2FLI%3E%3CLI%3Eadd%20Outlook%20-%20%22Send%20an%20email%22%20action%3CUL%3E%3CLI%3Euse%20value%20from%20%22employee%22%20column%20in%20the%26nbsp%3B%20%22To%22%20field%3C%2FLI%3E%3C%2FUL%3E%3C%2FLI%3E%3C%2FUL%3E%3CP%3EIf%20the%20employee%20column%20is%20populated%20manually%20you%20should%20add%20a%20Condition%20action%20to%20check%20for%20nulls.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20this%20helps.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENorm%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-824403%22%20slang%3D%22en-US%22%3ERe%3A%20Flow%20to%20notify%20based%20on%20column%20input%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-824403%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F111382%22%20target%3D%22_blank%22%3E%40Norman%20Young%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%2C%20it%20did%20help%2C%20for%20the%20most%20parts.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBR%2C%3C%2FP%3E%3CP%3EBosko%3C%2FP%3E%3C%2FLINGO-BODY%3E
btasevski
New Contributor

Hello,

I have a SharePoint document library with bunch of folders (custom content type), which belong to one employee each (mandatory input person/group column named "Employee"). I want to create flow so that every time someone crates or uploads a file to that folder, email notification goes to the person who is defined in the "employee" field. 

"Send a customized email when a new file is added" template could work, but how to I create dynamic input that will extract value of custom column? Or maybe there is a  better way by setting up ownership of each folder?
Any suggestions?

2 Replies
Highlighted
Solution

Hi @btasevski,

 

This is possible in Flow. High-level steps:

  • create new Automated flow
  • use the SharePoint - "When a file is created" trigger
  • add Outlook - "Send an email" action
    • use value from "employee" column in the  "To" field

If the employee column is populated manually you should add a Condition action to check for nulls.

 

I hope this helps.

 

Norm

Highlighted

Hi @Norman Young,

 

Thank you, it did help, for the most parts. 

 

BR,

Bosko

Related Conversations
Office 365 Outlook accounts for Partners
opendesign in Microsoft 365 on
2 Replies
Flow approvals
chrisjones2020 in Office 365 on
0 Replies
Form -> Flow -> Manager ->Response
Anatoly123 in Microsoft Forms on
1 Replies
Teams adaptive card scaling is off on IOS
FinnHat in Teams Developer on
2 Replies