How do I get the URL of a document in a Sharepoint Doc Library?
I've tried https://mything.sharepoint.com/:w:/s/mysite/
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
Solved! Go to Solution.
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
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.
Hi @ScottShearer,
Thank you for the reply. Here is the deep explanation:
Not interested in a 3rd party solution. OneDrive for Business has PDF conversion baked-in and i'd like to leverage it.
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
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>
Can you post a screen shot of your Flow?
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.
Don't mean to be a pain, but can you post the detail of the first 4 steps in your Flow please.
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!
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:
@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.
As another option, I tried the new "Convert to Plain Text" Flow component and it worked as well.
Switched column back to Rich Text, then in Step 2 of the Flow, inserted the converter on that single column:
Thanks again for your assistance!
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
48 | |
17 | |
16 | |
13 | |
13 |
User | Count |
---|---|
79 | |
40 | |
27 | |
22 | |
18 |