Answered

Save single column of dates into a collection based on the month

(0) Share

Report

Posted on by MathewM

Wasn't exactly sure how to title this post so forgive me if it didn't make much sense. Hopefully, either my explanation or example will be able to help you understand my question.

With that said, I currently have a Share Point list that has a Date/Time Column named Date (dd/mm/yyyy). It is full of different dates from throughout the year. I was wondering if/how I can take that single column of dates and add them to a collection, sorting them into columns based on the month. It's probably a simple solution but for some reason I can't seem to think of a way to do it, so any help will be greatly appreciated.

Example

What I have currently inside a SharePoint column

Date

01/04/2022

01/01/2022

01/02/2022

01/06/2022

01/08/2022

01/11/2022

01/07/2022

02/01/2022

13/07/2022

What I want as a collection in PowerApps

Jan	Feb	Mar	April	May	June	July	Aug	Sep	Oct	Nov	Dec
01/01/2022	01/02/2022		01/04/2022		01/06/2022	01/07/2022	01/08/2022			01/11/2022
02/01/2022						13/07/2022

I am posting this late on a Friday afternoon so I apologise if I go silent for a couple days.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-yujincui-msft Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!
DataSource, Switch( Month(ColumnName), 1,Collect(CollectionName,{'1Jan': Text(ColumnName)}), 2,Collect(CollectionName,{'2Feb': Text(ColumnName)}), 3,Collect(CollectionName,{'3Mar': Text(ColumnName)}), 4,Collect(CollectionName,{'4April': Text(ColumnName)}), 5,Collect(CollectionName,{'5May': Text(ColumnName)}), 6,Collect(CollectionName,{'6June': Text(ColumnName)}), 7,Collect(CollectionName,{'7July': Text(ColumnName)}), 8,Collect(CollectionName,{'8Aug': Text(ColumnName)}), 9,Collect(CollectionName,{'9Sep': Text(ColumnName)}), 10,Collect(CollectionName,{'10Oct': Text(ColumnName)}), 11,Collect(CollectionName,{'11Nov': Text(ColumnName)}), 12,Collect(CollectionName,{'12Dec': Text(ColumnName)}) ) )

Best Regards,
Charlie Choi

Hi @MathewM ,

Please try the following formula:
ForAll(
Was this reply helpful? Yes No


        
            
            
        
         
        
            
        
          
            
              
                
                  

                    
                    
                    
                        
                         
                         
                        
                    
                    
                      
                     
                      
                        





 

    


 
    
    
    
    
    
    
    
    
      

     

    
    

    
        
     

       

        
            
        

    

  
                        
                       
                            









 












 





 












 





 


  











 





 












 





 








 
    

  

 
    

    
      
        
        

         

         
        
            
            
            
                
            
            
        
        
        

        
    
              
                
                MathewM
                
                
        
                
                
             
         

            
                
                        
                 
            

    


 on  at 
                        
                    
                        
                        
                        
                          
                            
                            
                            
                              










 


























 Like
a
(0)
                            

 

































    



 



 



Report
                        
                                
                                    

                                        

                                        
                                            Copy link
                                        

                                        Link copied!
                                    
                                
                          
                        
                      
                    
                  
                
              
              
                
                  
                    
                      
                        @v-yujincui-msft Thanks for the help, this works great!
                      
                    
                        
                        
                            




 





 






 





 


                        
                         
                      
                          
                       
                        
                            
                             
                              
                            
                            
                            
                            
                                
                                    
                                    
                                    
                                    
                                    
                                        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