Small and medium business | Business Central, N...

Power automate to copy lines from Sales order to Purchase order?

(1) Share

Report

Posted on by TT-27040902-0

Hello, I want to have a button to copy lines from a sales order to a pruchase order - items and qty.

I'm a complete noob on power automate, and tried this:

I think this is the wrong way, as here I'm trying to create a new PO based on the order - and it goes bad because there's nowhere to get the vendor ID from.

Does anyone have any tips on how to do this? I'm OK with creating the PO on the vendor first, and then populating lines from a sales order, as long as I can pick it?

Categories:

Dynamics 365 Business Central

All responses (3)

Answers (0)

Sort by

Suggested answer

YUN ZHU 103,829 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

I think this may require a custom API if the vendor is not fixed each time, since as you mentioned, there is no Vendor ID in the standard SalesOrder API.

PS: Can we extend standard APIs?: https://yzhums.com/20960/

In addition, since the Sales Order Line may be more than one line, you need to add an Apply to each step.

This is an interesting topic, I will test it in detail when I have time.

Hope this can give you some hints.

Thanks

ZHU
Suggested answer

YUN ZHU 103,829 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi, I did a simple test today and hope it can give you some tips.

Dynamics 365 Business Central: How to create Purchase Order from Sales Order with Power Automate (Copy lines from SO to PO)

https://yzhums.com/47471/

Thanks

ZHU
Tom_ikapa 56 on at

Like (0)

Report
Copy link

Link copied!

hi.

I am curious as to why you want to do this via Power Automate when there is built in functionality within Business Central on the sales order page?