PowerApps Save Data - Patch, Collect, and ForAll 

Timely video...just the last step I need, in a complex app I have been working on! Ahhh, the clarity of knowledge. Thank you Shane for lifting the veil for me.

Best Video of all!... I spent a entire day trying what you've got solve in 5 minutes. Thanks a lot!

Thanks for the huge video library on PowerApps. I keep going back to it when I get stuck on a problem. Your work is extremely valuable!

Watching this now. Halloween 2019!!! Love the energy.

Watching a whole bunch of your videos and they’re really good. As a very experienced developer they’re a little slow, but I think you’ve got the balance perfect for people like me and newbies. Thank you.

You are my hero! "Save - Hard Way" is exactly what I've been looking for to make my complicated, batch upsert work.

Man, your videos have helped me so much in the last month! Thank you so much.

Thank you Shane for your very helpful videos. I learn something new each time I watch one of your videos. Please keep it up.

Extremely happy to have Finally found your "PowerApps Save Data - Patch, Collect, and ForAll" video. Took 4 days to find it however, because it was never matched with my google searches, which included [how to copy a record to another data source], [update a SharePoint list from selected gallery], [copy selected record to a SharePoint list], Etc.

This is the most useful video I found for patching

Appreciate your time and effort for making these amazing videos..

You shared your knowledge and also experiences, thank you much for your kind sharing.

A genuinely really useful video. Brilliant. Got me out of a hole this week. One useful tip to add, when constructing a long patch statement the field name and destination list field name can be cut and pasted from the card's advanced properties.... might want unlocking first though! Thanks Shane, you are well and truly my number 1 place to go for PowerApps info.

HI Shane. One of the best idea to do this genius frame work. Fully understand Patch, Collect and ForAll Functions in the Columns of its functions. You are the best Teacher, Thump UP>>>>

Shane, thank you so much for sharing your knowledge! Helped me a lot!

Hi Shane, One of the best tutorial video for Powerapps

Little whacky but man did this help me with my project. Great work. Straight to the point.

Great video Shane. This is what I’m looking for the app in working on. Just loved it 👍👍👍👍 life saver.

Very well explained and detailed. Helped greatly with my project. Thanks!

OMG a video for exactly what I want to do! Track my halloween candy.. All jokes aside, Great video! I learned powerapps through watching your videos and have started creating some for my Org. Keep up the good work.

I really appreciate your videos I’ve learned a lot from them. Thanks

Great Video! Very thorough and helpful for different scenarios

Thanks Shane, your videos are really helpful!

Awwwww! I love how you said you respond to every comment and that "we are worth it", you're awesome! Thank you! Loving your stuff and am excited to have subscribed! Looking forward to watching more! I'm addicted now

Love your energy Shane!

Love it Shane! haha informative and fun. Good job mate!

Thanks Shane. This video really helped me complete my app.

Thankyou Shane... I am a fresher and new to this field... Your videos really help me a lot.. Thankyou once again

Thanks Shane for this wonderful tutorial.

How to use ForAll and Patch together to update existing record in my data source: ForAll(ChangeAssignmentOrStatus, Patch(MemoEDI, LookUp(MemoEDI, ID=ChangeAssignmentOrStatus.ID, ID), {CurStatus: Dropdown1.SelectedText.Value})) This is not fetching the record. Thank You. Got the answer, I have to use {ID: ID} :) Thanks Shane, I love your way of approach to problems.

Dude you are awesome! Really enjoyed this video. Explained it very well and very charismatic. Thanks.

Great work this was really helpful. I'm considering your online courses after this:)

Thanks Shane!!! You are my savior!!

HI Shane, your learning videos are really helpful

Thanks Shane, You've been great help.

Thanks for sharing this with the community. Power apps brings me bad memories from Infopath, and apparently, it's the same idea to reduce coding but "improved".

Great ! Thanks for your efforts!

This is fantastic video thanks

Shane you´re just great!

