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!

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!

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

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.

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

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

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

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.

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

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

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

Thanks Shane, your videos are really helpful!

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

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.

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

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.

This is the most useful video I found for patching

Great Video! Very thorough and helpful for different scenarios

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

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

Thanks Shane for this wonderful tutorial.

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

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

Hi Shane, One of the best tutorial video for Powerapps

Love your energy Shane!

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

HI Shane, your learning videos are really helpful

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

Thanks Shane, You've been great help.

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

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?

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?

Great ! Thanks for your efforts!

Thanks Shane!!! You are my savior!!

This is fantastic video thanks

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.

Shane you´re just great!

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".

nice what I needed - thanks

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.

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! :-)

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!

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.

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)?

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

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!

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?

Great explanation

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

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?

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?

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!

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

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

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

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?

Helpful video ! A + + + +

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

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

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, 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.

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 (

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!

great one

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?

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

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

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.

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

hi Shane, thanks for the video, I am having difficulty patching the updated record in my collection. how do I compare IDs in my collection to the Id of my SharePoint list to patch, I am using a dynamic gallery means all the control are interactive and added to the gallery on the fly. I need to patch the newly created records as well as the updated ones. any help would be great!!

Excellent

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?

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

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!!

Shane, thank you very much for the video, Steve in Colorado here. I am still somewhat of a beginner here but here is the scenario I am tasked with and hope you can help me. My manager wants to utilize PowerBI and PowerApps to UPDATE a database. Basically it is a test db that will be used to compare two columns in a table. (This db only had one table for simplicity.) PowerBI will be utilized to report on the two columns, and from what I am told, PBI and PA can work together to update the data in the db. It looks like, from this video that I can update my data source as long as column names are identical. Can this be done to update a db? Thank you in advance.

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. 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.

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

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?

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

Hi Shane, thanks for this amazing video! May I ask if there is a way to also patch user id (email or anything that an indivudual user uses to login) and save this information in a SQL table when patching? but without the user to type in their name when completing this form? I am building a survey app and want to capture the user ID without asking them to type it in when they complete the survey questions. Thanks!

You are awesome

HI Shane, thank you very much for your work, very helpful. I've created a simple PowerApp for my small business but on my Save button I got an error: "the colon 'Ambienti_Collection' does not exist". This is what I wrote on my button: On select = Collect(EXPORT; Estrazione) - where 'EXPORT' is my Sharepoint list and 'Estrazione' my Collection list. The colons are exactly the same in both the lists. (P.s. My PowerApps is in Italian...) I can't understand Why I can't save my Collection!!! Can you help me with this? Thanks a lot

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

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) 😭

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?

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?

Hi even when my fields from my original SharePoint list is in number format. In power app that same controls gonna be underlined if I get it value by adding ".Value" suffix (e.g.ControlName.Value) like in your video. I have to use Value ( Control.Text) instead. Do you know why? Thanks!

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

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.

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, Say you have a three screen form you are collecting data from (with Clearcollect()) and on the third screen you want to have a datatable for user to review values before using a patch() to submit into a sharepoint list. I would like to input a datatable where all the names are rows and the selected values are columns. How to I transpose the powerapps datatable?

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?

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.

Hi Shane! I'm trying to upload a whole Collection into an Excel table (the collection has around 100 lines of data) but it takes almost 5min to upload once I press the button. Is there any way of speeding up the process?

Hi Shane, This works for me when I add new entries to my collection/dbo. But if i have an editable field in my gallery and I use patch to update my collection, my updates don't get sent back to my dbo using collect(dbo,collection).What am I missing?