How to do it...

To configure Microsoft Flow, follow these steps:

  1. In a web browser, navigate to https://flow.microsoft.com.  
  2. Sign in using your organizational account.
  3. Expand Data on the left, and select Connections.
  4. Click New Connection.
  5. Click the Search option, and type Service Bus. There will be one result; click the + symbol.
  6. Enter the primary connection string for the Service Bus queue (see the Get the primary connection string for the Service Bus section in the Creating an Azure Service Bus queue recipe).
  7. Press Create.
  8. Refresh the list, and select Edit from the ... button. Set the name to the Service Bus queue name (for reference), and paste in the primary connection string again.
  9. Select My Flows on the left hand list.
  10. Click New | Automated-from blank.
  11. In the Flow name, enter Process BOM Approval.
  12. Enter Service Bus in the Search all triggers text box.
  13. Select Service Bus - When a message is received in a queue (auto complete) - you may have to hover the mouse of the entry in order to see the full name.
  14. Press Create.
  15. For the queue name, press the drop-down list to select the Service Bus connection created earlier.
  16. Click New step.
  17. In the search box, type initialize variable, and then in the Actions list choose Initialize Variable.
  18. Enter BOMApprovalContent as the Name.
  19. Select String as the Type.
  20. Click the Value field, and then click on the option Content on the right-hand list that appears.
  21. In the search box, type Parse JSON, and select this option from the Actions list, shown as follows:

  1. In the Content field, click Add dynamic content and then select the BOMApprovalContent variable.
  2. We now need a schema. Open the business events form in SCM, locate the business event and click Download Schema, and copy the text into the paste buffer.
This is not a JSON schema, but a sample file that has all element defaults set to empty or zero.
  1. Now we have the text of a sample message, click Generate from sample, paste in the text, and press done, the result will be shown as follows:

  1. Click Save on the top right.
  2. Click My Flows on the left-hand list to see the list of flows again. On our flow, select the vertical ... button, and click on Run history.
  3. You should see an instance of the flow that ran, expand the Initialize variable block, and copy the contents of the Value field, this will look like the following:
{"BOMId":"D0001BOM","BOMLines":[{"BOMUnitId":"ea","ItemId":"M0001","Qty":1.0},{"BOMUnitId":"ea","ItemId":"M0002","Qty":1.0},{"BOMUnitId":"ea","ItemId":"M0003","Qty":1.0},{"BOMUnitId":"ea","ItemId":"M0004","Qty":1.0},{"BOMUnitId":"ea","ItemId":"D0002","Qty":1.0}],"BomName":"Mid-Range Speaker","BusinessEventId":"ConPIBOMApprovedBusinessEvent","ControlNumber":5637150576,"EventId":"C0D16056-46B0-4E4C-901B-AA25E84B3695","EventTime":"/Date(1560101558000)/","MajorVersion":0,"MinorVersion":0,"SiteId":"1"}

This was created when we tested the business event, and is a better example to use to generate the schema.

  1. Click Edit on the top right.
  2. On the Parse JSON step, click Generate from sample.
  3. Paste in the value taken from step 27.
  4. You should now see that the BOM Lines section is properly formatted.
  5. Save the flow.