Great video, just learning PowerApps. Trying to collect static data from an excel table (model, part type) using drop downs and write the selected items along with other data input by users to a Sharepoint list. Having issues making it work. Probably easier ways to do still learning. Will try something’s I learned here. Thanks for doing these.

nice what I needed - thanks

Great explanation

Hi Shane, Is there a benefit when you save data through a collection how you did in this video compared to using a form and a button with submitform?

Very very very good vdo It effectable, can apply to my work

You rock man! 🤘

Thanks for all the great videos!! A couple of questions. (1) When recording field data (assume no Internet), it appears that I would want to store that data into a collection, then later push to SharePoint. Is there any issue with losing the data in the Collection prior to being able to push it to SharePoint (closing the app, or other action?). (2) If multiple people are using the App, are their Collections separate, or are they creating records in the same Collection? Recent Subscriber... your organization of the information you teach is golden! Mike

Hey Shane! Thanks for all the work you are doing, its helps me alot! I have a question, can i do the "easy way"with a choicefield from my sharepoint list? What should the code be for the "easy way"to patch a choice field?

Excellent

great one

these are still going strong and how timely as well being a Halloween from the future.

You are awesome

Helpful video ! A + + + +

Thanx Bro

Hey Shane, your videos are awesome! Thanks so much!! Just wondering if you have a video showing the patching of 3 pieces of information from a qr barcode scan back to 3 separate columns in sharepoint? It would be super helpful!

t-rex lookin real fly, shane

Thanks Shane, what to do if you want to capture username and date/time from the app and then add it to the SharePoint list once click on submit button (with the other inputs of course)?

Hi Shane, love your videos. I got a sharepoint list with data and a similar sharepoint list with "requests"... that are based on the first list. Some request are new orders, some are changes to existing orders and some are deletions of existing orders. I'm curious, is it possible to use the patch function to update the first list with the second list. Would you need to create one collection of each type of request (new, update, delete) from list two, before you update list 1? Or would a For all function be better in some cases? Would love a video on that! :-)

When you did the dropdown in powerapps for the candy to go into the sharepoint list did you make it a "single line text" or "choice" with drop down column in the sharepoint list?

Thank you for your great videos! Question: I am working on an app that puts data that is input by the user through a couple of cascading dropdowns and text input boxes into a collection (this part of the app is working perfectly). I would then like to use some of that data in a new screen but also save all the data in a SharePoint list. Is it possible to save the data directly to the SharePoint list or must you add it to a collection first and then save to a SharePoint list (I am a bit confused about this). What are the pros/cons of either scenario? Thank you so much for your time!

Hi Shane, really helpful video thank you. I have two questions one is probably very basic. 1) is each collection unique to that user for example is my collection different to my colleagues when using the app, or do all users submit data to one collection? Seems obvious but it's not a query I can find an answer for! 2) about performance. When I do the first method you suggest of downloading the collection to my datasource (headers all the same as my datasource) it is taking a few minutes. This is only with a collection of 5 or 6 records. This isn't obviously acceptable for our users (main reason I chose collect over submitform was because each form was taking 5 seconds to submit & the user needs to easily see their entries (likely 5 each)). To combat this, I was thinking of bulk updating the app collection on a schedule to my data source (if all users submit to one collection) to avoid users experiencing any lags. But I don't believe this can be automated and would rely on me to undertake this task which is not not a great solution if I go on long term sick for example. Any suggestions? I have to use Excel and Box, as our ICT policy is not allowed to use SharePoint or OneDrive.

Is there a best choice for speed (e.g. when writing multiple records to excel)? Or do all functions need the same time per record to be stored?

Loving your work! What do you need to do if there are spaces in between your cols in the sharepoint list?

Shane, your videos are amazing for a beginner like me... I'm stuck on a for all patch. I have a collection that gets created with the ID of the selected item in a gallery in one column, and a status from a combo box in another. What I'm trying to do is forall patch, but I can't workout how to use the ID in the collection (from the gallery selected item) and get the patch to identify the sharepoint record to update. Any help would be greatly appreciated.

