Unanswered

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

(0) Share

Report

Posted on 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:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

lbendlin 8,619 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
ME-06011006-0 4 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No