cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Need to add Attachment to a PATCH to a SharePoint List

I have created an app where I want to patch an attachment field to a SharePoint List, but the attachments field is not listed as a field in my SharePoint list per powerapps notification. I know I can attach files using the edit form feature, but all of the other fields in my app are not within a form. Help! 🙂

13 REPLIES 13
ericonline
Community Champion
Community Champion

Here's how I got accomplished this after I could not get @v-xida-msft 's method to work.

Scenario:

  • Two forms, one on each of two screens
  • MainForm: All the DataCards except Attachments
  • ImageForm: Single DataCard, only the Attachments DataCard
  • User fills in the MainForm, at any time they can click a Camera Icon which navigates them to the CameraScreen. They can Take/Upload photos using the ImageForm
  • When complete, the Submit button lights up
  • OnSelect of the Submit button:
    • Patch(SharepointList,
        LookUp(SharepointList, eventId = varEventId),
          frmMainForm.Updates,
          frmAttachments.Updates
      )

Hope this helps!

View solution in original post

Varsha2005in
Helper I
Helper I

@ericonlineThe only thing I don't understand is why you are using Lookup, if you can please explain it, that would be great. Thanks!

@Varsha2005in ,

The LookUp function is used to identify a single record in a DataSource. Since I want to add attachments to only a single record, I use LookUp. In some cases, you could also use First(Filter()) to perform the same. 

You need to put whatever text fields/dropdowns/dates etc inside of the patch OBJECT section... then (because Patch() allows for extra parameters) you add another parameter to patch... called Form1.Updates. So that will patch all records you created (your custom form) AND it will grab the "update" info from your form, (where the only field is Attachments) and will include all of that in 1 single patch. 

KyleJ_0-1599657547833.png

 

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,148)