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! 🙂
Solved! Go to Solution.
Here's how I got accomplished this after I could not get @v-xida-msft 's method to work.
Patch(SharepointList, LookUp(SharepointList, eventId = varEventId), frmMainForm.Updates, frmAttachments.Updates
Hope this helps!
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.
I did not know you could access all of a form Updates in a patch call. This saved my bacon working with item level permissions, Thank you @ericonline
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Learn from the top Power BI, Power Apps, Power Automate & Power Virtual Agents experts!