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