Shane, great video! One question when saving the "easy" way, what is the field in the powerapp that must match the data base column so you don't have error writing to the SharePoint list? Is it the DataCard itself or the DataCardValue or is it something else?. I'm having some issues, and I think it has to do with how I named my columns in the Sharepoint List, They have spaces and special Characters. Thanks Again!

Hi Shane, thank you for taking the time to create these videos, they have been a tremendous help. I have built this flow and even modified the OnSelect option to work with a collection. The problem I am running in to is I need the Create File action to also create a new folder and name it using user input in the form. The collection would then be saved in the newly created folder. Any help is greatly appreciated. Thanks!!

FYI, You cannot reset controls that are within a Gallery or Edit form control from outside those controls. You can reset controls from formulas on controls within the same gallery or form.

Thanks! One other question. Do you have a video on duplicating rows in a sharepoint table? User collects feedback, similar to another piece, instead of writing it up, duplicate and select a new feedback source being the example

Thank so much, Shane, Is it possible to save to the sharepoint list, without changing the screen?

Thank you for this video. If we are using the ForAll and want to update two SharePoint lists with the information in the collection say Title and Qty on one list and rating and another column on the second list. What would function look like for that?

Hi Shane Thanks for the Session ... Can we patch camera pictures in the attachement coloum in sharepoin list with the other datas..?

He Shane the way you teach is really awesome. I learned a lot of things from you in power apps. Can you please make video on creating the custom component (Callout in SharePoint) like callouts in sharepoint and the input to the custom component should be and html string so that I can have formattings like text bold and color those should be visible in callout

Hi Shane, Your videos are Awesome!! Can you please show how can we patch Lookup column data into CDS Entities

Hi Shane, Thanks a lot for your great videos! On my editform, I have a dropdown (combo box) connected to a Sharepoint list with a choice column. This list provides the list of products I want to use. What I need to do is to then patch selected items from this drop down to a field (column) in CDS. I keep getting errors with any formula I try for patch. Is there any specific formula/combination I need to use?

Hi Shane, thanks for the video. I am having trouble to save data from a collection to business central using a custom connector. the custom connector works fine when I test it (at the custom connectors section) and the Get function also works fine in the power app (you have to do some little tricks to make it work). I tried to use the following formula: Collect (businesscentralconnector_1.Post("'CRONUS NL'") ; NewItem). NewItem is a collection where I save my article data (just one record). businesscentralconnector_1.Post("'CRONUS NL'") is the custom connector with the post action. I want to save this NewItem collection to Business Central, so a new Item will be created in Business central. thanks in advance for helping me

Hi Shane, On the formula for Save - Hard Way, where would you the Lookup function to ensure the collection updates and existing item?

how to use incremental date in the forall loop? (like to patch just the date based on the number of days input), your help is much appreciated.

Hi Shane! Thank you so much for taking the time to make these videos. Quick question - my app is using a gallery...after I save responses in a gallery to a collection (before saving to the Share Point list), how can I reset the gallery so that I can start fresh without seeing the previous responses in the gallery?

Shane your stuff is great and has taught me a ton. I've been searching your videos for the scenario of patching two related(parent/child) data sources at the same time but I haven't been able to find if you have done that. I'm having trouble with creating a new record in the parent while simultaneously adding related records to the child list. Using your varNewRecord method I don't have access to the ID field of the parent so I'm struggling with how to manage the child. Is this worthy of one of your Thursday quick tips? Thanks in advance.

