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)

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

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 41 on at

Like (0)

Report

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,129 Super User 2025 Season 2 on at

Like (0)

Report

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 41 on at

Like (0)

Report

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,974 Moderator on at

Like (0)

Report

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