You’re offline. This is a read only version of the page.
Announcements
Hi, I'm looking into the capabilities of Power Automate.
I work in ecommerce and we are investing a lot of time allocating batch numbers and creating shipments etc for Web orders.
I'm going to do some more delving throughout this week but I was wondering if it was possible to essentially automate the process of creating shipments and invoices, then selecting the lowest Batch code (with available stock) for each product line in an order? I would then ideally like to run this process on multiple orders in groups.
Apologies if I've not made things too clear, I'm very new to the system but have identified this as a big bottleneck for us.
Thanks for all your help!
While I'm not sure that I totally understand the requirement, let me give it a try.
My answer below assumes that you're data is stored in SharePoint which may not be the case. I believe that the same concept that I am presenting below will work with D365.
You can use a Get Items action with an filter query to limit your results to items meeting certain conditions - i.e. Product line. You can also set a sort order - sort by your batch number in a descending order. Then set the top count to 1. So, the Get items action will return an item with the top batch number.
Share
Report
All responses (
Answers (
25,270
