Unanswered

How to get Attachment link from Attachment column?

(1) Share

Report

Posted on by killerBee15

I have a Share point list which has columns like Name, Email Id, Age, Certificate, Attachment. So, when an item is added into the list using Power Apps all the field is filled except "Certificate". Certificate is added in the "Attachment" column. I want to obtain that link and add to the Certificate column. I am aware that the link cannot be added during Form submission. So, after the form is submitted and the item is added, I want this to take place automatically.

I am not sure if I could use power automate to automatically obtain the link and fill in the Certificate column.

Any ideas? Thanks in Advance.

All responses (2)

Answers (0)

ANB 7,075 Super User 2025 Season 1 on at

Like (0)

Report
Re: How to get Attachment link from Attachment column?

Hi @killerBee15 You can try one thing. Once the Form is submitted with attachment, then you have SharePoint ID column and you also know the filename which is attached. So using below you can construct the URL:

https://domainname.sharepoint.com/sites/NameOfSite/Lists/NameOfList/Attachments/ID/FileNameWithExtension

Replace this with your domainname, NameOfSite, NameOfList, ID and FileNameWithExtension.

You can use FormName.LastSubmit to get the ID

Then this URL you can again patch to SP list in the Certificate column.

Patch(SPLIST, Lookup(SPLIST, ID=FOrmName.LastSubmit.ID),{Certificat: URLContructed})

-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

Thanks,
ANB
mmbr1606 12,108 Super User 2025 Season 1 on at

Like (0)

Report

Re: How to get Attachment link from Attachment column?

hey @killerBee15

as you wanna do it after the form submission the easiest way to do it would be in power automate.

but in that case ur topic would be a better fit for the power automate community forum to be found here:

Microsoft Power Automate Community - Power Platform Community

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings