Answered

Link to SharePoint List item not working in Approval flow

(0) Share

Report

Posted on by Community Power Pla...

I am building an approval workflow for approving new items added to SharePoint list. In the "Start an Approval" action, I want the email that gets sent to the approver to include a link to the item in the SharePoint list.

There is a field in the action labeled "Item Link" along with "Item Link Description." I have the "Item Link" populated with the SharePoint list item ID, and the "Item Link Description" field with some text and then a field from the SharePoint list.

Here's a screenshot:

Flow approval.JPG

However, when I run the flow, the "Item link" doesn't work. It goes to this following URL: "https://0.0.0.40/" instead of to the SharePoint list item.

Here's a screenshot of the approval request:

The text of the link is correct, but the URL (https://0.0.0.40/) isn't. Any idea what I missing?

All responses (14)

Answers (1)

Mark_B 4 on at

Like (0)

Report

Re: Link to SharePoint List item not working in Approval flow

In the Link field state the full URL for the SharePoint folder that contains the document, for example;

https://mysharepointsite.com/sites/sitename/Shared Documents/General/foldername/

Then add the SharePoint File name field.
m4ngo5 90 on at

Like (0)

Report

Re: Link to SharePoint List item not working in Approval flow

Thanks wasabruin! Glad you got it working!
wasabruin 13 on at

Like (0)

Report

Re: Link to SharePoint List item not working in Approval flow

Stuart - you're a GENIUS!

That worked!

Thank you for sticking this out with me! So, just to recap for future "newbies" - in order to get the Document ID to work, you will need to use the "Properties only" trigger. Here's what my Flow looks like now:
m4ngo5 90 on at

Like (1)

Report

Re: Link to SharePoint List item not working in Approval flow

Wasabruin,

Change your trigger from "When a file is created or modified in a folder" to "When a file is created or modified (properties only)". Using this trigger, you will still have the option to specify a folder if necessary, and it will provide you with the Document ID/Document ID Value you're looking for.

-Stuart
wasabruin 13 on at

Like (0)

Report

Re: Link to SharePoint List item not working in Approval flow

Hi Stuart,

Thanks for the quick reply. Unfortunately, perhaps I'm doing something wrong, but I do not see a choice to use "Document ID Value" - these are the choices I get as I'm using Office 365 Sharpoint:

So, I've been choosing "File identifier", but that doesn't work.

Thanks!
m4ngo5 90 on at

Like (0)

Report

Re: Link to SharePoint List item not working in Approval flow

Hi wasabruin,

Thanks for the screenshots. Instead of using "File identifier", you want to use "Document ID Value".

Better yet, you could erase everything that is in the "Item link" box and just use "Document ID", because that is a link to the document. (It will create the redirect string for you and put the Document ID Value in there too!)

-Stuart
wasabruin 13 on at

Like (0)

Report
Re: Link to SharePoint List item not working in Approval flow

Hello,

Thank you for your assistance. Here is some more information related to the issue:

When I use the following Flow setup:
I get the following error message:
The FileID that Flow seems to be reporting is:
%252fShared%2bDocuments%252fFor%2bReview%252fMLR%2bReview%2bForm-RevA.pdf
The actual File ID when I look at the "Details" for the file is: AMMLR-785860148-20

Any help with this frustrating problem would be appreciated!

Thanks!
m4ngo5 90 on at

Like (0)

Report

Re: Link to SharePoint List item not working in Approval flow

wasabruin,

Can you screenshot the part of your flow with the URL and the ID? It would be helpful to see.

The ID variable should not be outputting a URL string like that, but I have a theory. When you activate Document ID, SharePoint schedules this task. If the process is not yet complete, it might be outputting that string instead.

See here for more information on Document ID activation: https://support.office.com/en-us/article/Activate-and-configure-Document-IDs-in-a-site-collection-66345c77-f079-4104-ac7a-e25826849306
wasabruin 13 on at

Like (0)

Report

Re: Link to SharePoint List item not working in Approval flow

I was able to find and resolve the activation of the Document IDs service. It is under the Site Contents > Site Settings > Site Collection Administration.

However, after fixing that, I received the following error:
wasabruin 13 on at

Like (0)

Report

Re: Link to SharePoint List item not working in Approval flow

Hi Stuart,

I tried what you suggested and I received the following error message:

Any ideas?

Thank you for your help!