We are testing the creation of orders through PowerAutomate for our eprocurement project. So far, I can't find any way to create the order as a journal, instead of a Sales order. As there are cases when those orders need to be checked & modified by someone, we want to prevent them from entering into the system as finalized orders.
We use the order type as "journal" when we manually create orders. But I don't have access to this field when I try to create an order with powerautomate. Is it normal? can I add this field in the entity, or should we use another way to enter these orders as "draft" and finalize them ?
Thanks in advance for any feedback ! :)
Hi, You can't use standard sales order header Data entity (SalesOrderHeaderV2Entity) as there is a range on SalesType field with value 'Sales'. You can duplicate this entity and remove the range in SalesTable datasource, expose SalesType field in the Data Entity fields, change Public collection name of entity and use it in Power Automate.
André Arnaud de Cal...
291,965
Super User 2025 Season 1
Martin Dráb
230,836
Most Valuable Professional
nmaenpaa
101,156