cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
martin_lr
New Member

PDF file approval process finding the temp file, not the actual file.

I am trying to create a workflow that goes as follows:

1) User fills out a Microsoft Form, and uploads a pdf file to SharePoint
2) Flow automatically starts, finds the file and sends it to approvers to get it approved.

 

The problem I am facing is when the PDF file is uploaded, the Form starts and finds the temporary file of the PDF, and not the actual PDF (I imagine the temp file is made while the pdf is being uploaded). Obviously this doesn't work, as a temp file the no longer exists gets send to approvers.

 

Is there any way to fix this?

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @martin_lr 

 

After the delay action filter the file using Get Items filtered by filename. Here I have hardcoded mnu.jpg which is my filename. Replace the filename accordingly.

 

See below.

 

image.png



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

View solution in original post

9 REPLIES 9
abm
Super User III
Super User III

Hi @martin_lr 

 

You cannot attach items in approve emails. Please see below post.

 

https://powerusers.microsoft.com/t5/Using-Flows/Is-is-possible-attach-a-file-in-a-approval-email/td-...

 

Thanks

 

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

I am not trying to attach the file to the approval email.
The PDF  file is uploaded to Sharepoint.

All I want the approval email to do is hyperlink to the pdf file on sharepoint.
Right now it hyperlinks to the temp file

abm
Super User III
Super User III

Hi @martin_lr 

 

Thanks for your quick reply. This could be timing and refresh metadata behind the scene. Could try to add a delay after uploading the document? If not another option is create a new flow when a file is uploaded?

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

I've tried using "when file is created" and "when new form response is submitted" and they both do the same behaviour.

Is there a way to add a timer/delay?

abm
Super User III
Super User III

Hi @martin_lr 

 

Try this

 

image.png



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

Ive tried using delays

What the process is now:

 

1) trigger the flow to start when a new form is submitted

2) wait 30 seconds
3) find the most recent file uploaded to sharepoint and send that (link) to the approvers

 

However this is not a great solution as if multiple files were uploaded at the same time, the wrong file could be sent out.

 

is there a better way of linking the uploaded file with the delay?

Hi @martin_lr,

 

After the delay action, you could use the Get item action to get the last version of the file just uploaded, instead of getting the most recent file uploaded.

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @martin_lr 

 

After the delay action filter the file using Get Items filtered by filename. Here I have hardcoded mnu.jpg which is my filename. Replace the filename accordingly.

 

See below.

 

image.png



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

View solution in original post

Hi @martin_lr,

 

Has your problem been solved?
If your problem has been solved, You could go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

Best Regards,
Community Support Team _ Lin Tu

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Users online (11,567)