web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Power Automation , Dat...
Small and medium business | Business Central, N...
Suggested Answer

Power Automation , Dataverse, Item Journal, Lot , item tracking lines

(0) ShareShare
ReportReport
Posted on by MahGah 15,581

Hi 

I wonder if possible to utilize Power Automation to write back into "Item Journal" than write the lot back to "Item Tracking Lines". Let say to create Power app to cycle count. Then app write counted item and QTY into Item Journal and for each line add the "lot" into related "Item Tracking Lines" of Item journal? 

I mean my struggle is with "Item Tracking Lines" it is a temporary table and I do not know how write back to it from Power App. 

JAngle  Brad_P TeddyH yzhums NorthW S.Kawamura  any help will be greatly appreciate it. 

Thanks 

I have the same question (0)
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 98,062 Super User 2026 Season 1 on at

    Hi, The handling of "Item Tracking Lines" has been very troublesome. Although I haven't tried it, maybe you can combine the two methods below to handle this automatically in Power Apps.

    How to create Item Tracking Lines automatically during an inbound transaction (Customization)

    https://yzhums.com/7943/

    How to run AL procedure in Power Automate (Add custom execute actions)

    https://yzhums.com/20111/

    PS:

    5265.ms_2D00_dynamics_2D00_nav_2D00_2013_2D00_item_2D00_tracking_2D00_wp_2D00_ap.pdf

    Hope this can give you some hints.

    Thanks.

    ZHU

  • MahGah Profile Picture
    MahGah 15,581 on at

    Hi Mr Zhu  yzhums

    As always really helpful. I wonder if it is possible to call "Codeunit 99000830 " from Power Automation. or should we create page in BC using AL than load that page in BC from Power Automation than use Codeunit 99000830 ?

    Looks like a lot of challenge here. Have you tried such an action?

    Thanks

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 98,062 Super User 2026 Season 1 on at

    Hi, I checked this codeunit and it doesn't set [ServiceEnabled] attribute.

    https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/attributes/devenv-serviceenabled-attribute

    As far as I know, Power Automate can't read it directly, maybe it can be in Web Service, sorry I haven't tested it in detail.

    pastedimage1669248437373v1.png

  • MahGah Profile Picture
    MahGah 15,581 on at

    Thanks yzhums

    so far any method I tried it failed me. Looks like that reservation table it is not easy to deal with.

    Do you know if it is possible to create page than API (like your example) then have a AL code in action in page that can be triggered from Power Automation. I mean do you think below works at all?

    Have page to write all Lot in it, then have an action in page to trigger that codeunit to write in reservation table

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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the January Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,032 Super User 2026 Season 1

#2
Dhiren Nagar Profile Picture

Dhiren Nagar 1,049 Super User 2026 Season 1

#3
YUN ZHU Profile Picture

YUN ZHU 1,029 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans