Unanswered

Retrieving an attachment from SharePoint using ID from SQL Server

(0) Share

Report

Posted on by bakgou1

Hello Community,

Is there a way in PowerApps to retrieve attachments from the SharePoint document library using a unique ID in SQL Server.

For example, I have a SQL server table with ID and Title Column. Also, I have a SharePoint Document library with ID and Attachment Column. Can I do a lookup function to retrieve the attachment based on ID?

Thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

timl 36,785 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @bakgou1

I see no reason why you can't use LookUp to attrieve the attachment based on ID.

I'd suggest that you add a form to your screen and add a card with your attachment field.

You would then set the Item property of your form to:

LookUp(YourSharePointList, SharePointIDField = X)

(where X is your SQL ID value)

Was this reply helpful? Yes No
bakgou1 47 on at

Like (0)

Report
Copy link

Link copied!

Ok. I'll try it. Do you know how to Patch attachment to the SharePoint document library without using edit form in PowerApps?
Thank you!

Was this reply helpful? Yes No
timl 36,785 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @bakgou1

You could copy the attachments control from a form, and paste it elsewhere on a screen and use it to retrieve the file that the user attaches.

In general, it would probably be quicker and easier to use a form.

Was this reply helpful? Yes No
bakgou1 47 on at

Like (0)

Report
Copy link

Link copied!

I did paste the attachment outside of the form but how do I Patch it to sharepoint list without using SubmitForm(Form1).
Any clue?

Was this reply helpful? Yes No