Send an email only if all items of a column are not empty (With a filter by Name for example)

  • 13 February 2020
  • 2 replies
  • 13 views

Badge +3

Hello,

 

I want to send an email only if all items of a SharePoint list column are not empty (With a filter by Name for example)

 

I have a List with two column (Saisie)

 

Name Etape
AAA 111
CCC  
DDD 222
CCC  
EEE 333
CCC  

 

 

When I make a filter on Name =CCC, I obtain this view :

Name Etape
CCC  
CCC  
CCC  

 

I want to know how to send an email Only if all cell of column "Etape" of List (Saisie) for "CCC" names are not empty (or fullfiled)

 

Thanks in advance for the help,

 

Regards,

 

VijayAntoine


2 replies

Badge +12

@VijayAntoine ...

 

  1. Use Query list and get ID, Name & Etape and store them in collection
  2. Use for each loop and ID collection, get index value
  3. Use collection operations in parallel branch and using index value get value of Name and Etape
  4. Use Run If and apply your condition that Name = CCC and Etape is not empty
    1. Send email notification
Badge +3

Thanks @kunalpatel

 

It works

Reply