Getting the most recent modified date from a SharePoint list?

Like (0) Share

Report

Posted on 21 Mar 2022 12:55:44 by Rob_CTL

Hi,

I have a simple SharePoint list that is populated by a Sales PowerApps, on the app when a sale is made it creates and entry in the list which includes the resellers name, the purchase date, sales amount.

The next step I am working on is generating a report that will email the reseller their sales total, this is driven from a button in the app which fires the Flow, the reseller can press this button whenever they require a report. As part of this flow when an item is processed it sets the "Reported" column to YES. This of course means the "Modified" date is update also. I'd like to include in the report email the date/time when the report button was last run, for this I want to be able to query the SharePoint list and find the most recent modified date which I can then output to the email body. This is the bit I am bit stuck on and if someone could help with this, that would be great.

Thanks

Rob

All responses (2)

Answers (1)

Rob_CTL on 23 Mar 2022 at 09:37:10

Like (0)

Report

Re: Getting the most recent modified date from a SharePoint list?

Great idea, thanks
Verified answer

KvB1 1,596 on 21 Mar 2022 at 13:32:34

Like (1)

Report

Re: Getting the most recent modified date from a SharePoint list?

In the get items action, under advanced options, there is a 'Sort by' field. You can use: Modified desc to get the return of the action sorted by the date they were modified. Then if you set the max amount of items to retrieve to 1, you just get the most recently modified item of that list. Of course you can also combine this with odata filter queries