web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Using Filter Query to ...

Power Automate

Answered

Using Filter Query to get the latest item

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hi All

I'm trying to get the latest item in share point list.

Can I use Filter Query in get items directly to accomplish?

maybe getting the largest ID.

thanks

Categories:

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (2)

Verified answer

v-yetonggu-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Anonymous ,
I did a test for your reference.
In my scenario:

int(item()?['ID']) max(body('Select'))

Best Regards,
Sunshine Gu

Was this reply helpful? Yes No
Verified answer

cmht 82 on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous
The easiest way would be to use Get items with Top count=1 in advanced options:

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Dear @cmht @v-yetonggu-msft
thank you both for the solutions.
thank you

Was this reply helpful? Yes No

Join the conversation