Power Platform Community Forum Thread Details

Hi there, this is my first post so please bear with me! I am using SharePoint Libraries, Forms, Word, and Automate.

I have built a Microsoft Form that will be used by trainees to submit a word document that contains the work they have done, along with some metadata, to Library A (Submissions). The next step in the flow creates a word document from a template in Library B (Feedback) where the managers will be able to provide feedback on the submitted work.

I would like to have a clickable link in the Feedback document that takes the manager to the Submission/opens the submission in word.

I currently have 2 site columns set up to try and do this:

Column 1: Hyperlink or Picture - This does not show up in the Quick Part>Document Property list
Column 2: a single line of text (255 char) - This does show up in the Quick Part>Document Property list

Both of these columns are fed "Link to item" in the Update File Properties action in the flow.

Since I can only select the column 2 property, the link is displayed in its entirety and is not clickable in the resulting feedback document.

Ideally, I would be able to use the sharing link that I can retrieve by clicking the "Copy Link" button available in the Show Actions" menu on the Submission document. When you use this, it automatically turns the text into a hyperlink using the File Name for the display text. I've been through the Flow's test output and cannot find this link, or the suffix that would enable me to create the link myself.

EDIT:

~~I also don't think I can set up a hyperlink in the template with the correct display text, and then use the property in the address section.~~

I have been trying to use the hyperlink form field with my document property, which looks like: { HYPERLINK {" [Link to Transcript]"} \* MERGEFORMAT }. This works for the first submission, but in the process, something happens to the template that results in the field losing it's contents, ending up as: {HYPERLINK} for all subsequent submissions. I've tried turning off the "update links on save" option but to no avail.

Am I missing anything/is there a way around this?

Any help would be greatly appreciated!

Categories:

Building flows