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

All responses (11)

Answers (1)

Sort by

ScottShearer 25,331 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
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.
Verified answer

ScottShearer 25,331 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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
seadude 1,855 on at

Like
a
(0)

Report
Copy link

Link copied!
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>
ScottShearer 25,331 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Can you post a screen shot of your Flow?
seadude 1,855 on at

Like
a
(0)

Report
Copy link

Link copied!

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.
ScottShearer 25,331 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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

Like
a
(0)

Report
Copy link

Link copied!

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!
seadude 1,855 on at

Like
a
(0)

Report
Copy link

Link copied!

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:
seadude 1,855 on at

Like
a
(0)

Report
Copy link

Link copied!

@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.