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

All responses (5)

Answers (0)

takolota1 4,894 Super User 2025 Season 1 on at

Like (0)

Report

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

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
laclws 16 on at

Like (0)

Report

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

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.
Nived_Nambiar 17,886 Super User 2025 Season 1 on at

Like (0)

Report

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

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 ?
laclws 16 on at

Like (0)

Report

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

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.
Nived_Nambiar 17,886 Super User 2025 Season 1 on at

Like (0)

Report

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

Hi @laclws

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

Second

This should be written in expression part