I have a SharePoint list that is set up to receive the information from a collection but when I start the Patch( it only shows the list in single quotes. I've tried with other SharePoint lists and they look like the Easy Way - I will take ANY way at this point to somehow get rid of the single quotes. I learn new things every time I watch a video and built up skills all from your videos~!

Hi Shane, Thank you so much for all the videos. I have a question regarding saving data the easy way. Does same name collection/data source, one fell swoop save, only work if entering data into a gallery?

Can you please video for creating Menu and when select one item from Menu should go to different screen

How I can use the collect function with a form if I want to save form multiple times and then add all at my SharePoint list? Thanks for your help you are amazing

This was a pretty "neigh", sorry, neat video. Thank you, Shane!

Hi Shane, Really appreciate you vids! Is there a way to patch a collection with all the collected results being concatenated into one column to sharepoint?

Excellent video Shane!!! Just one question. How do I delete a specific record in a SharePoint list?

Thanks so much for making this/all your videos Shane! I follow exactly what you're trying to teach in this video, however I'm running into issues with attempts to save to SharePoint with Collect AND ForAll/Patch even when following your code exactly! Any chance the functions have changed since last year? Really pulling my hair out on this one.

Hi Shane. Great video as well as all others. Thanks a lot. In your video you describe how to upload new records from collection to data source. What about updating records in bulk mode? In my App I collected all records from an Entity (CDS) to a collection and added some functionality to update values in the collection or add new items into collection. And then I would like to upload all my changes to datasource. Can I use “Easy way” to upload changes or I have to use “Hard way” only. What if my collection contains new items and updated ones? Should I process these items one by one and check if this is a new one or just updated. Thank you in advance.

Hey Shane, I am in Sydney Australia, a big fan of yours since years. I even got to meet you in one of the Microsoft conferences in Sydney years ago. Anyways, great video as always. A quick question please - with the easy way of saving the whole collection to your data source (e.g. SharePoint), how do you deal with when you have a choice column in SP list, while in your collection you have captured that data as text with a textinput or a dropdown? Thanks bunch.

Hi Shane, Thanks for your videos are awesome!! , but i think you can help me, with a demonstration how can save data like Master-Detail in Sharepoint list with Powerapps or by Collections

Question for you... I have a form that is from a sharepoint list, can I have the edit function write a new line in the sharepoint list vs editing the same line?

Thank you so much Shane, i really need your 911. I have question, as a beginner : If the user always need to complete the 80% of the form at screen A, save it, and later open it and proceed to fill up another 20% of the form at screen B then only submit, may i know in this case should i use Collection or Set? I want to also insert a preview page of the 80% completed form (view mode, with button to choose save or go right to screen B to complete), how to make that preview page that display the data just put in?

Very nice video! I still have one big question: Does ClearCollect also work the other way around? I want to replace my data source with my collection and it doesn’t work (same columns) 😭

Hey Shane, Is it possible to save all the elements of the collection, provided that each element of the collection contains a collection of photos?I can't do this (

In customizing forms cant I use patch function to update records ?? in app it is working properly

How would I have used this same concept for the collection to patch existing sharepoint list entries instead of making new ones? Like if I wanted it to compare collection to sharepoint list, and ForAll where SerialNumber = collection entry, patch these columns. Struggling to find and answer unfortunately.

Great video. Has anyone had issues submitting or patching from data from the PowerApp Mobile App? My applications work just fine from within PowerApps, but when I use the mobile app, the only data that writes to my data source are values called from a gallery selection. All other data (combobox, dropdown and textinput) do not get written.

As always very amazing and useful videos! Can you please tell me, if it is possible to save the record to a new row instead of updating the same row in excel ? When i click on the copy icon on my detailform1, it will take me to EditForm1 with my textboxes and dropdowns auto-populated which were present in my detailform1. I will update just one dropdown and click on the check icon and this will be saved as a new row in my excel sheet. Currently, the DetailForm1 has edit (pencil) button which updates the existing row in my excel. I want to be able to update the existing row and also save as a new row if i update just one textbox. Thanks and regards!

By using Patch function whether it could be possible to save a data in sharepoint list without making a new column...?

Hi Shane, Thank you very much for your Vedios.. I have a question for you..Can you write back content from Poweapps into SAP HANA database? Please tell me..

Hi Shane. I think I can use this video to improve my request form but quick question, does the patch function work with multiple choices selection? I built a sharepoint list and I have a question where the requestor can select several options, if this is possible with the patch function, how will the "code" be?