Hey,
I think I'm looking into the same thing as the OP, but maybe with some variation:
I have a Sharepoint list where people upload A/P invoices to be paid:
- A flow is triggered, as a result of this
- It is approved, via Modern Approvals
- Once approved, A/P accountant receives email that an invoice is ready for payment
What I am in need of is this:
- A regular email, that will tell me a list of Invoice submissions that have not been approved. (maybe with a limit of 10 days?)
- A regular email, that will tell me a list of invoices that have been approved, but not paid by A/P (also, maybe with a limit of 10 days?)
I have a column in Sharepoint, that updates the status of the entered invoice as follows:
- Pending, when invoice is entered initially in list
- Approved, Pending Payment, when manager approves for payment
- Payment Complete, when A/P accountant cuts check
Hope this helps. Let me know if you need more info.
Thanks!
