cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

CDS - List Records to find TOP 1

Hi guys,

 

Do you know how to get TOP 1 value with CDS "List Records" action ? I know I can use the Top Count setting but no idea how to use it properly like how to select a single column (of the TOP 1) and then how to make it Descending.

Even I cannot find the column to "Order by" in Dynamic content (while writing this message, should I just put the column name, since I did it for Filter Query as well)

image.png

 

Kindly advice,

 

Thanks in advance,

Axal

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Helper II
Helper II

Re: CDS - List Records to find TOP 1

Hi,

 

I figure this out. And yes, just need to input manually for the column name and follow by asc or desc.

 

Thanks,

Axal

View solution in original post

1 REPLY 1
Highlighted
Helper II
Helper II

Re: CDS - List Records to find TOP 1

Hi,

 

I figure this out. And yes, just need to input manually for the column name and follow by asc or desc.

 

Thanks,

Axal

View solution in original post

Helpful resources

Announcements
firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (7,777)