Small and medium business | Business Central, N...

Power Automate flow for insert sales orders and lines

(0) Share

Report

Posted on by Suvarna

I am creating power automate flow. Inserting sql table data into sales order.

I am working filter query on employee id but unable to provide in sql part that's why given conditions. There also I can specify few conditions. How to work with filter query ?

I have developed further flow to insert lines in sales line. This is working fine with single line item.

How to do for multiple sales lines?

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

IB-29041624-0 1,191 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Can you please try to implement the apply for each action on the query result?

The documentation for it is here:

docs.microsoft.com/.../apply-to-each

Was this reply helpful? Yes No
Suvarna on at

Like
a
(0)

Report
Copy link

Link copied!

Can you please guide me by using SQL with trigger , actions, filter. I am trying with reference to your document and somewhere conditions or something going wrong and getting error. Even little bit elaborate about using tables also.

Please help

Was this reply helpful? Yes No