Dynamics Community Forum Thread Details

D365 F&O: Create PowerAutomate Flow for Pending Vendor Invoice WF Submission

Hi,

As the title says I am looking for a solution using PowerAutomate to send daily email reminders that a user has an invoice to submit in the Pending Vendor Invoices form. With limited things to work from it is rather difficult to create this relatively simple reminder for users who get swamped with emails all day. They currently get an email that lets them know they have one to submit (picks up a newly created record that is the "Requested approver email email status") and sends them an email. However, if they don't act on it immediately they tend to forget as humans do. While the standard alert works great for those who live in the system, it often is overlooked and as we know there is no standard functionality in the system that allows for reminder emails for records that are not currently in workflow.

To mitigate this we want to send them daily emails that remind them of invoices to submit. There is an icon on the Pending vendor invoice (PVI) form that indicates whether or not the PVI is in workflow. I was thinking that I could leverage that value that is equivalent to "no" or not submitted and use the email associated in the Requested approver field to determine who to associate with the logic being if it's been over 24 hours since the PVI record was created and that icon is not considered submitted then send the reminder with details/link to the PVI. I believe the field/control name for this icon is RequestStatus.

Has anyone had success with something like this? I am having an issue finding that trigger or business event in the available selections in PowerAutomate. This would be a huge win for something so simple.