Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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,433

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 

  • MahGah Profile Picture
    MahGah 15,433 on at
    RE: Power Automation , Dataverse, Item Journal, Lot , item tracking lines

    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

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 75,802 Super User 2024 Season 2 on at
    RE: Power Automation , Dataverse, Item Journal, Lot , item tracking lines

    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,433 on at
    RE: Power Automation , Dataverse, Item Journal, Lot , item tracking lines

    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 75,802 Super User 2024 Season 2 on at
    RE: Power Automation , Dataverse, Item Journal, Lot , item tracking lines

    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

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,433 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans