cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
muralikrishna12
Helper IV
Helper IV

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 ACCEPTED SOLUTION

Accepted Solutions
v-jefferni
Community Support
Community Support

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.

View solution in original post

1 REPLY 1
v-jefferni
Community Support
Community Support

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.

View solution in original post

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

Users online (55,073)