Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

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

Like (0) ShareShare
ReportReport
Posted on 14 Jan 2025 14:50:33 by 4
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.
 
  • ME-06011006-0 Profile Picture
    ME-06011006-0 4 on 15 Jan 2025 at 07:11:54
    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 Profile Picture
    lbendlin 7,572 on 14 Jan 2025 at 23:57:07
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

End of Year Newsletter…

End of Year Community Newsletter…

Tuesday Tip #12 Start your Super User…

Welcome to a brand new series, Tuesday Tips…

Tuesday Tip #11 New Opportunities…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 144,609

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,420

Leaderboard
Loading complete