web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps how to maintain attach...

Power Apps

Answered

how to maintain attachments in powerapps .?

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hi Mates,

SQL Table

Title	URL
Test1	dfadfdajdfdbdlfbdf12nddfb

Form:

Title: Input Control

Attachment: Attachment control

as per requirement, I need to save attachments in the SharePoint folder. but actually, we have to use SQL table to save form/metadata field values.

Also when users edit the item corresponding attachment has to refer in form.

How do I save/maintain SharePoint only for attachment?

During submitting a new item how to convert base64 formate and update that URL in SQL for corresponding attachment.

Please assist me.

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
HI @Anonymous ,

Do you want to save files into Sharepoint library then save the file’s URL into SQL server or Azure?

If you do, you could use Power Automate to achieve the goal. Please refer to the video below:
https://www.youtube.com/watch?v=3QaiM8SeWfM

Summary steps:
Use Attachments control to upload files.
Create a Flow to save files to SP library and get URL of the file
Save the URL into a variable.
Save file name and URL to SQL Server with a Patch() function like:

Patch(SQL_name,Defaults(SQL_name),{Title:First(AttachmentControl.Attachments).Name,URL: varURL})

Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No

Join the conversation