Search code examples
dynamics-crmmicrosoft-dynamicspower-automate

How to get specific data from Order Product list in Flow?

Im trying to create an automated word document using flow.

I need the customers address, what inverter they have on our order product list and some info from that inverter. However I can't figure out how to get the inverter's information.

Please see attached screenshots for information.

Cheers, Chris

Flow

Solution

  • Used an ODATA filter query to filter the products correctly on Orders.

    salesorderid_value eq (Dynamic Content of Order GUID from Trigger)

    List all the order products related to the order from the trigger.