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)

Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (0)

Report

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 (0)

Report

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

Join the conversation

Community site session details

Power Automate flow for insert sales orders and lines

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates

Community site session details

Power Automate flow for insert sales orders and lines

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates