Skip to main content
Nintex Community Menu Bar

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

  • February 13, 2020
  • 2 replies
  • 25 views

VijayAntoine
Forum|alt.badge.img+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

Forum|alt.badge.img+12
  • Scholar
  • February 13, 2020

@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

VijayAntoine
Forum|alt.badge.img+3
  • Author
  • February 20, 2020

Thanks @kunalpatel

 

It works