web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Filter Gallery to Disp...
Power Apps
Answered

Filter Gallery to Display the SQL column Descending Number Only

(0) ShareShare
ReportReport
Posted on by 50
Sort(
 Filter('SQL TABLE NAME ',
 Created_By = CreatedBy.Text
 ),
 id, 
 Descending 
 )

I have incremental column that generates unique number for every new row. So, I am trying to get that number (descending ) created by me and add to line item, so I can you same number multiple time for each line item.

With the code I provided it is displaying the right descending number into gallery but when I am creating line item collection for desceding number is not catching the descending. How would be the best way to display from sql only descending and add that number to collection -- line item with no issue. 

Thanks in advence 

Best Regards

 

Categories:
I have the same question (0)
  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Hi @na12063 how are you progressing with this?

     

    @Anonymous 

  • Verified answer
    na12063 Profile Picture
    50 on at

    @TopShelf-MSFT,

    Sorry for late respond but is working fine the code I have displayed above.

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.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Valantis Profile Picture

Valantis 474

#1
Valantis Profile Picture

Valantis 474

#3
WarrenBelz Profile Picture

WarrenBelz 375 Most Valuable Professional

Last 30 days Overall leaderboard