Unanswered

How do i create reminders with power automate for sales of given partnumber in business central?

Like (0) Share

Report

Posted on 14 Jan 2025 14:50:33 by ME-06011006-0

Hi
I need to create a flow, that sends reminders to a given mailadress, when a customer hasnt purchased a given partnumber/itemnumber in a given amount of time.
Should look something like this:

Customer purchases X itemnumber every three months
Customer hasn’t purchased in three months -> send reminder email to given email address including item id, customers phone number and date of last purchase

We are working in Business Centrail and Outlook, but i need help finding the correct triggers in power automate.
Massive thanks in advance.

Categories:

Business Process Flows

All responses (2)

Answers (0)

ME-06011006-0 4 on 15 Jan 2025 at 07:11:54

Like (0)

Report

How do i create reminders with power automate for sales of given partnumber in business central?

Many thanks Ibendlin - that makes sense, but im struggling to find the data from business central in power automate, although the connection is made. Is it not possible for me to choose data from an item number, that it should fetch?
lbendlin 7,777 Super User 2025 Season 1 on 14 Jan 2025 at 23:57:07

Like (0)

Report

How do i create reminders with power automate for sales of given partnumber in business central?

You cannot measure stuff that isn't there. You need to use a schedule, not a trigger.

Schedule a flow at regular intervals (once a day, or once a week) to collect the data and send the email. Ideally all the logic would be implemented on Business Central as it will be a very heavy lift for Power Automate's feeble math skills.