Dynamically populate a combobox

(0) Share

Report

Posted on by JimboSey

321

Hi,

I have an App, pointing to a SharePoint List.

On the App side, what I want to achieve is dynamically populate the choices in a combobox based on a selection in another combobox.

To help understand, here is my list

combobox1 will contain the two choices from the 'Strand' column, so Power Platform team (PPT) and Learning Systems Team (PST)

combobox2 will contain the contents of the 'Button' Name' column.

So what I want it work like is, if the user selects 'Power Platform Team' at combobox1, then combobox2 should dynamically populate to only show 'Added to Workplans' and 'Rejected' as choices, and if 'Learning Systems Team (LST)' is selected at combobox1, it only shows the choices 'Under review' and 'More info required'.

Any help much appreciated.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

LaurensM 12,516 Moderator on at

Like (2)

Report
//Change Listname to your actual list name LISTNAME, //If nothing is selected show everything, else filter based on selection IsBlank(ComboBox1.Selected) || Strand.Value = ComboBox1.Selected.Value ).'Button Name'
Adjust the code to your specific case where necessary.

This should allow you to dynamically filter the second combobox options.

If this solves your question, would you be so kind as to accept it as a solution.
Thanks!

Hi @JimboSey,

This is certainly possible. Let's look at the solution step by step:

(1) Create combobox1 and set the items property to:
Choices(LISTNAME.Strand)

(2) Create combobox 2 and use the following formula in the items property:
Filter(
Was this reply helpful? Yes No


        
            
            
        
         
        
            
        
          
            
              
                
                  

                    
                    
                    
                        
                         
                    
                    
                      
                     
                        






 
    


 
    
    
    
    
    
    
    
    
      

    

    
    
        
        
    

    
        
     

       

        
            
        

    

  
                        
                            










 











 





 












 





 


  











 





 












 





 








 
    

  

 
    

    
      
        
        

         

         
        
            
            
             
                
                
            
            
        
        
        

        
            
              
                JimboSey
                321 
                
                 
                
                
             
         
            
                
                        
                 
            

    


 on  at 
                        
                    
                        
                        
                        
                          
                            
                            
                            
                              










 


























 Like
(0)
                            

 




























    



 



 



Report
                        
                          
                        
                      
                    
                  
                
              
              
                
                  
                    
                      
                        This worked perfect, exactly as I needed it. 
 
I had managed to get it working to a certain extent with the following;

Filter(LISTNAME, Strand.Value = ComboBox1.Selected.Value).'Button Name'
 
But your code allows for all the choices to be seen if nothing selected at ComboBox1.
 
Thanks again 🙂
                      
                    
                        
                        
                            





 





 










 





 






    
    
    
    
        
    
    


                        
                         
                      
                          
                       
                        
                            
                             
                              
                            
                            
                            
                            
                                
                                    
                                    
                                    
                                    
                                    
                                        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