Get Purchase Order Link (Dynamics 365 Business Central)

[alberosachs]

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.

Any ideas?

Thank in advance

[Therese-Youssef]

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]

Hello,

this is the general view:

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

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:

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.

[Therese-Youssef]

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.

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]

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]

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]

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

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

[Therese-Youssef]

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]

Hi,

thanks, but none of those methos work either.

[alberosachs · Accepted solution]

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

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