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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Get Purchase Order Lin...
Power Automate
Answered

Get Purchase Order Link (Dynamics 365 Business Central)

(0) ShareShare
ReportReport
Posted on by 19

Hello everyone,

I have a Power Automate Flow that starts when a purchase order approval is requested.

An approval request is sent to the approver, but I can't find a way to get the link to the purchase order, so the approver can review it before taking any decision.

alberosachs_0-1618312008481.png

Any ideas?

 

Thank in advance

 

Categories:
I have the same question (0)
  • Therese Youssef Profile Picture
    Microsoft Employee on at

    Hi,

    Could you please provide more details about your workflow?

    A clear screenshot for the full workflow would be great to understand how your flow works.

    Thanks.

  • alberosachs Profile Picture
    19 on at

    Hello,

     

    this is the general view:

    alberosachs_0-1618480746458.png

     

    This is what's under Condition - Define authorized purchasers:

     

    alberosachs_1-1618481409712.png

    What I'm doing here is defining a list of people authorized to create purchase orders. It the person is not in the list, the purchase is automatically rejected (that's what's under If no).

     

    Under If yes what am doing is:

    Every requester have a specific approver. In the first 4 steps (Condition - If requester is X define varApprover) I check if the default approver is in the office or not (If Out of office  message in Outlook is setup). If the approver has an Out of office message, a substitute approver is defined.

     

    Then come the Get record and Start an approval processes:

    alberosachs_2-1618482058591.png

    An in the end the condition based on the response (Approve/Reject)

    If the approver approves, the order is released, if the approver rejects, the order is cancelled.

    alberosachs_3-1618482284567.png

     

  • Therese Youssef Profile Picture
    Microsoft Employee on at

    Hi,

    Actually at the meantime, you cannot add attachments to an approval email sent by using the "Approval" action.

    You have 2 options so far to make it done:


    1. You can type order number in the item link field.

    Therese-Youssef_0-1618493705631.png

    But in this case, the approver has to open Business Central to check the purchase order.

    2. You can use "Send email with options" action rather than approval. 

    I believe this action allows you to add attachments.

    If this answers your question, please mark your post as Solved.

    Hope the content above may help you.

    Thanks.

  • alberosachs Profile Picture
    19 on at

    Hello,

    I do not want to add attachments, I want to add the URL of the purchase order, so the approver can click on it and go directly to the order to review it.

     

    Thanks

  • Therese Youssef Profile Picture
    Microsoft Employee on at

    Hi,

    It seems that the Business Central Dynamic Contents don't contain the URL option.

    So we have to construct the URL, by splitting out the URL of the purchase order.

     

    I don't have the exact schema for the URL, but let's say that the URL schema is:

    https://businesscentral.dynamics.com/TenantID/CompanyID/OrderID
    The TenantID and the CompanyID are always the same with any order, but the OrderID is the variable one here.

    So we can paste the URL, and replace the OrderID part with the Dynamic Content: "No."
    I think this will do what you want.

    If this answers your question, please mark your post as Solved.

    Hope the content above may help you.

    Thanks.

  • alberosachs Profile Picture
    19 on at

    Hi @Therese-Youssef ,

    that doesnt work either because the URl does not contain the ID

     

    The URL right now is:

    https://businesscentral.dynamics.com/?company&node&page&dc&bookmark

     

    See the image below

     

    alberosachs_0-1618812864537.png

     

    If I could get the Bookmark somehow, it woudnt be a problem, but that is not a variable I can find anywhere.

     

     

     

  • Therese Youssef Profile Picture
    Microsoft Employee on at

    Hi,
    In fact, I don't have access on Business Central.

    So please excuse me as I can't try the flow, see the available Dynamic Contents, or even get the right URL.
    But I am doing my best to help you with that.

    During my search I figured out some points you can try:


    - Try to use "Posting No." dynamic content as Bookmark.
    - Try to add "Parsing JSON" action after "Get Record" action, so this may provide the URL as a dynamic content.

     

    If this answers your question, please mark your post as Solved.

    Hope the content above may help you.

    Thanks.

  • alberosachs Profile Picture
    19 on at

    Hi,

    thanks, but none of those methos work either.

  • Verified answer
    alberosachs Profile Picture
    19 on at

    Ok, it is solved.

    I took the URL: https://businesscentral.dynamics.com/?company&node&page&dc&bookmark

    and replaced with: https://businesscentral.dynamics.com/?company&node&page&dc&id

     

    It looks similar to this this:

     

    businesscentral.dynamics.com/?company=COMPANYNAME&page=50&filter=%27Purchase%20Header%27.%27Document%20Type%27%20IS%20%271%27&dc=0&id=5b9a28a2-7338-ea11-a813-000d3aa96cf5

     

    alberosachs_0-1619174660846.png

    So, even though the ID selector is not in the documentation, it works. It will redirect the URL to the correct bookmark.

     

    Thanks everyone

    I hope this helps someone else

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 Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 557

#2
Valantis Profile Picture

Valantis 328

#3
David_MA Profile Picture

David_MA 264 Super User 2026 Season 1

Last 30 days Overall leaderboard