Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
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
    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
    7,765 Super User 2025 Season 1 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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,513 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,688 Most Valuable Professional

Leaderboard
Loading started