cancel
Showing results for 
Search instead for 
Did you mean: 

Save attachments to SharePoint list item

Hello,

 

My main blocking point right now, is that I can not attach files to SharePoint list via PoweApps edit forms.

I can create app which can manage orders in SharePoint list for my company in few seconds, but we are forced to keep original email request in list. For this we are using InfoPath which works fine, but PowerApps should be much more suitable solution.

 

Also we are using same procedure but with excel forms, for that is also important to be able to EDIT excel/word... attachment directly on SharePoint. So what I would like to have in DisplayForm/edit form, when I click on excel file attached, it will open my excel, let me edit it and save it back directly to SharePoint like is possible now with forms on SharePoint.

 

Once I will have those 2 things in PowerApps, my live will be much more easier! Smiley Surprised

 

Would like to use PowerApps in our company, but right now... its not possible

Status: Completed

Review details on this feature release in the following blogs and video tutorials:

 

 

 

Thank you,

Audrie

Comments
Level: Powered On
Hi,

What about uploading pen input to sharepoint attachments? Someone said this feature will be available in april. Is there a planned release date?
Level: Powered On

For anyone looking for a cost effective replacement of InfoPath with the ability to attach files to a SharePoint list you should consider Sintel Forms For SharePoint. It's completely free for up to 2 forms. Additionally certain file types that are attached to Sintel Forms can be previewed directly within the form see Adding Attachments & Image Previews.

 

Eoin McMahon - Sintel

Level: Powered On

Hi,

Is there any update on being able to patch attachments outside of a form? Its seriously affecting our flexibility of the product at the moment. An estimated time was around April.

 

Thanks.

Power Apps Staff

Unfortunately we have still not been able to enable using Attachments outside of the form with high quality and performance.  This feature is still on our roadmap, but it won't be coming out in the next 3 months. 


Appologies for the inconvenience.  Are you able to use the Attachments by placing them in a form (perhaps by itself) and having them work from there?

Level: Powered On

Thank you for the reply.

 

I have a question set within a gallery (being pulled from an SP list), the client now wishes to be able to attach files against each question. I have an attachments form at the bottom; is there a way I can reference the question within the gallery in this form, so that as the highlighted question is answered an attachment is available?

Level: Power Up

I am trying to use Attachment control to save the form offline with attachments and then patch it to SharePoint when it goes online.

Current working scenerio only working for online mode. How it can be used if we want it in offline mode as well.

Power Apps Staff

@cgreen1983 this should be possible, I just tried it.  Here is what you need to do:

  1. Create a gallery and connect it to your SharePoint list.
  2. Ensure Gallery.Selectable = true (in Advanced properties of the gallery)
  3. Below the gallery add an Edit Form cand connect it to the same SP list data source
  4. Remove all Form fields and just add the Attachments field to it.
  5. Set Form.Item = Gallery1.Selected (in Advanced properties of the form).
  6. Add a button with label "Save" and set Button.OnSelect = SubmitForm(Form1)

When you save and run this app, attachments will be updated to reflect the item of the gallery that was selected.  You can add and delete attachments, and press the "Save" button to write the changes to SharePoint.

 

Level: Powered On

 Hi @FilipK,

 

Sorry I haven't explained it well enough; I am pulling in a set of questions from a questionset (in an SP list) but am then patching to another SP list (the question set pulls in the question and a couple of other text columns, but the patched list includes comments etc for the question.

 

The above worked really well as a test but is writing to the wrong list; when I write to the new SP list it doesnt work, can you advise?

 

Thank you again.

Power Apps Staff
@cgreen1983 The concept should be the same. The differences are: 1. You configure the gallery and the Form with Attachments to use different data sources. 2. You reference a name (or another field) of the selected record in gallery to Find the appropriate record displayed in Form.Item. You can do something like First(Filter(.... See these docs for more details on how to find your record in a different data source: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-filter-lookup
Level: Powered On

@FilipK thank you, sadly that still does not work. When I keep the form datasource to the original SP list (QuestionSets) it writes perfectly. When I tell the form to write new items to the new SP list (InspectionResults), I still get an error.

 

I can see that the form is looking for the selected item within the gallery; it has accepted the code and adjusts to the selected gallery item when pressed (I get a small "flash" whilst the form goes looking for the item):

Form.Item: First(Filter(QuestionSets,Title=Gallery2.Selected.Title))

 

However after I submit the form, the attachment seems to save, then I can't get it back again. If I go back to the selected record in the gallery it isn't there. Is it because I am writing the SubmitForm for an item that has not yet been created (patched) to the InspectionResults SP list?

 

The point of the app is to go through the gallery of questions, pass/fail each question then add a photo to any failed questions. At the end of the gallery, I have an icon which saves each item in the gallery (plus the attachments) to the InspectionResults SP list:

 

ForAll(Gallery2.AllItems,Patch(InspectionResults,Defaults(InspectionResults),{Title:Title5.Text,Area:Subtitle5.Text,PassOrFail:Subtitle6.Text,FailComments:Subtitle7.Text},Form1.Updates)) 

 

Is there anything else you can suggest, or have I missed something obvious? Thank you again for your help.