Unanswered

Power Automate - How to Get recent created list of rows from sharepointlist based on OrderID

(0) Share

Report

Posted on by laclws

I have created a shoppingcart apps with same OrderID for same batch of ordering. This data would be saved in sharepointlist. How to I filter query to get the newly created list of rows with same OrderID?

in the Get Items, filter query I put

filter query.png

in compose:

then create html table

create html table.png

got error

I'm not sure is it the right steps

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @laclws

Instead of order by order id, you should sort it by created date.

Second

This should be written in expression part

Was this reply helpful? Yes No
laclws 45 on at

Like (0)

Report
Copy link

Link copied!

Thanks Nived N,

Is it possible to sort by last highest OrderID? I tried the Date and Time before but it will capture all the rows in the list. I'm not sure whether I think right or wrong, but the reason I put the Time so that if I have 2 orders within same day, I can capture only the latest Order based on recent time. I tried many times but failed using date and time to filter the most recent order.

Then I saw other people are using last highest OrderID, I managed to set my apps to have same OrderID for same batch of items ordered. but not sure how to do it for multiple rows of last highest OrderID.

Was this reply helpful? Yes No
Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

But i have a question
in the screenshot

It seems you are filtering by OrderId and then sorting by orderID, Should it be done with created date instead

As filtering by order id and then sorting by order id does not make any meaning ?

Was this reply helpful? Yes No
laclws 45 on at

Like (0)

Report
Copy link

Link copied!

I don't know how to do it. Can you show me the correct way to do it? I want to filter the last number of rows with highest OrderID. And convert into html table.

Was this reply helpful? Yes No
takolota1 4,980 Moderator on at

Like (0)

Report
Copy link

Link copied!

This template can give the most recent or the oldest records for unique values in given columns: https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Get-Distinct-Records/td-p/2191533

Was this reply helpful? Yes No