Business Central forum

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

(1) Share

Report

Posted on by Community member

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:

Integration to Power BI, Power Apps, Power Automate and Dataverse

All responses (3)

Answers (0)

Tom_ikapa 52 on at

Like (0)

Report

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

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?
Suggested answer

YUN ZHU 69,639 Super User 2024 Season 2 on at

Like (0)

Report

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

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
Suggested answer

YUN ZHU 69,639 Super User 2024 Season 2 on at

Like (0)

Report

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

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