PowerApps Patch Function

[@JonathanExcels]

I kept hearing about 'patch' but wasn't really hearing WHAT it was. You explained it clearly. Thank you. Helpful video.

[@ShanesCows]

Glad you liked it.

[@fidomcvitie9418]

Thanks Shane, more than 2 years on and this is still gold!

[@ShanesCows]

Thanks 😊

[@paulmoody4599]

Shane, your videos are awesome. I only recently started using PowerApps and have learnt so much! The pace is spot on and the delivery style makes things easy to follow and revisit. 👌

[@ShanesCows]

😻 Awesome Paul.

[@rachelroberts685]

A shortcut for new SP items with a Power Apps form, I used UpdateContext and set the Default Selected value of the choice column to the variable name, then updated the variable before submitting. It works like a charm!

[@ShanesCows]

Very cool Rachel.

[@diegoacevedo1778]

Because of your videos i'm about to become a hero in my organization. Thanks from Perú, keep it up!

[@ShanesCows]

You can do it!

[@wikiexpert]

Great work Shane, your instructions and examples are brilliantly clear!

[@ShanesCows]

Glad to help. 😀

[@AhmedBalfaqih]

You may forever stay Young. Once again, spot on. I saw other videos by other people, covering the same subject, your videos are miles ahead. Thank you.

[@ShanesCows]

I appreciate that!

[@craigjenkins6917]

Another great video Shane. This is the type of instructional videos people are looking for. Very informative and again easy to follow.

[@ShanesCows]

Thank you :)

[@rachelgriffing7197]

Thank you for all of your hard work on these videos! They have been extremely helpful in learning PowerApps from the ground up. Your enthusiasm and expertise make these super enjoyable to watch.

[@ShanesCows]

Thanks Rachel. Glad to help

[@CarlosSolisNow]

Just love it. It gave me what I needed to finish an app I built over lunch on Wednesday. Just AWESOM⚡⚡

[@ShanesCows]

Perfect 🤩

[@markpickett5016]

Great video Shane - I had struggled to get a dropdown control to bind to a choice field from the data source until i watched this one! Really helped out with an app I'm working on where I want to allow users to filter a gallery based on a dropdown value. Thanks!

[@ShanesCows]

Awesome Mark

[@Productivity365]

Hi Shane, Thanks! every time I learn new trick when watch the video.

[@ShanesCows]

Glad to help. 😀

[@lawrencesproul1541]

I simplified your DropDown Patch code by using a separate button to create a NEW record. Basically I used: Set(varRecord, Defaults(DataSource)) which enables lots of cool features such as canceling the new record and reselecting the previously selected record in the gallery...

[@ShanesCows]

Perfect that is one of the things I teach in my training class these days. 😎

[@DeadPixelZombie]

Your videos have saved my bacon with a project I'm on. Thanks!

[@ShanesCows]

AWESOME! Enjoy the bacon.

[@danielwatson7974]

I'm fairly new to PowerApps. This was incredibly useful to me. Thank you.

[@ShanesCows]

Glad to help. 😀

[@robertz.180]

I searched for it (Edit Gallery Items). Thank you Shane

[@ShanesCows]

Glad to help. 😀

[@swaminawale7386]

