cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

how to maintain attachments in powerapps .?

Hi Mates,

SQL Table

TitleURL
Test1dfadfdajdfdbdlfbdf12nddfb

 

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. 

1 REPLY 1
Highlighted
Microsoft
Microsoft

Re: how to maintain attachments in powerapps .?

HI @muralikrishna12 ,

 

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:

  1. Use Attachments control to upload files.
  2. Create a Flow to save files to SP library and get URL of the file
  3. Save the URL into a variable.
  4. 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.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Users online (7,258)