Check if Collection Column have a value

[indhaa]

Pls let me know what is wrong with the below code

I'm checking two collections and if both are empty, I want the error to prompt.

But now it is validating this code and submitting the form even if the collections is empty

If(
    CountRows(
        Filter(NewCollection,
            Or(
                IsBlank(A),
                IsBlank(B),
                IsBlank(C)
            )
        )
    ) && 
    CountRows(
        Filter(EditCollection,
            Or(
                IsBlank(D),
                IsBlank(E),
                IsBlank(F)
            )
        )
    ) > 0 ,
    Notify(
        "Admin Role is required",
        Error
    ),
  SubmitForm(Form))

[indhaa]

Hi

The code for the Form.Edit part is still not working .

Even if the Edit collections is not Empty it is not submitting the form when the NEW collection is empty.

I tried testing by changing "||" to "&&".  It does submit the EDIT Collection when I changed to that but when I delete all the records in the collection it does submit like that too without ANY collections data.

If I put the same collections twice in the code it is working but if I put the two collection, it just say missing New Collection.

Even if EDIT Collection is not there, NEW collection can be submitted but NOT the other way around. 

If(Form.Mode = FormMode.New,
	If(
    CountRows(
        Filter(NewCollection,
            Or(
                IsBlank(A),
                IsBlank(B),
                IsBlank(C)
            )
        )
    ) > 0,
	
    Notify(
        "Admin Role is required",
        Error
	), 
		
    Notify(
     "Success",
     Error 
    )
	),
	
	Form.Mode = FormMode.Edit,
	
	If(
   CountRows(
      Filter(
         NewCollection,
         IsBlank(A) || IsBlank(B) || IsBlank(C)
      )
   ) > 0 ||
   CountRows(
      Filter(
         EditCollection,
         IsBlank(D) || IsBlank(E) || IsBlank(F)
      )
   ) > 0,
   
   Notify(
     "Admin Role is required",
     Error
   ), 
    Notify(
     "Success",
     Error 
    )

    );
    
)

[indhaa]

What does + means ..  is it checking both are empty?

I want to continue submitting if one is not, In that case will it be the same?

[RandyHayes]

@indhaa 

CountRows returns a number.  This is what was wrong with your original formula...you were trying to perform a logical AND between two numbers.

Plus will add two numbers.  In this case, the resultant number from the CountRows.  The two products are added together.  If there is any countrow that returns more than 0, then it will be added as the result.  THEN, your real logic is to see if that number is > 0.

Please change your Formula to the following:

If(
    Form.Mode = FormMode.New,
        If(CountRows(Filter(NewCollection, IsBlank(A) || IsBlank(B) || IsBlank(C))) > 0,
            Notify("Admin Role is required", Error), 
	
            Notify("Success", Error)
        ),
	
    Form.Mode = FormMode.Edit,
        If(
           (
           CountRows(Filter(NewCollection, IsBlank(A) || IsBlank(B) || IsBlank(C))) +
           CountRows(Filter(EditCollection, IsBlank(D) || IsBlank(E) || IsBlank(F)))
           ) > 0,
   
           Notify("Admin Role is required", Error), 
           Notify("Success", Error)
        )    
)

[indhaa]

Hi Randy

So I have two Collections in the Edit Mode. So what I want to check is if both are empty. If not then it is success. Meaning if Edit collection is not empty then it is success.

I tested with your code. Getting the same result

Maybe I need to amend to check the Edit collection are empty first and if so then check the New collection if not success

[indhaa]

Hi ,

So did more testing with a label to check what I'm getting for the Count Rows and found the reason. Nothing wrong with my code or yours, I was getting another result due to what is in my collection.

So achieved what I'm trying to find with IsEmpty condition in addition to Count Rows. Going to do more testing 

Thanks @RandyHayes @WarrenBelz