Patch(Emp_Info_List, Defaults(Emp_Info_List), { Title: nT.Text, 'First name': nF.Text, 'Last name': nL.Text, 'Fav color': nFC.Selected (

[@ricci.hidalgo]

Wonderful and useful video, thank you very much Shane for sharing your knowledge.

[@ShanesCows]

You are welcome 🐶

[@Stacy-skydives]

Shane, I just saw the "super trick" how many years later, I dunno, math is hard, anyways, super cool and thanks for all you do for us!

[@ShanesCows]

Happy to help. Have a great day. 🐶

[@DonD-h3d]

Hi Shane, I am loving your tutorials! Very helpful. I did have a question, I have 10 patch fields on my screen...do I have to reset each one individually after the update context?

[@searchingyt4246]

Hey Shane, you are doing amazing work! Excellent man!

[@ShanesCows]

Awesome thank you!

[@ResponsibleXI]

Thanks a lot Shane for this wonderful video. Learnt too many things from it. In your above example, what if I have one of the fields from 2nd SharePoint list on the same screen and i want to update both the lists with the save button? Do you already have video for that? How do my patch function will look like?

[@ShanesCows]

Patch(first list);Patch(Second list) is what I think you are looking for.

[@tribalhunter2978]

Bless your soul for these videos 🙏

[@ShanesCows]

Glad to help. 😀

[@timrodrigues-ellis]

Is there a way to patch a date picker field to SharePoint lists? Thank you so much, your videos are very helpful!

[@ShanesCows]

Patch(datasource, record, {datefield: Today()}) should work

[@carolerlston3876]

I really enjoy your videos, I have learned so much, thank you!

[@RichBoud1]

Thank you! I spent hours trying to work this out. I’ll give it a go.

[@ShanesCows]

Good luck. 👍

[@arnaudcoulon120]

Hi Shane, Great video ! I just discovered Power Apps and I'm learning a lot thanks to you. Still I have two questions : - Is there anyway to have a unique edit and save buttons which patch all of the items at once ? - When saving, some items in the dropdown selections don't display anymore, do you have any solution ? Thanks again !

[@juanp.ortizm.3018]

Hi, great video. I want to thank you for your dedication, I have a question, if I want, in a combobox show all the users of my office 365 and save it in a user type field of a sharepoint list, how can I achieve it, using patch? Thank you very much

[@ShanesCows]

This will show you the way kzbin.info/www/bejne/naTOYmd6YqiMiKc

[@osamaalam6336]

So informative and entertaining. Also, what if we want the edit display mode to only appear in the item where we pressed edit, instead of all?

[@ShanesCows]

I show that concept in this video. kzbin.info/www/bejne/foa7kGN3dplgftU

[@Nze02]

Finally I got the solution I've been searching for. Thanks alot

[@ShanesCows]

Glad I could help

[@johannagemaespinosalazo8855]

Thank you for all the useful videos you upload, I have a question, how to update a record with PATCH referring to the current value of the field, for example to substract or sum the existing quantity of a product in an inventory record; quantity = quantity + 1

[@altino91255268]

Oá Shane, as always your videos are fantastic. Will you allow me to answer some questions? 1st You used the Choice function, as follows "choice (fontededados. Column) this form is only for complex columns? 2 ° When should I use Selected or Selectedtext?

[@ShanesCows]

SelectedText is deprecated so always use Selected.

[@garylynch2734]

HI Shane can you use this functionality with out using a gallery? The gallery is limited by size (height) ps in 2 months you have really lifted my knowledge in this so much thank you.

[@ShanesCows]

Yes. No Gallery required 😀

[@iyoung2001]

Hey Thanks for the great video, it really helped me understand patching. I'd like to tweak your example slightly. Is it possible to set a value (text box for instance) in the item in the gallery so that when "Edit" is selected only that item becomes editable? If I use a variable it makes all items editable, which I'm worried will cause some confusion for my users. I've tried making a new column, but then I think that will change everyone's view whenever someone toggles the value. I haven't been able to figure out how to set a value from a button. I've gotten it to work using a toggle to switch back and forth, but that isn't all that intuitive for the user either, plus the patch function is wonky and there's no way to cancel. So far your example is the best of the alternatives I mentioned above, but would really like to be able to make a single item editable at a time. Thanks

[@neerajcoolcs055]

Hi Shane, Great help to new beginners. 1 doubt I have - can patch be used on a single button to perform either edit or insert new record?

[@ShanesCows]

Yes. Incorporate an If to determine which want you want the button to do.

[@ResponsibleXI]

Hey Shane, Thanks for taking sometime and responding to my question. Here is another one. I am launching my PowerApps directly from SharePoint list and I am not creating any button on my form. I have one of my columns to be patched to another SharePoint list. Without having to create the button and by using exisitng "Save" option on SharePoint EditForm, how do I use patch function?

[@ShanesCows]

Put it OnSuccess of the form

[@MrWonderfulChris]

Hi Shane - this was great - very helpful! In this same example that you have here, can you show how to patch an attachment back to your SharePoint list without using the Azure connection? Thanks

[@dylanmonson7689]

Thanks for all the videos Shane; Is it possible to use patch to somehow overcome the 20 item limit using Choices() for a managedmetadata column? This is a tough limitation for what i'm trying to accomplish.

[@ShanesCows]

I don't know Dylan. I haven't done anything with managed metadata in a long time.

[@magebol]

Hi Shane. Great Channel! very useful, thanks. I have a question about Patch. I have one button to do a 1s patch/create record, which works well. But when clicking on a second Button, it is creating a new record instead of updating the record I created with the first Button. Both buttons are outside the form in the Layout. What should I do? Thanks

[@StevenNel]

Hi Shane, First off, your tutorials are epic. Really helped me get started with PowerApps. I have a quick question: I am using a Gallery to collect data sort of like your Shopping Cart tutorial. What I want to do is search a sharepoint list for a record using data from a collection to find the record to patch in SharePoint. Below is my function: Patch('Demo Stock'; Filter('Demo Stock'; PartNumber = ThisItem.Code; SerialNumber = ThisItem.Serial); {ItemStatus: "Available"});;Refresh('Demo Stock');;Remove(LoanItems;ThisItem) I'm getting an invalid argument type (Table) error with the patch function and I am assuming its got to do with the filter. Im sure its something simple? Cheers

[@ShanesCows]

Replace filter with lookup and I think you have got it.

[@sarankumar3753]

Hi Shane, Its really nice videos. i have learn a lot. if possible can you please do more videos on Flows.

[@ShanesCows]

I will try. 😀

[@sarankumar3753]

@@ShanesCows thanks Shane for your reply. Also if possible do videos on SPFx extensions :)

[@MrIke1214]

Shane, Your videos have been a huge help. I've been learning a lot! I have a question about Collect/Patch- Is there a way to collect data into my sharepoint file from a Text input box? For example, if my radio button which has Yes,No,N/A- If No is selected, a text input allows explanation. Can that explaination be transported into the sharepoint file?

[@ShanesCows]

I have never tried to edit a file... not even sure where to tell you to start. Sorry.

[@MrIke1214]

@@ShanesCows Thanks for the response. You're videos have been a great help as I learn this platform.

[@lizawejlemand3302]

Great stuff! Would be nice to see an example on how to copy a record from a gallery or a form and create a new item... :)

[@ShanesCows]

I like it. I will add that to my video list. Thanks

[@alizia5963]

Shane - your videos are fantastic. I am trying to achieve something similar to what you are doing, rather than updating one value at a time can we update multiple rows within SharePoint with just a button click. E.g. can you provide 1 button that updates all the records with favorite color as red?

[@ShanesCows]

Hi Ali - Yes. You would want to put all of the updates you want to make in a collection and then use ForAll. I need to make a better video on that function. This video is the closest thing I have right now. kzbin.info/www/bejne/eneXfItnpLiljKs

[@BrentonCollas]

Thanks Shane, came here for this question. Patching multiple records which match a condition. Off to view your linked vid. Thankyou as well for your videos. Right to the point and no messing around. You are leading the field good man :)

