Create a sales order based on an incoming mail attachment

Scenario:

• Received a new incoming mail.
• The condition prevails as the Subject contains Power Automate.

If the above condition is satisfied, the received attachment is saved in a folder.

When you select the Connector BC (On-Premises), and the BC table is not found, use ODATA Webservice.

1. In the Company name field, select My Company

2. In the API category field, select v2.0 from the drop-down list.

3. In the Table name field, select sales order from the drop-down list.

4. In the Customer Name field, enter the desired number.

5. On the Table name field, select sales order lines from the drop-down list.

6. In the Line Type field, select Item.

7. In the Quantity field, select the desired quantity.

   

   

To Test the Flow, use your own online environment:

1. On the action bar, click Test to check if the created Flow runs without errors.
2. On Test Flow, select Manually to send an email to your inbox. This will trigger the flow and allow you to test it.
3. Check if a new sales order has been created.
4. On the action bar, select Turn on if all the tests are successful.