Forum Discussion
Send a document for review Part 2
Hi Quotidian,
You can add an "Due Date" input to "For selected file" action. See image below.
Use "Due Date" value from the action to populate the "DueBack" column.
The user experience will look like this:
I hope this helps.
Norm
The issue is, our unit manager doesn't want to grant access to the site/library. We're using the Link Sharing feature to send the link out, and the reviewer can open, review and save the document without having to interact with the library at all. So I'm trying to work out how to flag the file as 'review completed' by having some remote action that the reviewer performs updating the file properties. 'Spooky action at a distance'. 
What you are saying makes sense. I'm not sure how, or if, you can trigger a Flow from a link in an email. Need to think about it. Hopefully, someone else can assist in the meantime.
Norm
Norman Young I've posted it to the MS Powerusers forum. A lot of people are dealing with this type of issue. Thanks again for your help, if I solve it I'll post the solution here.
Norman Young Probably right! I thanks again for your guidance I will keep trying.
Hi Quotidian,
I'm not certain ID as "Current Item" is resolving. It's hard to tell at this point. If you have ID stored in a variable that might help but I'm afraid anything I suggest might lead you down the wrong path.
Sorry not much help.
Norm
Norman Young
Don't know how I missed that, but I rectified it and am still having this error. I'm basically trying out different connectors and seeing if any of them work. This is the current configuration:
This is the error:
I have googled the 'branching condition' error but it doesn't cast a lot of light.
OK, the story so far - to recap, select a document from a SharePoint library, then the flow prompts sender to enter the Reviewer Email and Due Date, and sets the document status to Under Review; Approval status is set to No by default.
That all works:.
Then the plan is that the reviewer has the set number of days to review the document and make any changes, THEN clicks Approve. The idea is that this changes the approval status to Approved and the file status to Reviewed, telling the Sender that the review is completed.
This is the part that isn't working:
Following the thread suggested above, I found out about the 'ETag' which apparently is required to track document approvals - that is why I added the step 'get file metadata', before 'Set content approval status'. But now the flow is failing with this error:
StatusFailedErrorAction 'Get_file_metadata' failed.
Oh sure, I could do that. I'm still working on it, I'll let you know.
Hi Quotidian,
By share, I meant an image of the entire Flow. It's hard to help further without seeing the "bigger picture". No worries if that is an issue - I get it.
Norm
>Can you share the Flow?
I hadn't thought of doing that - I think my organisation might not be happy for me to do that, and I'm not inclined to ask, as they're not providing any support for Flow/SharePoint. I'll read through that other post carefully and see if I can resolve it. Thanks.
Hi Quotidian,
I have not seen this message before. Have you seen this post on the PowerUsers forum? It might apply.
Can you share the Flow?
Thanks.
Norm