[@shuoyang8894]

Hi Shane, this is really helpful video. I just have another question, is there anyway that we can Patch a Blank() value back to the data source? sometimes when a column is cleared, then the data source can reflect the same thing. Many thanks!!

[@ShanesCows]

Try this Patch(datasource, Record, {Field: Blank()})

[@MrDonduro]

Hi Shane, thanks for share all your knowledge. I have a question. How can you preserve the structure (including dropdown) and collection fields to save a new record from zero? I could do the whole video but I just need that

[@ShanesCows]

Sorry I don’t follow the question.

[@ritikasingh7530]

Great video Shane! Just wondering instead of having Edit button for each gallery item, is there a way to have 1 submit button for the full gallery and save all gallery items ?

[@ShanesCows]

Nope. You could use on change to save the items but that gets messy to me.

[@ritikasingh7530]

Shane Young thanks for responding . I am stuck with how to design a specific requirement for a checklist .

[@gwenmac1601]

Hi Shane, learning lots from your videos, after adding a record to a data source using the Patch function how can I retrieve the primary key that was autogenerated.

[@ShanesCows]

Pain in the butt to do. Set(varKey, patch(your stuff).id). This may be my next video. Great question.

[@gwenmac1601]

Thank you will try that.

[@danulienka4030]

Thank you, Shane... Your videos are great, you cut to the chase. Awesome work :-)

[@ShanesCows]

Glad to help. 😀

[@tyronewoods7480]

Hi Shane, thanks for the patching assistance! If a record exists in the table you're trying to patch, what function/syntax would you use to test that so that a duplicate record isn't created?

[@ShanesCows]

I made a whole video to help you kzbin.info/www/bejne/d6GWkHiXbq1rmJI 😊

[@ruthannvaldivia291]

Hi, Shane, another GREAT video. I am using the toggle functions which is super sweat and all works, except I'm continuing to have a recurring issue with my screen refreshing to the initial value. I say recurring only because it's happening elsewhere. I'm actually using the toggle control with the functionality you've displayed here. it all works but when I add an item, it defaults to the previous save position. ie, if I turn it off, then when I come back it's off vs. being on which is the initial setting. Would you know how to fix or what I might be doing wrong? THANKS! Love your videos!!

[@ShanesCows]

You can use the Reset function to set a control back to its default state.

[@lorenasanchez7581]

Hello Shane, thank you for this useful video, I only have a question, I struggled to do the same yo did with cancel and edit, in my case with different icons(edit and cancel hover), could you please give me an idea , how can I do a toggle with icons. I'll really appreciate it.

[@cchristoff]

Great video and fun delivery. Looking forward to your next videos.

[@ShanesCows]

Thanks. I try not to be boring.

[@rozhinimani9249]

Hi Shane, love all your videos!!! I have a request for a video 🙏. I have two SPO lists and I want to connect them through a power apps form via a common ID (maybe a GUID)... I’m not sure what the best approach would be. Please help!

[@rozhinimani9249]

To elaborate, the user would fill out form 1 connected to share point list 1 and form 2 connected to share point list 2 in the same app but it would assign the same I’d to both those new record entries to connect them on another screen

[@ShanesCows]

Maybe look at this series. it talks about relationships. kzbin.info/www/bejne/rpjdn55qjdGDedE The key is your going to need to track an ID of some sort. :)

[@pennynelson6050]

I am having trouble trying to patch to a column in my database that is an integer. any ideas?. I am .new at this powerapp stuff and your videos are really helpful.

[@ShanesCows]

Patch(datasource, defaults(datasource), {intcolumn : Value(TextInput.text)}) will turn your text number Into a number number. 😀

[@cummins75901]

Shane, as usual your videos are very helpful. Any way to have the displaymode only change for thisitem when selecting edit instead of the whole gallery? Thanks in advance.

[@ShanesCows]

Yes but complicated. This video will help you get the concept I think. kzbin.info/www/bejne/foa7kGN3dplgftU

[@jessicavelez598]

Hey Shane, great video! I am looking to a patch with a form instead of a gallery. Any tips on what function to use instead of 'thisitem'?

[@ShanesCows]

Names of the control that has the value you want.

[@picklejuavez6795]

@@ShanesCows What do you put for the record id as the second parameter? Thank you.

[@tenisviejos]

Dude, are you a wizard? Thanks for such a great video!

[@ShanesCows]

No problem glad you liked it

[@chrisgrubbs6880]

Shane, great stuff as always! How can I apply the UpdateContext to ThisItem only in a gallery? For example, if someone clicks edit on item 1 in a gallery, it only brings up the save/cancel button in that item only and it disables the other items or puts them in view mode only. Thanks!

[@ShanesCows]

This video shows it Chris. kzbin.info/www/bejne/foa7kGN3dplgftU

[@RobertNeptune]

Hi Shane! First of all, Great work, This videos really help! I'm stuck on a really tricky issue here. I'm working on a SharePoint list which holds hiring data. In the list, there is a column named "IsInvited" ， which is a choice type data with 2 options, "Not Yet" and "Already Invited". I build an app for this list, and on the detail screen, I insert a button to send an invitation email and to switch this item's IsInvited Choice from "Not Yet" to "Already Invited". Since the button is outside the edit form (In fact the button is on EmailPreview_Screen, we'd like the operator to see the email before he/she send it.) and it naturally can not benefit from the "ThisItem" feature like what you did here. I find it very confusing when trying to refer to the item I want to patch out side the gallery. And the patch function here is really tricky since the Choice type is a complex data type. I tried to find documents addressing this issue all over the internet, and so far there is few. I wonder if you are kind enough to do an episode to really break down the patch function to its core for us new learners. I think a lot of people will appreciate.

[@ShanesCows]

How did they find the record? If it was a gallery you can use gallery1.selected for the record to patch.

[@gerusnero]

good job shane. I was almost hoping to see you patch a person field entry to the SP list :D

[@ShanesCows]

Thanks. I probably should have included that. 😑 I will find a way to sneak it into a different video.

[@gerusnero]

no prob, I guess it works much the same way and I just had some typo somewhere

[@cztop54]

That's is what I need! Have you done that video yet? Thanks so much for all your help!

[@mfsalazar1]

Thanks for the video! I want to known if you can have the button out of the gallery for not repeat it in each item in the gallery. If its possible to have just one button to save all the items?

[@ShanesCows]

Yes. Look at forall function. There is actually a working example in the video on repeating tables I released this week.

[@remisuszkiewicz5543]

Hello Shane, another great Video from you. I am currently busy with a slightly different question. I want to create an app with a custom form that restores collected data to a list. How is it possible, if it is possible? Thank you in advance.

[@ShanesCows]

I don’t follow. Can you give me more specifics on what you want to do or isn’t working?

[@carlw]

Hey Shane, I love your videos. I've learned a lot. Question: How come you use Updatecontext for the Letsedit button instead of say setting Set(varEdit, false)?? Like I said, I'm learning so no judgement, I just dont understand why or when we would use one over the other unless they're interchangeable. Thx

[@ShanesCows]

They are kind of interchangeable. I have a video on variables where I explain more though. 😀

[@carlw]

@@ShanesCows Tx.seems one is a global variable the other local. Just picked up on it.i think what throws me off is the inconsistent syntax (Microsoft inconsistent???? Never). Some expressions use "{", most don't. No where I've seen does it describe why and when, moreso you need to learn it through osmosis of using the Force.

[@s961201]

Hi - love your videos! Thanks a lot. In your patch example in this video - is it necessary to patch via a button when you have made a selection in a dropdown? I'm trying to patch using the "On change" event/property of the dropdown. But iut won't let me. I have a gallery of cost saving hypothesis in my business. I would love to be able to assign status (Initiated, In progress, Needs clarfifications, Closed etc) on the go in my gallery browse/list and have my excel table updated with the correct status whenever I change the value in my drop down lit. Was I able to make myself understood here...?

[@ShanesCows]

The same code that works for a button OnSelect should work for OnChange. Maybe post a new comment with your error message you are getting.

[@hayleeadamson6449]

Another great video! Thank you!

[@ShanesCows]

Thanks 😊

[@brianlincoln2182]

Awesome video, very helpful. Is it possible to patch all values of a one-column collection into a single cell of the data source record?

[@ShanesCows]

Yes. I haven’t done it but my first try would be with Concat function. If that doesn’t work then ForAll. But pretty sure Concat will do it.

[@kirillperian]

Hi, Shane! Thank you for this video. Maybe this was answered somewhere already, but what's the easiest way of displaying the edit mode for just the item in the gallery where you clicked on the Edit button, so that not all items are switched to edit mode?

[@ShanesCows]

Maybe this will help? kzbin.info/www/bejne/eJ_dkoZ6jtFro6M

[@Xyz9104_]

Shane ..Excellent video, can you please how do you use collect to write a new record , also if my submit button is using to create , can i also use the same for creating new entry in sharepoint list

[@ShanesCows]

I think I talk about it in this video but not sure kzbin.info/www/bejne/r4SZnoeIodKootU

[@Simeon-NL]

I admire your videos and the explanations! Is there also a way to work with multiple select choices and patch them to the sharepoint list? The odata.type syntax works perfectly fine but does not support combo boxes and thus neither multiple answer possibilities. Have any idea if this just requires a small adjustment or that it is not possible yet?

[@ShanesCows]

I am not sure. I have never tried. I will try to revisit this next week and see if I come up with anything. If you solve it please let me know. :)

[@FelipeSoler23]

Good Video. I have a performance problem with a Patch for many records. I try to bulk insert into a SQL Database for a 64 records by user.

[@ShanesCows]

Yikes. That is a lot.

[@reypangilan7157]

Thanks Shane. great video.

[@ShanesCows]

You are welcome Rey 🤓

[@sanjeevtiwari17]

Thanks Shane for this video.I request you can you please make a video for error handling with Patch function.

[@ShanesCows]

That isn't a bad idea. 😊 Thanks

[@zildjiandames7741]

Hi Shane! Thank you so much for this video! But when it comes to patching, is there a way for us to check on what percentage is our patch at? Or check whether the patch is completed or not and if not can we rollback? Also it would be wonderful if you could discuss the technical features of Patch (ex how many bytes does it consume during a patch, where does it go when it fails, how do we ensure that the patch pushes to the datasource) appreciate the help!

[@ShanesCows]

Interesting questions. I don’t think there are any deeper insights. What are you trying to accomplish?

[@zildjiandames7741]

Shane Young Hey thanks for getting back! I haveteo things: 1) I’m trying to check whether a collection patch has been successful or not because if not I’ll send it to a local collection. To host on offline data. 2) I want to ensure that throughout a patch of a collection, every row will be patched, if not ideally I want to store them (rows that weren’t patched) in a local collection then resend them after 😀

[@luisbaldassoio]

Thanks Shane for your help.

[@ShanesCows]

You are welcome.

[@74popette]

Hey Shane! thanks so much for your fantastic videos - you are my go-to-guy for everything PowerApps!! I have a question - is it possible to press the edit button and only make the dropdowns/text fields editable just for that one item, rather than all items becoming editable? Thanks again from a viewer in the UK! (you even spell Colour right! :-))

[@ShanesCows]

Yes possible just create the correct If logic for display mode of the controls.

[@puppydood]

Thank you. Can you do a video on how to bulk patch a gallery with one button? 😊

[@ShanesCows]

Like this? kzbin.info/www/bejne/Zqm9ZZmDf8d_rM0

[@puppydood]

@@ShanesCows Yes!!! Fab thanks!

[@actuallyba]

Hi Shane, how can I adress an existing entry in a Sharepoint list? I have a fix list with employees and want to change the amount of days of leave. I tried the following: Patch(AmountofHolidays;{WorkersName: User().FullName};{Available: 2}. But instead of editing the existing row, it creates a new one. Thanks for out help and greetings from Germany

[@ShanesCows]

You need to add a lookup in the middle to tell it which record. Patch(SharePointList, Defaults(SharePointList),{column:value})

[@actuallyba]

@@ShanesCows Thanks a lot!! It worked!

[@jameskrull764]

@@ShanesCows Hi Shane, I'm having a similar issue. I am updating a table record in a OneDrive Excel sheet but using the SubmitForm button to update a form and calculate an overall average field in my table based on the form inputs. I tried using your command above Patch(Table1, Defaults(Table1), {'Overall Score':(CCValuePropScore.Text* 0.5 + DeliverOutcomesScore.Text*.5)}); SubmitForm(EditForm1) However it keeps on saving a new record instead of updating the record that the form is displaying. thanks for the great content your videos are fantastic! EDIT: Solved this using the following command Patch(Table1, 'Client List Display'.Selected, {'Overall Score': (CCValuePropScore.Selected.Score*0.1 + LOBGrowthScore.Selected.Score*0.1 + RevenuesGrowthScore.Selected.Score*.2 +ClientSatScore.Selected.Score*.25 + DeliverOutcomesScore.Selected.Score * 0.25 + ActivelyTrackScore.Selected.Score * 0.1)}); SubmitForm(EditForm1) The key takeaway is I used the 'Item' value in the Editform card, in my case this was called 'Client List Display'.Selected. It was as simple as calling this variable as the BaseRecord in my Patch command. then using the other fields to calculate a weighted average and update my overall score variable in the OneDrive Excel document

[@PACWESTVB]

Thank you for all your great videos! I have been using your videos to help our club manage our own database. I have a question regarding the patch function. When I insert a slider on a gallery and use the patch function on the OnChange, the app slows down immediately and just has the dots going across continuously. Would you be able to help me configure a better way to have the slider make changes without having a save button? Thank you!

[@ShanesCows]

Unfortunately I don’t have a good answer with the slider. 😔 Every step is going to trick on change. Boo. Might have to come up with a plan B. Dropdown instead? Sorry

[@ShanesCows]

Fun fact. I have played and coached club volleyball. Coached a couple of teams that made nationals. Been a long time.

[@PACWESTVB]

@@ShanesCows Awesome! Volleyball is a great sport! I'm trying to make an evaluation tool on passing, setting, hitting, blocking, serving. Something that is quick while the athletes run through. Last season we had 300 players to evaluate. I like the slider for the quick movement, but I think I'm going to have to go with a save button. Does that seem like it might solve the issue?

[@ShanesCows]

@@PACWESTVB yes that would do it. Or use a Dropdown and then you can use OnChange

[@davysmets2138]

I enjoyed both, the little tricks and learning about patch ;-)

[@ShanesCows]

Cool

[@hollybud999]

Hi Shane, How secure is patching to SharePoint when it is within a business? Is there any risk with the data? (Side note - these videos are amazing! I have taught myself so much using these videos!)

[@ShanesCows]

No security leaks that I know of. 😀 I am using it for some secure stiff with no worries

[@Speedy19000]

This is a great video and I have learned a lot by watching your videos. I was following along and creating a different app with similar features, but I have found a strange issue. While I am editing the app, I can go up to the run button and everything is fine, it runs like it is supposed to. But, when I try to run the app from the PowerApps home page, the buttons are not visible. Have you ever run into this problem?

[@ShanesCows]

I haven’t. What browser?

[@Speedy19000]

I figured it out, I had saved the app but hadn't published it since the first time I published it. As soon as I published it again, all my changes since the first publishing showed up.

[@basselkosanee1591]

Thank you for sharing your videos Shane. I am trying to build a logging activity for my application; I have created a record when a new user sign in to the main page (On Visible) but I do not know how to patch other statements to the same record especially more than one person are using the application. I do not want to update because I have to keep tracking of what this person has been doing during the time of using the application ...

[@ShanesCows]

Try this video. Does it help? PowerApps Audit Logging kzbin.info/www/bejne/qn-ulKargZxlodU

[@cesarherrera7509]

Very informative, Video Shane, i have replicated your instructions but within another form sort of a parent child form, the issue that im running into it that the gallery will update all the item as opposed to just one, have you had any issue like this where you update one but a few seconds later the rest update to the saved value/text. any ideas to point in the right directions would be greatly appreciated. Thanks Cesar

[@ShanesCows]

Can you share the code you are using? Might give me a hint to help you. :)

[@smartin8707]

You've been a life saver Shane...question for you: Is there a way that when you hit Edit, only the Submit/Save button pops up for the card that you want to edit in the gallery? I like the function but for every card I hit edit on, it shows the Save button in every card of the gallery. Little confusing for my users. Help! :)

[@ShanesCows]

Yes but you have to write the logic to make it work. Not fun but possible.

[@keaklaassen5340]

Hi Shane, Again a great video .. Thanks. Do you know why my gallery resets to the first item after patching? 2 Sharepoint lists, want them both to be updated, works great the first time ., after updating the gallery reverts to first item, not the selected one.

[@ShanesCows]

Yes. The data source is changing so the gallery is refreshing. Need to store your gallery item in a variable so you don’t lose it. This might be my next video. You are the third person to have the issue this week. 😀

[@rickdesnoyers8978]

Hi Shane, thanks for another great video! Question: I have a 'person' field (SP List) that I'm trying to change for a selected gallery item. ThisItem isn't available and the Lookup function doesn't appear to update the record when using a Button with OnSelect. Any thoughts?

[@ShanesCows]

It is a complex column so you have to do it differently kzbin.info/www/bejne/naTOYmd6YqiMiKc

[@nitinsharma2638]

Hi Shane, Thank you so much for you videos, these are awesome!! One thing where I am facing issue is, Data Source screen is not coming up the way comes up on your screen. Can you please help from where I can make it visible. It always overlaps with screens.

[@julianfolino]

I'm on a dead end! Thank you for your videos since they helped me a lot but I've been trying to find a solution and I'm lost. I have a form in the app with a "Submit" button that has a Flow sending all the information entered by the user to the sharepoint list (mostly text so it's easy). But I want also to have possibility to send attachments and Persons (multiple) and as it is not text, I need to use the Patch but all what I see is to update a record already built. I'm not sure how to do it collectively with this submit button creating the record with all inside. Any thoughts??

[@ShanesCows]

I talk about patching complex columns in this video kzbin.info/www/bejne/naTOYmd6YqiMiKc

[@MayankGupta-te3tn]

Thank you Shane. Just one query, if we want to save all list items of a gallery by just clicking on the update button, how can I do that?

[@ShanesCows]

Look for my video on ForAll

[@EricEwers]

This has been a tremendous help to me, thank you so much!

[@ShanesCows]

Glad to hear. :)

[@kushalmehta1171]

Awesome Video! I am trying to update all rows of a column in excel to a default value when the powerapp loads up. Any idea how I should do that?

[@ShanesCows]

Look at the ForAll function

[@beyou7122]

