Skip to main content

Notifications

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

Integration issue while creating job and related Job task lines from power Automate in NAV 17

(0) ShareShare
ReportReport
Posted on by 25

I have created a connection from power apps with Nav 17 and try to create a new  job and related its Job Task lines 

to create a job it's easy to create as shown in the below screenshot 

pastedimage1598615886081v1.png

But to create job task lines relates to this job I  published the Job Task Lines page in the nav 17.

While try to  job task lines for this job I could not find  Job No. field in Power automate  to relate it with the job created earlier

pastedimage1598616760967v2.png 

please suggest some solution.

  • Suggested answer
    JAngle Profile Picture
    JAngle 33,159 on at
    RE: Integration issue while creating job and related Job task lines from power Automate in NAV 17

    The NAV connector is currently limited. You may seen this message when you chose it:

    pastedimage1598617653907v1.png

    Basically this means it is not tracking events taking place i.e. when you create a job it won't let you use Power Automate to retrieve data about that job after you created it (which is an event). This is a big limiter when trying to do this type of process flow. I have found using the HTTP connector more effective as you can switch from POST, GET, PATCH and DELETE easily. In your scenario I would use the web services end point to GET the job for parameters you have passed in during the first call to NAV. For example the date, customer etc. This will then give you a pay load response with the "Job No.". You can use the Parse JSON feature to then add that to the second call to the NAV connector for creating the line information. Have a look at this blog post which shows how to do some of the mentioned steps: https://d365bcangle.wordpress.com/2020/07/22/power-automate-purchase-order-alerts-to-vendor/ it isn't your scenario but it has some of the things you need to resolve the task at hand.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans