web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Sharepoint - Add link ...
Power Automate
Unanswered

Sharepoint - Add link into list item to file in document library

(0) ShareShare
ReportReport
Posted on by 10

Hello everyone,

this is what I'm trying to achieve, I need some guidance more than a step-by-step guide. Not sure if this approach is the best one.

 

I've a list in SharePoint called "Sales", where requests to enter a new Sales Order into our ERP are added by, guess, the Sales Team and received by our Data Entry Team;

The Title of the list is the Sales Order Number (with format "AB1234"), one of the columns in the list is called "pdf", where I'd like to add the link with the related file after it's been generated;

once the order is entered, a pdf is automatically generated and added into a SharePoint Document Library called "Spool",

and the file name structure would be "Sales Order No_AB-1234_Date 05-05-22.pdf";

at this point I'd like to automate, and add a link to this file into record "AB1234" under column "pdf"

 

if someone could point me to the right direction

 

Thanks

Categories:
I have the same question (0)
  • okeks Profile Picture
    802 Super User 2024 Season 1 on at

    1) Use "When file is created" trigger of the Sharepoint connector on the spool library

    2) Use substring and replace function to get the sales order number from the file name in the correct format.

    3) Use "Get Items" action from the Sharepoint connector with a filter on the Sales Order Number to get the list entry.

    4) Update the lis tentry witht the link to the PDF file.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 241 Super User 2026 Season 1

#2
11manish Profile Picture

11manish 179

#3
Haque Profile Picture

Haque 159

Last 30 days Overall leaderboard