PowerApps Patch Function

Ғылым және технология

In this video, you will learn about the PowerApps Patch Function using a custom gallery and SharePoint lists. Even if you are already an expert on patching SharePoint you will enjoy the little tricks taught for using a gallery to edit items.
PowerApps Consulting www.PowerApps911.com

Пікірлер: 444

  • @fidomcvitie9418
    @fidomcvitie94183 жыл бұрын

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

  • @ShanesCows

    @ShanesCows

    3 жыл бұрын

    Thanks 😊

  • @rachelgriffing7197
    @rachelgriffing71975 жыл бұрын

    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

    @ShanesCows

    5 жыл бұрын

    Thanks Rachel. Glad to help

  • @paulmoody4599
    @paulmoody45995 жыл бұрын

    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

    @ShanesCows

    5 жыл бұрын

    😻 Awesome Paul.

  • @wikiexpert
    @wikiexpert4 жыл бұрын

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

  • @ShanesCows

    @ShanesCows

    4 жыл бұрын

    Glad to help. 😀

  • @markpickett5016
    @markpickett50165 жыл бұрын

    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

    @ShanesCows

    5 жыл бұрын

    Awesome Mark

  • @DeadPixelZombie
    @DeadPixelZombie5 жыл бұрын

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

  • @ShanesCows

    @ShanesCows

    5 жыл бұрын

    AWESOME! Enjoy the bacon.

  • @craigjenkins6917
    @craigjenkins69176 жыл бұрын

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

  • @ShanesCows

    @ShanesCows

    6 жыл бұрын

    Thank you :)

  • @RichBoud1
    @RichBoud14 жыл бұрын

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

  • @ShanesCows

    @ShanesCows

    4 жыл бұрын

    Good luck. 👍

  • @Productivity365
    @Productivity3653 жыл бұрын

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

  • @ShanesCows

    @ShanesCows

    3 жыл бұрын

    Glad to help. 😀

  • @rachelroberts685
    @rachelroberts6852 жыл бұрын

    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

    @ShanesCows

    2 жыл бұрын

    Very cool Rachel.

  • @CarlosSolisNow
    @CarlosSolisNow2 жыл бұрын

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

  • @ShanesCows

    @ShanesCows

    2 жыл бұрын

    Perfect 🤩

  • @AhmedBalfaqih
    @AhmedBalfaqih3 жыл бұрын

    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

    @ShanesCows

    3 жыл бұрын

    I appreciate that!

  • @diegoacevedo1778
    @diegoacevedo17783 жыл бұрын

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

  • @ShanesCows

    @ShanesCows

    3 жыл бұрын

    You can do it!

  • @danielwatson7974
    @danielwatson79744 жыл бұрын

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

  • @ShanesCows

    @ShanesCows

    4 жыл бұрын

    Glad to help. 😀

  • @danulienka4030
    @danulienka40304 жыл бұрын

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

  • @ShanesCows

    @ShanesCows

    4 жыл бұрын

    Glad to help. 😀

  • @churrascowonton6789
    @churrascowonton67895 жыл бұрын

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

  • @ShanesCows

    @ShanesCows

    5 жыл бұрын

    Cool

  • @robertz.180
    @robertz.1804 жыл бұрын

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

  • @ShanesCows

    @ShanesCows

    4 жыл бұрын

    Glad to help. 😀

  • @JonathanExcels
    @JonathanExcels6 жыл бұрын

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

  • @ShanesCows

    @ShanesCows

    6 жыл бұрын

    Glad you liked it.

  • @tribalhunter2978
    @tribalhunter29784 жыл бұрын

    Bless your soul for these videos 🙏

  • @ShanesCows

    @ShanesCows

    4 жыл бұрын

    Glad to help. 😀

  • @davysmets2138
    @davysmets21385 жыл бұрын

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

  • @ShanesCows

    @ShanesCows

    5 жыл бұрын

    Cool

  • @searchingyt4246
    @searchingyt42463 жыл бұрын

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

  • @ShanesCows

    @ShanesCows

    3 жыл бұрын

    Awesome thank you!

  • @cchristoff
    @cchristoff6 жыл бұрын

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

  • @ShanesCows

    @ShanesCows

    6 жыл бұрын

    Thanks. I try not to be boring.

  • @Nze02
    @Nze023 жыл бұрын

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

  • @ShanesCows

    @ShanesCows

    3 жыл бұрын

    Glad I could help

  • @carolerlston3876
    @carolerlston38762 жыл бұрын

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

  • @officehowto
    @officehowto5 жыл бұрын

    Shane, many thanks for the amazing video.

  • @ShanesCows

    @ShanesCows

    5 жыл бұрын

    You are welcome.

  • @Stacy-skydives
    @Stacy-skydives11 ай бұрын

    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

    @ShanesCows

    11 ай бұрын

    Happy to help. Have a great day. 🐶

  • @charles-antoinedolbeau5215
    @charles-antoinedolbeau52154 жыл бұрын

    Thank you for this video ! I discovered the "choices" function and it avoids me to maintain 2 lists (SP and Powerapps). And this odata..... I've been looking for this everywhere and at the end I put an hidden dropdown as a workaround. My code is now much cleaner !

  • @ShanesCows

    @ShanesCows

    4 жыл бұрын

    Awesome 👏

  • @tenisviejos
    @tenisviejos5 жыл бұрын

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

  • @ShanesCows

    @ShanesCows

    5 жыл бұрын

    No problem glad you liked it

  • @EricEwers
    @EricEwers5 жыл бұрын

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

  • @ShanesCows

    @ShanesCows

    5 жыл бұрын

    Glad to hear. :)

  • @hayleeadamson6449
    @hayleeadamson64492 жыл бұрын

    Another great video! Thank you!

  • @ShanesCows

    @ShanesCows

    2 жыл бұрын

    Thanks 😊

  • @ricci.hidalgo
    @ricci.hidalgo3 жыл бұрын

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

  • @ShanesCows

    @ShanesCows

    3 жыл бұрын

    You are welcome 🐶

  • @aikiart3
    @aikiart36 жыл бұрын

    Thanks very clear and concise!!!

  • @ShanesCows

    @ShanesCows

    6 жыл бұрын

    You are welcome. 😀

  • @lawrencesproul1541
    @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

    @ShanesCows

    Жыл бұрын

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

  • @swaminawale7386
    @swaminawale73862 жыл бұрын

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

  • @reypangilan7157
    @reypangilan71574 жыл бұрын

    Thanks Shane. great video.

  • @ShanesCows

    @ShanesCows

    4 жыл бұрын

    You are welcome Rey 🤓

  • @luisbaldassoio
    @luisbaldassoio3 жыл бұрын

    Thanks Shane for your help.

  • @ShanesCows

    @ShanesCows

    3 жыл бұрын

    You are welcome.

  • @gerusnero
    @gerusnero6 жыл бұрын

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

  • @ShanesCows

    @ShanesCows

    6 жыл бұрын

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

  • @gerusnero

    @gerusnero

    6 жыл бұрын

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

  • @cztop54

    @cztop54

    5 жыл бұрын

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

  • @davecawthorn2234
    @davecawthorn22346 жыл бұрын

    Colour - way to go Shane!!

  • @ShanesCows

    @ShanesCows

    6 жыл бұрын

    I also like behaviour :)

  • @samitsainilearningtube7481
    @samitsainilearningtube74814 жыл бұрын

    Fantastic Video like always

  • @galinagolant
    @galinagolant3 жыл бұрын

    Cool video!!! Helpful hints!!!

  • @ShanesCows

    @ShanesCows

    3 жыл бұрын

    Glad you enjoyed!

  • @franklinwanderson4316
    @franklinwanderson43165 жыл бұрын

    Thanks very much, bro!

  • @ShanesCows

    @ShanesCows

    5 жыл бұрын

    No problem

  • @JOS000007
    @JOS0000075 жыл бұрын

    Great work!

  • @ShanesCows

    @ShanesCows

    5 жыл бұрын

    Thanks

  • @Daltmaly
    @Daltmaly2 жыл бұрын

    THANK YOU !! YOU'RE THE BEST

  • @ShanesCows

    @ShanesCows

    2 жыл бұрын

    Happy to help. Have a great day. 🐶

  • @kannank7313
    @kannank73135 жыл бұрын

    Thanks Shane. Awesome

  • @ShanesCows

    @ShanesCows

    5 жыл бұрын

    You are welcome.

  • @riasrivastava7146
    @riasrivastava71464 жыл бұрын

    Really helpful video!

  • @ShanesCows

    @ShanesCows

    4 жыл бұрын

    Glad to help. 😀

  • @doyouknow31
    @doyouknow315 жыл бұрын

    Thanks for great video

  • @ShanesCows

    @ShanesCows

    5 жыл бұрын

    You are welcome. 😻

  • @magebol
    @magebol4 жыл бұрын

    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

  • @Vihushrihu
    @Vihushrihu3 жыл бұрын

    You are awesome !

  • @ShanesCows

    @ShanesCows

    3 жыл бұрын

    Thanks 🙏

  • @MrWonderfulChris
    @MrWonderfulChris3 жыл бұрын

    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

  • @iyoung2001
    @iyoung20012 жыл бұрын

    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

  • @nitinsharma2638
    @nitinsharma26384 жыл бұрын

    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.

  • @user-rt3fw5jw8l
    @user-rt3fw5jw8l9 ай бұрын

    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?

  • @lizawejlemand3302
    @lizawejlemand33023 жыл бұрын

    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

    @ShanesCows

    3 жыл бұрын

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

  • @arnaudcoulon120
    @arnaudcoulon1202 жыл бұрын

    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 !

  • @valentinanovara7122
    @valentinanovara71222 жыл бұрын

    HI Shane, is there a way to reference in a Gallery as dropdown items a different list instead of using Choices() and a choice column in the same Sharepoint list? I hate to maintain choices list in the "back end" and I'd rather use a Sharepoint list and create an admin screen to add new choices if needed

  • @johelsantos5636
    @johelsantos56364 жыл бұрын

    Thank you so much

  • @ShanesCows

    @ShanesCows

    4 жыл бұрын

    You are welcome 😁

  • @user-tt3rn9me7w
    @user-tt3rn9me7w3 жыл бұрын

    Огонь! Спасибо!

  • @ShanesCows

    @ShanesCows

    3 жыл бұрын

    Пожалуйста (I hope I got that correct)

  • @user-tt3rn9me7w

    @user-tt3rn9me7w

    2 жыл бұрын

    @@ShanesCows everything is right)

  • @RobertNeptune
    @RobertNeptune5 жыл бұрын

    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

    @ShanesCows

    5 жыл бұрын

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

  • @johannagemaespinosalazo8855
    @johannagemaespinosalazo88553 жыл бұрын

    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

  • @sarankumar3753
    @sarankumar37534 жыл бұрын

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

  • @ShanesCows

    @ShanesCows

    4 жыл бұрын

    I will try. 😀

  • @sarankumar3753

    @sarankumar3753

    4 жыл бұрын

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

  • @Simeon-NL
    @Simeon-NL6 жыл бұрын

    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

    @ShanesCows

    6 жыл бұрын

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

  • @grapegh0stx
    @grapegh0stx2 жыл бұрын

    Thank you for your hard work. Just a question though is it possible to patch all entries similar to SubmitForm? I just want to "Save As" during EditForm and I do not know any other method rather than patch but with many fields (over 100) I find it irrational way sadly

  • @RakeshDas-zk3sp
    @RakeshDas-zk3sp4 жыл бұрын

    Terrific Content

  • @ShanesCows

    @ShanesCows

    4 жыл бұрын

    Thank you ☺️

  • @RakeshDas-zk3sp

    @RakeshDas-zk3sp

    4 жыл бұрын

    @@ShanesCows Hi Shane, Would you be kind enough to help me out on a combobox issue?

  • @ResponsibleXI
    @ResponsibleXI4 жыл бұрын

    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

    @ShanesCows

    4 жыл бұрын

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

  • @tyronewoods7480
    @tyronewoods74804 жыл бұрын

    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

    @ShanesCows

    4 жыл бұрын

    I made a whole video to help you kzread.info/dash/bejne/c6RnwaeaaauekpM.html 😊

  • @sanjeevtiwari17
    @sanjeevtiwari174 жыл бұрын

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

  • @ShanesCows

    @ShanesCows

    4 жыл бұрын

    That isn't a bad idea. 😊 Thanks

  • @cummins75901
    @cummins759013 жыл бұрын

    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

    @ShanesCows

    3 жыл бұрын

    Yes but complicated. This video will help you get the concept I think. kzread.info/dash/bejne/eomMwZJ6cZeTeNY.html

  • @74popette
    @74popette4 жыл бұрын

    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

    @ShanesCows

    4 жыл бұрын

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

  • @ruthannvaldivia291
    @ruthannvaldivia2916 жыл бұрын

    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

    @ShanesCows

    6 жыл бұрын

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

  • @lorenasanchez7581
    @lorenasanchez75812 жыл бұрын

    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.

  • @kirillperian
    @kirillperian3 жыл бұрын

    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

    @ShanesCows

    3 жыл бұрын

    Maybe this will help? kzread.info/dash/bejne/dKKuw7V9ic-enaQ.html

  • @chrisgrubbs6880
    @chrisgrubbs68804 жыл бұрын

    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

    @ShanesCows

    4 жыл бұрын

    This video shows it Chris. kzread.info/dash/bejne/eomMwZJ6cZeTeNY.html

  • @s961201
    @s9612013 жыл бұрын

    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

    @ShanesCows

    3 жыл бұрын

    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.

  • @brianlincoln2182
    @brianlincoln21825 жыл бұрын

    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

    @ShanesCows

    5 жыл бұрын

    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.

  • @rickdesnoyers8978
    @rickdesnoyers89783 жыл бұрын

    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

    @ShanesCows

    3 жыл бұрын

    It is a complex column so you have to do it differently kzread.info/dash/bejne/maefk5Z9Xaa_gqg.html

  • @MrDonduro
    @MrDonduro3 жыл бұрын

    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

    @ShanesCows

    3 жыл бұрын

    Sorry I don’t follow the question.

  • @mfsalazar1
    @mfsalazar16 жыл бұрын

    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

    @ShanesCows

    6 жыл бұрын

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

  • @taellis2
    @taellis24 жыл бұрын

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

  • @ShanesCows

    @ShanesCows

    4 жыл бұрын

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

  • @carlw
    @carlw4 жыл бұрын

    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

    @ShanesCows

    4 жыл бұрын

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

  • @carlw

    @carlw

    4 жыл бұрын

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

  • @dylanmonson7689
    @dylanmonson76893 жыл бұрын

    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

    @ShanesCows

    3 жыл бұрын

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

  • @FelipeSoler23
    @FelipeSoler236 жыл бұрын

    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

    @ShanesCows

    6 жыл бұрын

    Yikes. That is a lot.

  • @neerajcoolcs055
    @neerajcoolcs0554 жыл бұрын

    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

    @ShanesCows

    4 жыл бұрын

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

  • @vickiscarpato3299
    @vickiscarpato32995 жыл бұрын

    Shane, another great video! I'm trying to recreate using a Date field (Insert DatePicker) and two Number fields (Insert TextInput of Format Number) . My Patch function gets "An unknown error" whenever I try to run. My Save button OnSelect = Patch('Support Tracking',ThisItem, {Date: inputDate, Influence: inputInfluence, Support: inputSupport}) I modified the OnSelect to try to Patch with just one of the fields (e.g. Patch('Support Tracking',ThisItem, {Date: inputDate}), and i keep getting the same error, regardless of which field I try to Patch, in any combination. Any thoughts?

  • @ShanesCows

    @ShanesCows

    5 жыл бұрын

    InputDate.SelectedDate

  • @verdijason11
    @verdijason114 жыл бұрын

    Hey Shane, do you know what the syntax would be to add a checkbox value from SharePoint instead of a choice field (i.e - Choices(Employees.FavoriteColor))?

  • @ShanesCows

    @ShanesCows

    4 жыл бұрын

    Maybe this will help? kzread.info/dash/bejne/maefk5Z9Xaa_gqg.html

  • @rayshrestha7495
    @rayshrestha74955 жыл бұрын

    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

    @ShanesCows

    4 жыл бұрын

    Replied to the other comment

  • @jameslbetteridge
    @jameslbetteridge5 жыл бұрын

    Hi Shane, I've been following your recommendation for using Flow to and PowerApps to add data from a SQL DB to a Sharepoint List but stumbled across your Patch video. I've probably misunderstoof Patch entirely but it seems as though this could be used in my soltion instead of Flow? Is that possible?

  • @ShanesCows

    @ShanesCows

    5 жыл бұрын

    Yes if I am understand that would work.

  • @travisbenge1912
    @travisbenge19124 жыл бұрын

    Thanks for all the great videos! I have a question regarding this function: I'm trying to do this outside of a gallery, I do have a gallery linked to some display forms, I want to add a counter to the side which updates the SharePoint column of a specific item. So far I have this: Patch('MFG Master List', SearchQuery.Selected, {QtyComplete: CountBox.Text}) My problem is the second bit there, "ThisItem" wouldn't work as this button & field is outside of the gallery but I don't understand how to address this so it is updating the QtyComplete for the item I want.

  • @travisbenge1912

    @travisbenge1912

    4 жыл бұрын

    Nevermind, for some reason yesterday I was receiving an error and the button wouldn't work, but today it is working fine. So strange

  • @ShanesCows

    @ShanesCows

    4 жыл бұрын

    Glad you got it. 😻

  • @shuoyang8894
    @shuoyang88944 жыл бұрын

    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

    @ShanesCows

    4 жыл бұрын

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

  • @MrIke1214
    @MrIke12144 жыл бұрын

    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

    @ShanesCows

    4 жыл бұрын

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

  • @MrIke1214

    @MrIke1214

    4 жыл бұрын

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

  • @ResponsibleXI
    @ResponsibleXI4 жыл бұрын

    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

    @ShanesCows

    4 жыл бұрын

    Put it OnSuccess of the form

  • @ramisolipe7001
    @ramisolipe70013 жыл бұрын

    I like this Video a lot , ohhh. If there is any update for this video , please make another one .

  • @ShanesCows

    @ShanesCows

    3 жыл бұрын

    Patch hasn’t changed so you should be good.

  • @jessicavelez598
    @jessicavelez5984 жыл бұрын

    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

    @ShanesCows

    4 жыл бұрын

    Names of the control that has the value you want.

  • @picklejuavez6795

    @picklejuavez6795

    4 жыл бұрын

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

  • @zildjiandames7741
    @zildjiandames77415 жыл бұрын

    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

    @ShanesCows

    5 жыл бұрын

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

  • @zildjiandames7741

    @zildjiandames7741

    5 жыл бұрын

    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 😀

  • @TNNCMusic
    @TNNCMusic4 жыл бұрын

    Hi Shane, great content! When i try to use the Patch function it does not allow me to use "defaults" or anythin after Patch for that matter. If i go Patch(listname, Defaults(listname), it does not register anything after Patch(listname, unless i use something else than a comma? Do you have any experience with this issue or perhabs any advice? :)

  • @ShanesCows

    @ShanesCows

    4 жыл бұрын

    Are you in a region that uses a comma as a decimal separator? If so you can use a ; where I use a ,

  • @keaklaassen5340
    @keaklaassen53405 жыл бұрын

    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

    @ShanesCows

    5 жыл бұрын

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

  • @basselkosanee1591
    @basselkosanee15915 жыл бұрын

    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

    @ShanesCows

    5 жыл бұрын

    Try this video. Does it help? PowerApps Audit Logging kzread.info/dash/bejne/poJ_xdWufJqYm9Y.html

  • @cesarherrera7509
    @cesarherrera75096 жыл бұрын

    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

    @ShanesCows

    6 жыл бұрын

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

  • @MayankGupta-te3tn
    @MayankGupta-te3tn4 жыл бұрын

    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

    @ShanesCows

    4 жыл бұрын

    Look for my video on ForAll

  • @osamaalam6336
    @osamaalam63363 жыл бұрын

    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

    @ShanesCows

    3 жыл бұрын

    I show that concept in this video. kzread.info/dash/bejne/eomMwZJ6cZeTeNY.html

  • @kateschultz2362
    @kateschultz23625 жыл бұрын

    Hi Shane :) I'm trying to figure out how to edit just one record at a time. So instead of clicking edit and seeing ALL items in the gallery switch to edit mode, I just want the selected item to change to edit mode. Is that possible?

  • @Djupree1

    @Djupree1

    4 жыл бұрын

    I am also wondering how this could be achieved? Did you find a solution?

Келесі