Hi Shane! Very informative video! Following your videos are a great help! I had a query, i have added a label inside the gallery items, which shows the value of true and false based on some values in gallery items. Now i want to push this label text of true/false in a column of SharePoint list ( the same list this gallery is using). Additionally i want to apply this at the OnStart of the app. Below is the formula that i am using: Patch( DataSourceList, thisGallery.Selected, {Column: thisGallery.selected.label1.text}) This is not showing any error but not patching the SharePoint list as well. Please help! This is not

[@ShanesCows]

Try Label1.text without the gallery selected part.

[@beyou7122]

@@ShanesCows i tried, it is still not working.. could you please look into the query powerusers.microsoft.com/t5/Building-Power-Apps/Not-able-to-perform-patch-a-label-for-all-items/m-p/652317#M207659 And this powerusers.microsoft.com/t5/Building-Power-Apps/delegable-alternative-for-IN-operator/m-p/652403#M207703 in community and help on the issue, i need to implement this for my app and i am find of stuck, please help..

[@gerantinahoxha8927]

Hi Shane. All of your videos have been very usefull to me so far. Thanks a lot. I have a question, I would really appreciate if you can helo me.Im using Patch to update a date column in sharepoint. What I do: Patch([@'Gallery']; ThisItem; {Datecolumn: DatePicker.SelectedDate}) but at the end nothing is changed. Thank you in advance

[@gerantinahoxha8927]

Ps: it doesn't show any errors. And when I use it the same way but for e.g with a dropdown, everything works fine

[@ShanesCows]

Patch(datasource not gallery1

[@gerantinahoxha8927]

@@ShanesCows Thank you

[@rayshrestha7495]

Hey Shane, thanks for all your awesome videos, really helps a lot. Quick question, my SharePoint list column name has a single quote, for example, "Special Instruction / KPI's" and when I try to patch it with " Patch('Client Briefs',Gallery2.Selected, {'Special Instructions / KPI's', DataCardValue35.Text} " it comes up with an error saying the column name does not exits. I am thinking of changing the column name and trying again, but my whole power apps is built already, and I fear if I change the column name, it will affect my app. Please help.

[@ShanesCows]

Replied to the other comment

[@zeugnima]

Awesome videos, so useful in helping me understand PowerApps. However my app is loading with my cancel button visible, once I enter and then exit "lets edit " it functions as expected. Is there a way to ensure that the app loads with "lets edit" set to false? or is that even the problem?

[@ShanesCows]

You can set the variable to false when the app loads. Use OnStart.

[@zeugnima]

@@ShanesCows I had tried that using [App>OnStart=Set(LetsEdit,false)] it turned out that I needed to change [visible=LetsEdit] to [visible=If(LetsEdit,true,false)] on my save an cancel icons. I'm not sure if that was a function of using icons vs buttons, but thanks for your help. I wouldn't have gotten nearly this far without the video!

[@JT-sr7fp]

Thanks Shane. Probably a simple question but cannot find the solution - How do I patch back information from the power app form to update an existing record in a SharePoint List, instead of it creating new records? Thank you

[@ShanesCows]

Patch(SharePointList, LookUp(SharePointList, formula to get the record you want to change), {ColumnToChange: ValueToSet})

[@TIMEPIECE66]

Hi Shane - thanks for all the great videos! Hoping you will be able to point me in the right direction trying to write the URL of a Picture field in SharePoint (SP). I can save out a picture to a SP Picture Library and get returned the URL to the Picture. I then try to create a new entry in another list that uses the returned URL as the Picture URL of a Hyperlink/Picture field, set to Picture. I'm using Patch, which shows the Picture: field but it fails to write suggesting it is read only. Any hints or suggestions would be most appreciated.

[@ShanesCows]

I don't. I haven't tried that. Boo me

[@TIMEPIECE66]

Ok, thanks but though it was worth asking. Fancy doing a video on it? 😋

[@churrascowonton6789]

Thank you so much, Shane. I learned a lot from this!

[@ShanesCows]

Cool

[@capucinevetter8681]

Hi Shane ! Thanks for the video. If we want to Patch in a FormViewer, what would be the record part of the formula. "ThisItem" doesn't work... I have a message error. Many thaks in advance for your answer !

[@ShanesCows]

You would want to Lookup the record you want to patch. You are right thisitem doesn’t work out of a gallery or form.