Answered

sort by column insert into function

(0) Share

Report

Posted on by Tobiask1

Hi, I'm still fairly new to creating functions in Power apps. I have built a data table that refers to a sharepoint list (lead list). When a word is written in a field (DataCard Value1), the datatable filters out all items from the list in the sharepoint. I would like to sort these in descending order and not ascending. How and where do I insert sort by columns here then?

Filter(AddColumns('Lead Liste'; "New Spalte"; Concat('Product name';Value;","));StartsWith(Title; DataCardValue1.Text))

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Verified answer

WarrenBelz 156,319 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Tobiask1 ,

You did not mention the field to sort on - just insert it below

Sort( Filter( AddColumns( 'Lead Liste'; "New Spalte"; Concat( 'Product name'; Value; "," ) ); StartsWith( Title; DataCardValue1.Text ), YourSortFieldHere, Descending ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Tobiask1 41 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @WarrenBelz,
Unfortunately, my data table is now not displayed at all. What am I doing wrong?

Was this reply helpful? Yes No
Tobiask1 41 on at

Like
a
(0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
Verified answer

AJ_Z 3,711 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Filter( AddColumns( 'Lead Liste'; "New Spalte"; Concat( 'Product name'; Value; "," ) ); StartsWith( Title; DataCardValue1.Text )), offerdate, Descending )

You are missing a bracket and have on extra at the end try this:

Sort(
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