SharePoint list flow that triggers an email every time an item is modify (even the same item)

%3CLINGO-SUB%20id%3D%22lingo-sub-2312877%22%20slang%3D%22en-US%22%3ESharePoint%20list%20flow%20that%20triggers%20an%20email%20every%20time%20an%20item%20is%20modify%20(even%20the%20same%20item)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2312877%22%20slang%3D%22en-US%22%3E%3CP%3EI%20created%20a%20PowerApps%20that%20creates%2Fupdates%20a%20SharePoint%20list%20with%20several%20columns%20(name%2C%20email%20address%2C%20date%2C%20time%2C%20yes%2Fno%2C%20multiple%20choices%2C%20and%20single%20lines.%20I%20need%20the%20flow%20to%20send%20a%20confirmation%20when%20a%20new%20item%20is%20created%20(this%20flow%20is%20working%20fine).%20I%20need%20an%20email%20to%20go%20out%20when%20an%20item%20is%20modified%20(status%20changes%20from%20New%20to%20Support%20assigned%20and%20technicians%20email%20address%20is%20added.%20as%20soon%20as%20the%20email%20goes%20out%20the%20Yes%2FNo%20column%20to%20update%20to%20yes%20from%20default%20NO.%20The%20current%20flow%20send%20the%20email%20when%20the%20status%20changed%20from%20new%20to%20support%20assigned%2C%20but%20keeps%20sending%20email%20every%20time%20I%20change%20the%20status%20from%20support%20assigned%20to%20any%20other%20status%20(pending%2C%20completed%20and%20cancelled).%20I%20still%20don't%20know%20how%20to%20update%20the%20Yes%2FNo%20column%20(I%20am%20doing%20it%20manually).%26nbsp%3B%20I%20need%20help%20desperately%20as%20this%20is%20my%20first%20time%20working%20with%20PowerApps%20and%20automation%20flows.%20Please%20Help!!!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2312877%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETriggers%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EYes-No%20Column%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2313379%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20list%20flow%20that%20triggers%20an%20email%20every%20time%20an%20item%20is%20modify%20(even%20the%20same%20item)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2313379%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1042275%22%20target%3D%22_blank%22%3E%40llopez685%3C%2FA%3E%26nbsp%3Bin%20your%20flow%20you%20can%20check%20if%20a%20specific%20column%20has%20been%20changed.%20First%20you%20need%20to%20make%20sure%20that%20you%20have%20turned%20versioning%20on%20for%20your%20list%20in%20List%20Settings.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20your%20flow%20the%20trigger%20should%20be%20%22When%20an%20item%20of%20file%20is%20modified%22.%20The%20first%20action%20will%20be%20%22Get%20changes%20for%20an%20item%20or%20a%20file%20(properties%20only).%20For%20the%20Since%20and%20Until%20fields%20you%20select%20the%20Trigger%20Window%20Start%20Token%20and%20Trigger%20Window%20End%20Token%20from%20the%20dynamic%20content%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%221-Flow.png%22%20style%3D%22width%3A%20764px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F277256iAFF5116819C9E186%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%221-Flow.png%22%20alt%3D%221-Flow.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENext%20you%20need%20a%20condition%20to%20check%20if%20the%20specific%20column%20(or%20columns%2C%20you%20can%20put%20more%20than%201%20in%20the%20condition)%20has%20changed.%20So%20in%20the%20image%20below%20we%20want%20to%20check%20if%20the%20Completed%20column%20has%20changed.%20We%20are%20also%20checking%20if%20the%20Completed%20column%20-%20a%20Yes%2FNo%20column%20-%20is%20set%20to%20Completed.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%222-Flow.png%22%20style%3D%22width%3A%20659px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F277255i9BD54EF7D3C5BAD4%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%222-Flow.png%22%20alt%3D%222-Flow.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20this%20example%20we're%20setting%20the%20Status%20column%20to%20Archive%20but%20your%20real%20life%20version%20will%20have%20different%20actions.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%223-Flow.png%22%20style%3D%22width%3A%20845px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F277254i30DFE9DFEA4577E5%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%223-Flow.png%22%20alt%3D%223-Flow.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUsually%20when%20working%20with%20Yes%2FNo%20columns%20in%20a%20flow%20you%20need%20to%20use%20true%20(for%20Yes)%20and%20false%20(for%20No).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I created a PowerApps that creates/updates a SharePoint list with several columns (name, email address, date, time, yes/no, multiple choices, and single lines. I need the flow to send a confirmation when a new item is created (this flow is working fine). I need an email to go out when an item is modified (status changes from New to Support assigned and technicians email address is added. as soon as the email goes out the Yes/No column to update to yes from default NO. The current flow send the email when the status changed from new to support assigned, but keeps sending email every time I change the status from support assigned to any other status (pending, completed and cancelled). I still don't know how to update the Yes/No column (I am doing it manually).  I need help desperately as this is my first time working with PowerApps and automation flows. Please Help!!! 

2 Replies

@llopez685 in your flow you can check if a specific column has been changed. First you need to make sure that you have turned versioning on for your list in List Settings.

 

In your flow the trigger should be "When an item of file is modified". The first action will be "Get changes for an item or a file (properties only). For the Since and Until fields you select the Trigger Window Start Token and Trigger Window End Token from the dynamic content:

1-Flow.png

 

Next you need a condition to check if the specific column (or columns, you can put more than 1 in the condition) has changed. So in the image below we want to check if the Completed column has changed. We are also checking if the Completed column - a Yes/No column - is set to Completed.

 

2-Flow.png

 

In this example we're setting the Status column to Archive but your real life version will have different actions.

 

3-Flow.png

 

Usually when working with Yes/No columns in a flow you need to use true (for Yes) and false (for No).

 

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

@RobElliott, Thank you very much for your response. I fallowed your flow and it is not working for me. This is the flow I created. I just need the Column Email sent to update from NO to YES after I update the Column Event Status from Blank to Technician Assigned and the stop sending email after I update the same item with any other information.

 

Thank you, 

Louie

 

llopez68_0-1620155261473.png

 

llopez68_1-1620155516591.pngllopez68_2-1620155578631.png

 

llopez68_3-1620155609875.png