SOLVED

Recurrence email notification based on 2 or more sharepoint list value

%3CLINGO-SUB%20id%3D%22lingo-sub-2241682%22%20slang%3D%22en-US%22%3ERecurrence%20email%20notification%20based%20on%202%20or%20more%20sharepoint%20list%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2241682%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20run%20a%20flow%20based%20existing%20sharepoint%20list%3A%3C%2FP%3E%3CP%3E-%20Send%20out%20recurrence%20email%20if%20sharepoint%20list%20column%20value%20(Status)%20is%20'Under%20monitoring'%20or%20'%20Work%20with%20restrictions'%3C%2FP%3E%3CP%3E-%20Other%20than%20the%20listed%20column%20values%20shall%20do%20nothing%3C%2FP%3E%3CP%3E-%20Purpose%20is%20to%20send%20out%20weekly%20updates%20to%20concerned%20personnel%20until%20status%20is%20'finalized'%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20encountered%20with%20some%20issues%20(flow%20successful%20but%20did%20not%20receive%20any%20notification%20email).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20An%20overview%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Can_make_it_0-1616985526417.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F267801i1FCDE84A2B017FF3%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Can_make_it_0-1616985526417.png%22%20alt%3D%22Can_make_it_0-1616985526417.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2.%20Filter%20query%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Can_make_it_1-1616985526431.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F267800i3FA5D2B376EAF89E%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Can_make_it_1-1616985526431.png%22%20alt%3D%22Can_make_it_1-1616985526431.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E3.%20HTML%20table%20(i've%20sent%20to%20automatic)%20and%20email%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Can_make_it_2-1616985526433.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F267802i0050A851590ED2E6%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Can_make_it_2-1616985526433.png%22%20alt%3D%22Can_make_it_2-1616985526433.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWould%20appreciate%20if%20anyone%20can%20help%20me%20out%20on%20this%2C%20thanks!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2241682%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2241775%22%20slang%3D%22en-US%22%3ERe%3A%20Recurrence%20email%20notification%20based%20on%202%20or%20more%20sharepoint%20list%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2241775%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%2F943981%22%20target%3D%22_blank%22%3E%40Can_make_it%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETry%20using%20%3CSTRONG%3ESend%20an%20email%20(V2)%3C%2FSTRONG%3E%20instead%20of%20the%20notification%20action.%20You'll%20get%20a%20better%20result.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20noticed%20the%20notifications%20do%20get%20blocked%20after%20a%20while%20if%20too%20many%20notifications%20go%20out%20or%20if%20I%20was%20doing%20a%20lot%20of%20testing%20and%20likely%20appearing%20to%20be%20spam%20or%20something%20(these%20are%20my%20observation).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEmail%20seems%20to%20work%20fine.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%20and%20best%20wishes%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi All,

 

I am trying to run a flow based existing sharepoint list:

- Send out recurrence email if sharepoint list column value (Status) is 'Under monitoring' or ' Work with restrictions'

- Other than the listed column values shall do nothing

- Purpose is to send out weekly updates to concerned personnel until status is 'finalized'

 

I've encountered with some issues (flow successful but did not receive any notification email).

 

1. An overview

Can_make_it_0-1616985526417.png

 

 

2. Filter query 

Can_make_it_1-1616985526431.png

 

3. HTML table (i've sent to automatic) and email

Can_make_it_2-1616985526433.png

 

Would appreciate if anyone can help me out on this, thanks!

 

3 Replies

Hi @Can_make_it 

 

Try using Send an email (V2) instead of the notification action. You'll get a better result.

 

I've noticed the notifications do get blocked after a while if too many notifications go out or if I was doing a lot of testing and likely appearing to be spam or something (these are my observation).

 

Email seems to work fine.

 

Cheers and best wishes

Damien

Hi Damien,

Thanks for the quick response. I've tried with Send an email (V2), same thing happened.
Flow successful but no emails.
best response confirmed by Can_make_it (New Contributor)
Solution

@Can_make_it Your filter query is wrong, you've got it as Status eq 'Work with restrictions' and Status eq 'Under monitoring'. You need to use or

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User