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
Resolver V
Resolver V

Re: how to maintain attachments in powerapps .?

Hi I think I would try this....

 

1) I would display whatever data you want form Sql Server and retrieve the Data Record ID.

2) I would take the image and save it along with the SQL data record ID to SharePoint this can be done with nested forms in a screen.

3) then have another hiden form that will send the SharePoint URL to Sql server on an update to the original record.

 

You could write a bunch of code but this is an easy way out and also is the most efficient way for POWERAPPS to do the task "in my view"

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

Top Solution Authors
Top Kudoed Authors
Users online (5,663)