Get Purchase Order Link (Dynamics 365 Business Central)

Like (0) Share

Report

Posted on 13 Apr 2021 11:08:23 by 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

Categories:

Business Process Flows

All responses (9)

Answers (1)

Verified answer

alberosachs 19 on 23 Apr 2021 at 10:46:03

Like (0)

Report

Re: Get Purchase Order Link (Dynamics 365 Business Central)

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
alberosachs 19 on 23 Apr 2021 at 10:28:19

Like (0)

Report

Re: Get Purchase Order Link (Dynamics 365 Business Central)

Hi,
thanks, but none of those methos work either.
Therese Youssef Microsoft Employee on 19 Apr 2021 at 13:03:07

Like (0)

Report

Re: Get Purchase Order Link (Dynamics 365 Business Central)

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 19 on 19 Apr 2021 at 06:16:59

Like (0)

Report

Re: Get Purchase Order Link (Dynamics 365 Business Central)

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 Microsoft Employee on 18 Apr 2021 at 11:10:50

Like (0)

Report

Re: Get Purchase Order Link (Dynamics 365 Business Central)

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 19 on 15 Apr 2021 at 15:56:41

Like (0)

Report

Re: Get Purchase Order Link (Dynamics 365 Business Central)

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 Microsoft Employee on 15 Apr 2021 at 13:42:34

Like (0)

Report

Re: Get Purchase Order Link (Dynamics 365 Business Central)

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 19 on 15 Apr 2021 at 10:24:53

Like (0)

Report

Re: Get Purchase Order Link (Dynamics 365 Business Central)

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 Microsoft Employee on 14 Apr 2021 at 10:08:30

Like (0)

Report

Re: Get Purchase Order Link (Dynamics 365 Business Central)

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.