Unanswered

Gallery Repeating Table - Data Validation

(0) Share

Report

Posted on by indhaa

Form1.Mode = FormMode.New && IsBlank(Input_1), Notify( "Source Name requires a value", Error ), Form1.Mode = FormMode.New && IsBlank(Input_2), Notify( "Server Name requires a value", Error ), Form1.Mode = FormMode.New && IsBlank(Input_3), Notify( "Source IP requires a value", Error )

So it just submit the form after validating the second row. It prompt error msg for the row I'm in if it doesn't meet the validation.

If I edit the first row it validate it and submit the form even if second row is incomplete.

It just validate the row my mouse is in.

Can help to validate all the rows in my code @RandyHayes

I have created a repeating table and have set data validation on the columns. During testing found that it is only validating the gallery row I'm currently editing, I want it to verify all the rows.

So if I'm editing the second row it does not check the first row. Hope I'm clear

If(


                                                   
                        
                            




 





 






 





 


                        
                        
                            




Categories:
 
Building Power Apps



                        
                        
                            
                                 
                                
                                 
                            

                             
                            
                            
                                
                                     
                                        
                                            I have the same question (0)

 

                     
                     
                     
                     
                     
                     
                     
                    
                    

                    
                     
                     
                                                              
                                                              
                                                              














 






 





 










 





 










 





 










 





 




    
    


    
    
        
        
        
        
            
        
        
            
        

        
        
        


 

















 






 




        

	

    
        
    



                       
                    

                    
                    
                        
                              
                                     All responses (7)
                            
                            
                                   Answers (0)
                                
                            
                        
                         
                            









 













































 





 










 





 










 





 










 





 







    










  
  

  
      
      
    


 


 

  



 
            
            
        
         
        
            
        
          
            
              
                
                  

                    
                    
                    
                        
                         
                         
                        
                    
                    
                      
                     
                      
                        





 

    


 
    
    
    
    
    
    
    
    
      

     

    
    
        
        
    

    
        
     

       

        
            
        

    

  
                        
                       
                            









 












 





 












 





 


  











 





 












 





 








 
    

  

 
    

    
      
        
        

         

         
        
            
            
             
                
                
            
            
        
        
        

        
    
              
                
                PriyankaGeethik
                3,320 
                
        
                
                
             
         

            
                
                        
                        
                             
                                
                                        
                                        Super User 2024 Season 1
                                        
                            
                         
                     
                 
            

    


 on  at 
                        
                    
                        
                        
                        
                          
                            
                            
                            
                              










 


























 Like
(0)
                            

 

































    



 



 



Report
                        
                                
                                    

                                        

                                        
                                            Copy link
                                        

                                        Link copied!
                                    
                                
                          
                        
                      
                    
                  
                
              
              
                
                  
                    
                      
                        Hi @indhaa ,
 
Please check if something like below code with help in your case ?  You might need to change the code according to your logic.
 
 
 
if( Form1.Mode = FormMode.New
 ForAll(
 gallery.AllItems,
 Collect(
 colTemp,
 IsBlank(Thisrecord.Input_1) || IsBlank(Thisrecord.Input_2) || IsBlank(Thisrecord.Input_3)
		 )
 )
 );
	If(
 !IsEmpty(colTemp),
 Notify(
 "Blank data present",
 NotificationType.Error
 ))
 
 
 
                      
                    
                        
                        
                            




 





 






 





 


                        
                         
                      
                          
                       
                        
                            
                             
                              
                            
                            
                            
                            
                                
                                    
                                    
                                    
                                    
                                    
                                        Was this reply helpful?
                                        Yes
                                        No
                                    
                                    
                                    
                                
                            
                        
                        
                  
                
              
            
          
        
        
            
            
        
         
        
            
        
          
            
              
                
                  

                    
                    
                    
                        
                         
                         
                        
                    
                    
                      
                     
                      
                        





 

    


 
    
    
    
    
    
    
    
    
      

     

    
    
        
        
    

    
        
     

       

        
            
        

    

  
                        
                       
                            









 












 





 












 





 


  











 





 












 





 








 
    

  

 
    

    
      
        
        

         

         
        
            
            
            
                
            
            
        
        
        

        
    
              
                
                indhaa
                
                
        
                
                
             
         

            
                
                        
                 
            

    


 on  at 
                        
                    
                        
                        
                        
                          
                            
                            
                            
                              










 


























 Like
(0)
                            

 

































    



 



 



Report
                        
                                
                                    

                                        

                                        
                                            Copy link
                                        

                                        Link copied!
                                    
                                
                          
                        
                      
                    
                  
                
              
              
                
                  
                    
                      
                        Hi,
 
So each row is saved to a collection before it can be submitted. So I just check the collection if any row is blank or prevent saving if blank?
 
How the code will be to check collection row. Same logic
                      
                    
                        
                        
                            




 





 






 





 


                        
                         
                      
                          
                       
                        
                            
                             
                              
                            
                            
                            
                            
                                
                                    
                                    
                                    
                                    
                                    
                                        Was this reply helpful?
                                        Yes
                                        No
                                    
                                    
                                    
                                
                            
                        
                        
                  
                
              
            
          
        
        
            
            
        
         
        
            
        
          
            
              
                
                  

                    
                    
                    
                        
                         
                         
                        
                    
                    
                      
                     
                      
                        





 

    


 
    
    
    
    
    
    
    
    
      

     

    
    
        
        
    

    
        
     

       

        
            
        

    

  
                        
                       
                            









 












 





 












 





 


  











 





 












 





 








 
    

  

 
    

    
      
        
        

         

         
        
            
            
            
                
            
            
        
        
        

        
    
              
                
                indhaa
                
                
        
                
                
             
         

            
                
                        
                 
            

    


 on  at 
                        
                    
                        
                        
                        
                          
                            
                            
                            
                              










 


























 Like
(0)
                            

 

































    



 



 



Report
                        
                                
                                    

                                        

                                        
                                            Copy link
                                        

                                        Link copied!
                                    
                                
                          
                        
                      
                    
                  
                
              
              
                
                  
                    
                      
                        So I will apply the same code to the save button. I think that will do it
I will let you know 
 
Thanks 
                      
                    
                        
                        
                            




 





 






 





 


                        
                         
                      
                          
                       
                        
                            
                             
                              
                            
                            
                            
                            
                                
                                    
                                    
                                    
                                    
                                    
                                        Was this reply helpful?
                                        Yes
                                        No
                                    
                                    
                                    
                                
                            
                        
                        
                  
                
              
            
          
        
        
            
            
        
         
        
            
        
          
            
              
                
                  

                    
                    
                    
                        
                         
                         
                        
                    
                    
                      
                     
                      
                        





 

    


 
    
    
    
    
    
    
    
    
      

     

    
    
        
        
    

    
        
     

       

        
            
        

    

  
                        
                       
                            









 












 





 












 





 


  











 





 












 





 








 
    

  

 
    

    
      
        
        

         

         
        
            
            
             
                
                
            
            
        
        
        

        
    
              
                
                PriyankaGeethik
                3,320 
                
        
                
                
             
         

            
                
                        
                        
                             
                                
                                        
                                        Super User 2024 Season 1
                                        
                            
                         
                     
                 
            

    


 on  at 
                        
                    
                        
                        
                        
                          
                            
                            
                            
                              










 


























 Like
(0)
                            

 

































    



 



 



Report
                        
                                
                                    

                                        

                                        
                                            Copy link
                                        

                                        Link copied!
                                    
                                
                          
                        
                      
                    
                  
                
              
              
                
                  
                    
                      
                        Hi @indhaa ,
 
This code will collect the rows having blank input_1 or input_2 or input_3 values in each row. You just need to check if this collection is empty or not. If empty all the rows have values in the mentioned controls else it will display error message. 
                      
                    
                        
                        
                            




 





 






 





 


                        
                         
                      
                          
                       
                        
                            
                             
                              
                            
                            
                            
                            
                                
                                    
                                    
                                    
                                    
                                    
                                        Was this reply helpful?
                                        Yes
                                        No
                                    
                                    
                                    
                                
                            
                        
                        
                  
                
              
            
          
        
        
            
            
        
         
        
            
        
          
            
              
                
                  

                    
                    
                    
                        
                         
                         
                        
                    
                    
                      
                     
                      
                        





 

    


 
    
    
    
    
    
    
    
    
      

     

    
    
        
        
    

    
        
     

       

        
            
        

    

  
                        
                       
                            









 












 





 












 





 


  











 





 












 





 








 
    

  

 
    

    
      
        
        

         

         
        
            
            
             
                
                
            
            
        
        
        

        
    
              
                
                PriyankaGeethik
                3,320 
                
        
                
                
             
         

            
                
                        
                        
                             
                                
                                        
                                        Super User 2024 Season 1
                                        
                            
                         
                     
                 
            

    


 on  at 
                        
                    
                        
                        
                        
                          
                            
                            
                            
                              










 


























 Like
(0)
                            

 

































    



 



 



Report
                        
                                
                                    

                                        

                                        
                                            Copy link
                                        

                                        Link copied!
                                    
                                
                          
                        
                      
                    
                  
                
              
              
                
                  
                    
                      
                        Hi @indhaa ,
 
Just to check. Is this issue fixed ? 
                      
                    
                        
                        
                            




 





 






 





 


                        
                         
                      
                          
                       
                        
                            
                             
                              
                            
                            
                            
                            
                                
                                    
                                    
                                    
                                    
                                    
                                        Was this reply helpful?
                                        Yes
                                        No
                                    
                                    
                                    
                                
                            
                        
                        
                  
                
              
            
          
        
        
            
            
        
         
        
            
        
          
            
              
                
                  

                    
                    
                    
                        
                         
                         
                        
                    
                    
                      
                     
                      
                        





 

    


 
    
    
    
    
    
    
    
    
      

     

    
    
        
        
    

    
        
     

       

        
            
        

    

  
                        
                       
                            









 












 





 












 





 


  











 





 












 





 








 
    

  

 
    

    
      
        
        

         

         
        
            
            
            
                
            
            
        
        
        

        
    
              
                
                indhaa
                
                
        
                
                
             
         

            
                
                        
                 
            

    


 on  at 
                        
                    
                        
                        
                        
                          
                            
                            
                            
                              










 


























 Like
(0)
                            

 

































    



 



 



Report
                        
                                
                                    

                                        

                                        
                                            Copy link
                                        

                                        Link copied!
                                    
                                
                          
                        
                      
                    
                  
                
              
              
                
                  
                    
                      
                        Hi,
 
I wont know how many rows will be there. How do I apply that.
 
 
                      
                    
                        
                        
                            




 





 






 





 


                        
                         
                      
                          
                       
                        
                            
                             
                              
                            
                            
                            
                            
                                
                                    
                                    
                                    
                                    
                                    
                                        Was this reply helpful?
                                        Yes
                                        No
                                    
                                    
                                    
                                
                            
                        
                        
                  
                
              
            
          
        
        
            
            
        
         
        
            
        
          
            
              
                
                  

                    
                    
                    
                        
                         
                         
                        
                    
                    
                      
                     
                      
                        





 

    


 
    
    
    
    
    
    
    
    
      

     

    
    
        
        
    

    
        
     

       

        
            
        

    

  
                        
                       
                            









 












 





 












 





 


  











 





 












 





 








 
    

  

 
    

    
      
        
        

         

         
        
            
            
             
                
                
            
            
        
        
        

        
    
              
                
                PriyankaGeethik
                3,320 
                
        
                
                
             
         

            
                
                        
                        
                             
                                
                                        
                                        Super User 2024 Season 1
                                        
                            
                         
                     
                 
            

    


 on  at 
                        
                    
                        
                        
                        
                          
                            
                            
                            
                              










 


























 Like
(0)
                            

 

































    



 



 



Report
                        
                                
                                    

                                        

                                        
                                            Copy link
                                        

                                        Link copied!
                                    
                                
                          
                        
                      
                    
                  
                
              
              
                
                  
                    
                      
                        Hi @indhaa ,
Did you tried add the code which the mentioned previously ? 
 
attached here for your convivence.
 
if( Form1.Mode = FormMode.New
 ForAll(
 gallery.AllItems,
 Collect(
 colTemp,
 IsBlank(Thisrecord.Input_1) || IsBlank(Thisrecord.Input_2) || IsBlank(Thisrecord.Input_3)
		 )
 )
 );
	If(
 !IsEmpty(colTemp),
 Notify(
 "Blank data present",
 NotificationType.Error
 ))
 
                      
                    
                        
                        
                            




 





 






 





 


                        
                         
                      
                          
                       
                        
                            
                             
                              
                            
                            
                            
                            
                                
                                    
                                    
                                    
                                    
                                    
                                        Was this reply helpful?
                                        Yes
                                        No
                                    
                                    
                                    
                                
                            
                        
                        
                  
                
              
            
          
        
        
      







 
                              
                            
                                
                                    
                                        Under review
                                        
                                    
                                    
                                         
                                            
                                            
                                                Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
                                            
                                            
                                            
                                                    
                                            
                                       
                                    
                                 
                                
                               
                            
                        
                         
                    
                    
                    
                    
                         
                                                                                       
                        
                    
                    
                     
                        
                          Join the conversation