Get a file FROM Sharepoint Doc Library TO OneDrive for Business

(0) Share

Report

Posted on by seadude

1,855

How do I get the URL of a document in a Sharepoint Doc Library?

I've tried https://mything.sharepoint.com/:w:/s/mysite/

ID
Identifier
FolderPath
Path
Filename With Extension
etc, etc, etc

Where is the "doc url" parameter!?!?!

An example url is: https://mything.sharepoint.com/:w:/s/mysite/EVyZUHK8hk1FhL0segS-fqABmyOEH8jn2PfmSzrKzMRZDA?e=oXg3XZ

How is the long string on the end referenced?

Thanks

Categories:

General topics

I have the same question (0)

All responses (11)

Answers (1)

ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

Can you explain a little more about what you are trying to accomplish? I ask because you likely don't need to reference the URL in order to copy a file from OneDrive for Business to SharePoint. The OneDrive connection that you use determines the URL.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Hi @ScottShearer,

Thank you for the reply. Here is the deep explanation:

Sharepoint:
When an item is created
Get file content
Create file
Update file properties
OneDrive for Business
Want to take the Word from the Sharepoint doc repo
Convert it to PDF
Write the file back to the Sharepoint doc repo
Not interested in a 3rd party solution. OneDrive for Business has PDF conversion baked-in and i'd like to leverage it.

Was this reply helpful? Yes No
Verified answer

ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

Try this:

This Flow ran successfully for me. One enhancement is that if you are saving the PDF back to the same document library, you want to add a condition (not a pdf file) so the Flow doesn't run a second time.

Please let me know if this solves your issue.

Scott

Was this reply helpful? Yes No
seadude 1,855 on at

Like (0)

Report
Nice work @ScottShearer! That was what I needed!

There is one little item... when I create a new record in the Sharepoint list using a form, the text is created as HTML. Any idea how to pull plaintext instead of HTML?

Here is what I end up with in my PDF where all I typed in the Sharepoint form was "test test test":

<div class="ExternalClass1A514AEE288F4C3B924055541FE3993D"><p>test test test <span id="ms-rterangecursor-start"></span> <span id="ms-rterangecursor-end"></span> <br> </p> </div>

Was this reply helpful? Yes No
ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

Can you post a screen shot of your Flow?

Was this reply helpful? Yes No
seadude 1,855 on at

Like (0)

Report

When I open the Sharepoint list and click "+ New" to create a record and test, I just fill in the blanks as such:

Above is my flow doing some super cool things..

And the output is HTML for the "Issue" field. I want it to be (of course) plain text.

Was this reply helpful? Yes No
ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

Don't mean to be a pain, but can you post the detail of the first 4 steps in your Flow please.

Was this reply helpful? Yes No
seadude 1,855 on at

Like (0)

Report

Thats kind of secret sauce at the moment. I want to get a video out on some cool functionality before I expose that too much. sorry to be a wet blanket!

Was this reply helpful? Yes No
seadude 1,855 on at

Like (0)

Report

Wow... I feel like a jerk! My apologies to you @ScottShearer. Here you are sharing with me and I'm attempting to be veiled. Sorry man, corporate culture wearing off on me.

Here is a screenshot of the first 4 steps of the flow:

Was this reply helpful? Yes No
seadude 1,855 on at

Like (0)

Report

@ScottShearer, I figured out what the problem was!

I had to edit the column settings for the cell coming across as HTML. Had to uncheck the "Use enhanced rich text..."

Works like a charm now.

Was this reply helpful? Yes No