Reza, I regret that I cannot give one million likes for this video. I have reduced the time it takes to save the entries to my SharePoint list right now from 2 minutes to just 6 seconds thanks to your video. And it took me less than 5 minutes to change the code. Thank you so much for your tutorial, it has been a great help!
@RezaDorrani
3 жыл бұрын
Yes yes yes. So happy to hear that. Glad the video was helpful. I was running into a similar issue at my end and then I learnt about this technique.
@ThisIsFrederic
Жыл бұрын
Hi Reza Thank you for taking the time to share your knowledge with us! I have created a similar app with a bulk select feature, using Dataverse as a backend. Once records have been patched into the database (code of the On Select button being totally executed) , the gallery may take a few seconds to reflect the changes made. In that case, end-user can still select an item in the gallery that looks brand new, and click update. Consequently, because the new database ID of the record is not yet showing in the gallery, a duplicate record is created upon patching. And since there is no On Refresh event for galleries, it's difficult to know when the gallery reflects the changes made in the backend (refreshes are not synchronous). I am sure you have already faced this use case, and I am curious to know how you are dealing with it. Thanks!
@RezaDorrani
Жыл бұрын
I have not faced the issue around duplicates. Once user clicks submit button, you could always overlay a control over the grid which blocks user from making changes until the submit action is complete.
@wimjandan
Жыл бұрын
Great video. Everything works at my side except for one thing. I am working with a SharePoint list called Pets. While copying records (creating New record), the lines "ClearCollect( colDataToPatch, DropColumns( colUpdates, "ID" ) ); Patch( Pets, colDataToPatch ); " Still give me the error "Network error when using the Patch function. Field 'Id' is required "
@RezaDorrani
Жыл бұрын
I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@wimjandan
Жыл бұрын
@@RezaDorrani I solved it by using the Showcolumns option in stead of Dropcolums. Showcolumns worked while Dropcolumns gave an error that ID was required. Huh???????? What ??????? How ??????? 🙂
@RezaDorrani
Жыл бұрын
@@wimjandan No idea! As long as it worked :)
@付闯-f2f
5 ай бұрын
thanks a lot and i have a question:Patch( DataSource, BaseRecordsTable, ChangeRecordTable1 [, ChangeRecordTable2, … ] ) , why in your video,only 2 without baserecordtable?
@RezaDorrani
5 ай бұрын
Because Patch also supports a collection as a parameter
@sapnakarda3186
2 жыл бұрын
Hi Reza, using your video I created a new app and it helped me so much thank you so much. I am using bulk patch just facing one issue of errors. I want to show success msg but only if there is no error. Tried multiple things but still having issue with error handling, do you have any video for that?
@RezaDorrani
2 жыл бұрын
I do not have a video related to error handling. When you execute the Patch function, if you set a variable example: Set(varResult, Patch(...)) The variable will have all the details you need for error handling.
@chadstone345
2 жыл бұрын
Thank you Reza for this video. Is it possible to patch duplicate records by defining x number from user. For e.g. is this video you are selecting number of records to duplicate but instead of selecting how can you patch let say user typed 8 times he/she needs to duplicate the records?
@RezaDorrani
2 жыл бұрын
Possible. Get the number from the user and when Patching run it in a loop set by the user.
@valdeirbarbosa637
2 жыл бұрын
Hello Reza Dorrani, please could you share how you create a oncheck all items in a gallery, please ? Thank you for share a lot of knowledge !!
@RezaDorrani
2 жыл бұрын
I showcased it in a different video. Check kzitem.info/news/bejne/sWyv132mo5-Bpag
@saratchandra7388
3 жыл бұрын
how select all checks all checkbox and patch ,code shared in github is not able to comprehend,could you please add code below .Appreciate your answer.
@RezaDorrani
3 жыл бұрын
The App is shared in github. Set( varCheckSelect, !varCheckSelect ); If( varCheckSelect, ClearCollect( colUpdates, If(IsBlank(varFilter),Tasks, Filter(Tasks,'Task Status' = varFilter)) ), Clear(colUpdates) )
@hsaxena502
3 жыл бұрын
Where were you all these years. I have been struggling with PowerApps and flow for bulk update. Thank you so much. I'll implement these changes ASAP.
@RezaDorrani
3 жыл бұрын
You are most welcome. This was suggested to me by a subscriber :)
@wendyl6455
Жыл бұрын
I am getting the error of "invalid argument type (table). expecting a record value instead". Here is the code: Set( gbl_TimerStart, Now() ); ClearCollect( col_DatatoPatch, ShowColumns( col_Booking, "ID", "Title", "BookedDate", "BookedRoom", "BookedRoomName", "BookingStatus", "REQNum" ) ); Patch(BookingLineItems, col_DatatoPatch); SP List: Column (click to edit) Type Required Title Single line of text BookedDate Single line of text BookedRoom Number BookedRoomName Single line of text BookingStatus Number REQNum Single line of text Modified Date and Time Created Date and Time Created By Person or Group Modified By Person or Group Any idea why? TIA.
@RezaDorrani
Жыл бұрын
I have not come across this issue hence not sure. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@rengon9611
3 жыл бұрын
What is the code in the check all button. Looks like that part is skipped which was important to me.
@RezaDorrani
3 жыл бұрын
Video description has link to download the solution file. ** Import it as a solution.
@ResponsibleXI
3 жыл бұрын
Does my collection has to be exactly look like my data source? is that taken care when you created the collection on fly while checking the gallery items? Or do you have it initialized anywhere?
@RezaDorrani
3 жыл бұрын
It is taken care of when I add the record to the Collection on check in the gallery. No initialization required.
@rohitkachhadiya3694
2 жыл бұрын
Wonderful video @Reza Dorrani. Thanks for this. Appreciate if you can share the formula as I am getting error while importing the file from GitHub link that you shared.
@RezaDorrani
2 жыл бұрын
Link is a solution file. Did you import as a solution?
@rohitkachhadiya3694
2 жыл бұрын
@@RezaDorrani thanks for prompt reply. I was importing it as app. Sorry! It's working perfectly with solution import 👍
@TheSwedishRocks
3 жыл бұрын
Absolutely love your videos! Learnt lots and saved me many hours. One question, How does your select all work? I can update the gallery item check boxes, but it doesn't add anything to the collection!! If I manually select a record or many it is added to the collection.
@RezaDorrani
3 жыл бұрын
Thank You! Video description has link to download the solution file (which includes the App). Its been a while I did this, so I don't exactly remember the Select All code.
@FullMoOoNs-hp6nq
9 ай бұрын
Thanks alot.. How to add comment box for each record when changing the status?
@RezaDorrani
9 ай бұрын
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
@FullMoOoNs-hp6nq
9 ай бұрын
Thanks alot for your reply. I will do post a question there :) @@RezaDorrani
@srilaxmigrao2734
2 жыл бұрын
Hi, very informative video. Just one query. What is the formula for check all?
@RezaDorrani
2 жыл бұрын
I showcased the check all feature steps in a different video. Here is the link kzitem.info/news/bejne/sWyv132mo5-Bpag
@srilaxmigrao2734
2 жыл бұрын
@@RezaDorrani thank you so much
@richardbird3058
3 жыл бұрын
Outstanding Reza... please continue making these videos as they are pure gold
@RezaDorrani
3 жыл бұрын
Thank you Richard. I will keep trying my best. If you have any suggestions do let me know.
@such1
3 жыл бұрын
Reza, is it possible to automatic save collection to source when collection has certain ( ~10) records? I meant no button to press for update, when collection reaches to 10 records, it gets saved to source.
@RezaDorrani
3 жыл бұрын
In this video I auto save based on a timer - kzitem.info/news/bejne/mX9mtqiVcXtnnm0 You can easily check the number of records in a collection and push the updates. CountRows(collection)=10
@stassolan
3 жыл бұрын
Hey Reza. Thank you for the great video. Can you please explain how did you create the "check all" button? No solution that i found worked for me.
@RezaDorrani
3 жыл бұрын
Thank You. Video description has link to download the solution file. It includes the App and all the code.
@mjolnir313
Жыл бұрын
Hi Reza, thanks for sharing your expertise on powerapps with the community! Your videos are tremendous help when I was creating my app. But I have a question. Is it possible to do a bulk create from canvas app to dataverse table? I tried doing a patch from a collection to dataverse table but it has a few errors such as "Patch function has invalid arguments" and "Name isn't valid. Description isn't recognized." Your help would be appreciated. Thanks!
@RezaDorrani
Жыл бұрын
Video shows how it works with Dataverse as well. I will have to look at your App in action to provide guidance. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@shreenikascreation7340
3 жыл бұрын
Hi Reza, Thank you for the Video, this gives a lot of information together to learn. I have implemented this in my Project work using SharePoint online everything is working but in one case - " I selected the records from Gallery, Every time I have selected more than two records but When I click on delete only 2 records being deleted rest selected records remain their in the gallery", Please suggest if any solution for this. Many Thanks in advance.
@RezaDorrani
3 жыл бұрын
When u select records, then must be going into collection. Check if it has all selected records. It would be tough to guess what your issue is here on chat. I will recommend you post your issue with screenshots on the forums at powerusers.microsoft.com
@tenisviejos
3 жыл бұрын
Reza, this is a godsend. It's brilliant how much time and performance you get by doing things the proper way.
@RezaDorrani
3 жыл бұрын
Its all about the performance. Thanks for watching.
@abdoelwanabi8553
3 жыл бұрын
Hi, Great video. Is it possible to get the app in another form than a solution. Within mine company imported solutions are not allowed. Thanks in advance
@RezaDorrani
3 жыл бұрын
Solution includes the supporting Tables in Dataverse which the App uses. Try creating a dev tenant for Office 365 and import the solution in there.
@rashidkhalid2010
2 жыл бұрын
Thanks so much Reza for a great tutorial!!! This is going to help tremendously. I have a follow up question though. My 'OnCheck' formula does not add records to the collection when I select all records by clicking on the 'Check All' button. It works fine when I check each box inside the gallery. Any thoughts? I'll greatly appreciate it. Thanks again! :-)
@RezaDorrani
2 жыл бұрын
You are most welcome. Check kzitem.info/news/bejne/sWyv132mo5-Bpag for step by step explanation of the check all feature.
@ricardoirineo192
3 жыл бұрын
For reference, if someone wants to use the ID of added items in this method, you do need to include the ID column in your collection, otherwise the ID won't be present in the returning collection. You can use Blank() as the value to add new items, the Patch return collection will include the correct ID value then.
@RezaDorrani
3 жыл бұрын
Thanks for sharing!
@chuatrum17
3 жыл бұрын
Can you please be more specific though?will the Adding the primary action make it update instead of creating new item? I want to duplicate the item with pre-defined values for primary key. Can you give me an advice?
@diogo9610
Жыл бұрын
You're the best Reza
@RezaDorrani
Жыл бұрын
Thank You 😊
@farmanalishah8836
2 жыл бұрын
Thank you, Reza, for another great video. I have dataverse for teams app and I want to duplicate entries. can we use the same method to copy records in dataverse for teams?
@RezaDorrani
2 жыл бұрын
Yes you can!
@futuresick100
3 жыл бұрын
Hi Reza. You reference the variable "varFilters" but you don't show where and how it's set. Could you please explain? Thanks for all the great learning content.
@RezaDorrani
3 жыл бұрын
Video description has link to download the entire solution file. You can check the code base there.
@morygold
3 жыл бұрын
Great video as usual, when I am trying to import the solution as the canvas app, it gives an error (Import canvas app created outside of a solution into this environment. Apps created in a solution can be imported under Solutions) , any ideas for me , i am just a beginner
@RezaDorrani
3 жыл бұрын
You have to upload the zip file as a solution under the solutions tab
@allanlee2935
3 жыл бұрын
Hi Reza, a quick question for you: can we do this to SharePoint list? Thanks.
@RezaDorrani
3 жыл бұрын
Yes. I have done that in a project of mine. Key is to ensure your collection schema matches your list schema.
@crmuser-ij4xt
3 жыл бұрын
Reza thank you for the detailed explanation. I am stuck when i am trying to update dataverse with Lookup values. It works for update gallery existing records but cannot insert ForAll( Filter( Gallery5.AllItems, Toggle2_1.Value = true ), Patch( , ThisRecord, { :ThisRecord., EmployeeId: ComboBox3.Selected } ) )
@RezaDorrani
3 жыл бұрын
Glad it was helpful!
@mayalejandroboteroquintero1521
3 жыл бұрын
Hi Reza, thanks a lot for sharing your knowledge in that way! Incredible and amazing method that you found (or create!) instead 'ForAll' to perform the bulk actions... I have a question: why does the Patch() function work with the collection if it expects a record? and in the same way, why does Patch() function update only three columns of the data source when the three columns collection is included as argument? Shouldn't be sent the data of the rest of columns like Defaulst()?... How does it work?... Thanks again!
@RezaDorrani
3 жыл бұрын
The answer is in the documentation - docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-patch Patch can do a lot more than just adding or updating a record.
@evelynm2770
3 жыл бұрын
Hi Reza thank you for this video, the difference in performance using this method is quite amazing! Would you know if this method is limited to a certain number of rows? When I patch 50 rows, it uploads almost instantly, but if I patch 60 rows it takes 5 minutes. Just wondering if this is expected behaviour
@RezaDorrani
3 жыл бұрын
It has to do with the threshold limits for the connector. You can make x calls per connector in a 60 sec duration. I'm guessing 50 might be the limit based on the connector your are using.
@ryanbond7144
3 жыл бұрын
Thank you Reza, another excellent video. In the past I have used Collect(Datasource, collection) instead of Patch(Datasource, Collection) for new items. What will the difference be?
@RezaDorrani
3 жыл бұрын
It should work the same.
@ankushjain4128
2 жыл бұрын
oh waaow ..this technique help alot .Thanks so much Reza for a great tutorial
@RezaDorrani
2 жыл бұрын
Glad it was helpful!
@bellam2413
2 жыл бұрын
Thank you so much!
@RezaDorrani
2 жыл бұрын
Thanks for watching
@klebersonromero9819
2 жыл бұрын
Thanks for the excellent Video!
@RezaDorrani
2 жыл бұрын
Your most welcome
@saxhigh
3 жыл бұрын
Exactly what i needed to see right now. Thanks Reza. Official doc's are not covering these scenarios and even the blog you shared doesn't go beyond the speed aspects. Shame documentation or blogs aren't more available.
@RezaDorrani
3 жыл бұрын
Thanks David. Sometimes the docs do not represent the true capabilities of a particular feature. I feel the bulk update technique using collections is a gem that many are not aware of.
@nivinilvlogs
2 жыл бұрын
Reza, Amazing!! Just Amazing!! Thank you so much!!
@RezaDorrani
2 жыл бұрын
Your most welcome!
@emmanueladebiyi9386
3 жыл бұрын
How did you create the buttons in the gallery looks awesome? do you have a video link ?
@RezaDorrani
3 жыл бұрын
Its a gallery that has the Choices of the Status column. I have not covered exactly this use case in a video. I am working on a video on creating Tabs in Power Apps. The technique is exactly the same as this.
@nicolasramirez2164
3 жыл бұрын
Hi Reza! First off thanks for taking the time of doing these videos. They're amazing. I'm creating my first app using your videos. Honestly, without them, I would've been stuck. I do have a question though. When using this method patching a collection to a Dataverse table, I'm getting the error: The requested source does not support http method 'PATCH'. Do you know what might be going on? Thanks again!! Edit: I'm also getting this error: "Conflicts exist with changes on the server, please reload. Server response: scrubbedSensitiveData". Hope you can give me a hand on this!
@RezaDorrani
3 жыл бұрын
So happy to hear that the videos are providing value. Thank you for watching them. My guess is your schema is not matching the data source and/or your item context is not matching the data source. I did this bulk update approach using a grid as well with dataverse. You can check it here - kzitem.info/news/bejne/mX9mtqiVcXtnnm0
@bhainsley
3 жыл бұрын
Valuable, valuable technique and tutorial. Thank you for your patience in developing this resource.
@RezaDorrani
3 жыл бұрын
Thanks for watching this video. This video took a good amount of time to setup and build.
@lauramay1494
3 жыл бұрын
Hi Reza, (UPDATING COMMENT TO REMOVE QUESTIONS I HAVE FIXED) I had great success using your UpdateIf and Patch solution to bulk update a number of records in PowerApps. I am now attempting to use the same solutions for a Power App embedded into a Power BI report as follows: - Select Records in PowerBI - Show Records in PowerBI Gallery using PowerBIIntegration - I am able to copy a single record and update certain fields needed using the following (great!): Patch( kycPackageXclause, //Dataverse table Defaults(kycPackageXclause), { kycPackageXclause_kycPackage: LookupKYCPackage.Selected, kycPackageXclauseAppliesTo: ChoiceAppliesTo.Selected.Value, kycPackageXclause_kycPackageRelatedParty: LookupRelatedParty.Selected, kycPackageXclause_clause: LookupClause.Selected, kycPackageXclause_jurisdictionStandard: LookupJurisdictionStandard.Selected, kycPackageXclause_listOfValues: LookupListofValues.Selected } ); - I am now trying to achieve similar with multiple records,. - I create a collection from the gallery ClearCollect(KYCxCLCollection, GalleryPowerBIKYC.AllItems) - I use a checkbox within the NewForm to indicate where a field needs to be updated with another value. The UpdateIf statement is being accepted If( CheckboxKycPackage.Value = true, UpdateIf( KYCxCLCollection, true, {'KYC Package Name': LookupKYCPackage_1.Selected.kycPackage} ) ); - I create another collection from the initial collection but drop to IDs to ensure power Apps creates new records. This works fine! ClearCollect(CopyMultipleKYCPackagesCollection, DropColumns(KYCxCLCollection, "crb8f_kycpackagexclauseid", "crb8f_kycpackagexclauseuid")); - But the final Patch statement, recognises the source being my inital CDS table "kycPackageXclause" does not seem to like this new Collection I have just created "CopyMultipleKYCPackagesCollection" I guess because it is multiple records rather than just one? Patch(kycPackageXclause, CopyMultipleKYCPackagesCollection) I can't understand why this works in a straightforward PowerApp, but doesnt work for a PowerApp reading from PowerBI. Any insight MOST HELPFUL, if you can understand everything I have written above!
@RezaDorrani
3 жыл бұрын
Hi Laura, I am working on a project that involves the Power Apps visual in Power BI and executing bulk update. Process is similar to yours. What I do is based on items in the Power BI data set PowerBIIntegration.Data, I create my own collection using forall on PowerBIIntegration.Data. The column column names match the exact names in my data source. To get the base collection definition, I use defaults(Datasource).
@lauramay1494
3 жыл бұрын
@@RezaDorrani Hey Reza, I am trying your proposed method but still failing to get my Updated Collection to save back to the DataSource due to differences between the Record vs Table format of data. This doesnt work...... Patch(collection, Defaults(sourcetable), {SourceField:CollectionField})); I got round this by trying....... Patch(collection, Defaults(sourcetable), { SourceField: LookUp(sourcetable, sourcefield in [@Collection].crb8f_CollectionField) })); If the collection contains 4 records, all with different field content, the Patch will create 4 records, however all 4 records are crreated exactly the same, but the fields are populated based on the first record Power Apps finds in the Collection table (I guess because I am using the Lookup function) This is the best way I can explain, it. Collection Records Record 1: FieldA: 1a FieldB: 1b FieldC: 1c FieldD: Field updated by user so different from source data Record 2: FieldA: 2a FieldB: 2b FieldC: 2c FieldD: Field updated by user so different from source data Record 3: FieldA: 3a FieldB: 3b FieldC: 3c FieldD: Field updated by user so different from source data Record 4: FieldA: 4a FieldB: 4b FieldC: 4c FieldD: Field updated by user so different from source data New Records Required Record 5: FieldA: 1a FieldB: 1b FieldC: 1c FieldD: Field updated by user so different from source data Record 6: FieldA: 2a FieldB: 2b FieldC: 2c FieldD: Field updated by user so different from source data Record 7: FieldA: 3a FieldB: 3b FieldC: 3c FieldD: Field updated by user so different from source data Record 8: FieldA: 4a FieldB: 4b FieldC: 4c FieldD: Field updated by user so different from source data New Records Created Record 5: FieldA: 1a FieldB: 1b FieldC: 1c FieldD: User defined field Record 6: FieldA: 1a FieldB: 1b FieldC: 1c FieldD: User defined field Record 7: FieldA: 1a FieldB: 1b FieldC: 1c FieldD: User defined field Record 8: FieldA: 1a FieldB: 1b FieldC: 1c FieldD: User defined field Do I need to change when I trigger the ForAll loop or something?
@JoStone
3 жыл бұрын
Reza, this is great and helps me to achieve better performance and make a lot of things easier. Thank you so much!
@RezaDorrani
3 жыл бұрын
Great to hear! Thanks for watching.
@debpriyaacharya6250
3 жыл бұрын
Awesome, after struggling with several issues, it is always your video that provides the best solution.
@RezaDorrani
3 жыл бұрын
Glad to help! Thanks for watching.
@lauramay1494
3 жыл бұрын
Hello Reza, I find your videos such a valuable resource. Thank you.
@RezaDorrani
3 жыл бұрын
Appreciate the feedback. Thanks for following.
@Bekesam
2 жыл бұрын
Thanks Reza! Really needed the performance enhancement you provided!!
@RezaDorrani
2 жыл бұрын
Glad to hear that!
@munisamy8770
2 жыл бұрын
Hello Raza, Thank you so much for your videos. It helps me to update the logic you have built in the apps. Can you please share the video link for this end-to-end creation? I need exactly same scenario, I am unable to figure out multiple selection in check box and applying status change for the selected records.
@RezaDorrani
2 жыл бұрын
I do not have an end to end video guide on this. If have tons of independent videos covering various concepts shown in this video. Check my Power Apps playlist.
@munisamy8770
2 жыл бұрын
@@RezaDorrani Thanks Raza, for your reply.
@ramolestoreinc.8175
3 жыл бұрын
Thank you so much Reza also is there a way can you do a video for sales app please
@RezaDorrani
3 жыл бұрын
My videos are more around how to leverage the Power Platform and I have done very few videos around specific Apps
@PoweryourSharePoint
3 жыл бұрын
Hi Reza, your video helps me a lot to progress my current work as it is in the same concept, but one help I will need from you- 1. I have used Nested Gallery for Phases and Tasks and they are working when I update them by selecting multiple checkboxes together but When I do Check All, It is Selecting all but not updating the Values. Please help me out with Check All and Uncheck All. Many Thanks in advance
@RezaDorrani
3 жыл бұрын
Video description has link to download the solution file. (Please note its a solution zip file). You can install the solution and look at the code base.
@PoweryourSharePoint
3 жыл бұрын
@@RezaDorrani Thank you
@ismaelvertiz2871
2 жыл бұрын
Raza, I tried this operation using a "view" from a sql table (we use 3NF for all our tables...so we often create views to drive certain galleries in powerapps to avoid using "Lookup" func within a gallery). The view however, contains the Primary Key and other ID columns so we can easily work with patch functions, forms, etc. For some reason, this seems to only work when the gallery items is the actual table, and not the view. When I hover over the error displayed over the Patch function it reads "Invalid argument type (Table), expecting a Record value instead". Should I be wrapping the collection in a First(Filter( function? Or will this only work when the gallery is connected to the actual table? Thank you in advance for your time! Awesome material!
@RezaDorrani
2 жыл бұрын
Might be a limitation with a view. I have not tried it with views.
@alec734
2 жыл бұрын
Hi! I'm having this issue. Do you remember if you were able to solve it? Thanks
@Youmna-kx8do
3 жыл бұрын
this is bloody amazing, I hope they have super like , thank you
@RezaDorrani
3 жыл бұрын
You are most welcome. Well a super like would be a like and a sub :)
@yoginathbadadale
3 жыл бұрын
Very Useful information Thank you!!
@RezaDorrani
3 жыл бұрын
Glad it was helpful!
@ruksomar
3 жыл бұрын
Thanks Reza great video. How would you implement error checking for the bulk add
@RezaDorrani
3 жыл бұрын
IsEmpty(Errors(DataSource)) if true - then no errors if false - then Errors(DataSource) will give you a table of records with all error details
@ruksomar
3 жыл бұрын
@@RezaDorrani Thanks for your help
@Vihushrihu
2 жыл бұрын
Reza, my search for a clear, conceptual instructor has ended. I have found a great mentor and teacher in you. You are awesome brother !
@RezaDorrani
2 жыл бұрын
Wow, thank you!
@Olivia-vc1wg
Жыл бұрын
Hi Reza, what's your setting of Select All button? I use set(varCheck, true) but it doesn't work for the 2nd option to quickly update all records (1st update option works). Thanks
@RezaDorrani
Жыл бұрын
Link to download app is in video description. You can check the code logic in there.
@awimanu1006
3 жыл бұрын
Reza, superb video. Thank you very much !
@RezaDorrani
3 жыл бұрын
Glad you liked it!
@365g
3 жыл бұрын
Hi Reza - Another great video and was just dipping back into it to aid bulk updates as part of a doc management app I am building. I am noticing when I try to patch the entire collection following an update to a people field in the collection, the Patch formula doesn't like it when I try with just the collection. When I modify the formula to also include the column name i.e. Patch(source, collection.peoplecolumnname), the error disappears, but the patch doesn't work. Do you know if there are limitations with patching a full collection to a doc library and / or with people columns?
@RezaDorrani
3 жыл бұрын
I have not tried with Person type column. Person type columns require a peculiar format while Patching which I had blogged about. Give this a try and let me know - www.rezadorrani.com/index.php/2020/05/04/power-apps-patch-function-with-sharepoint/
@365g
3 жыл бұрын
@@RezaDorrani Cheers for the reply. I have updated the collection using the required format (i.e. claims..etc etc) and that update works fine. It's only when I try to do the bulk patch of newly updated collection to data source that it goes a bit funny. Will keep digging away here, but yeah it must be to do with the people column format. Cheers
@Flinsenberger101
3 жыл бұрын
Thank you, this was extremely helpful!
@RezaDorrani
3 жыл бұрын
You're very welcome!
@arigesandeep
2 жыл бұрын
In collection we have Existing records and New Records added from PowerApps Screen. Now we want to do Bulk update for collection having exisiting and new records. How to do that?
@RezaDorrani
2 жыл бұрын
As long as the primary column of table is present and has a matching value in database, it will update item else create item.
@ffhunter9269
10 ай бұрын
Hi Reza, thanks for your sharing! I was wondering how did you set the select all button? I tried " set(variable, true)" on check but the colupdate could not collect data
@RezaDorrani
10 ай бұрын
It has been a long while since I did this video and hence do not remember the specifics. Video description has link to download solution.
@gautamdas1267
3 жыл бұрын
Hi Reza, I am working with sharepoint list where patch function for update not working. Patch(listNm, colDataToPatch) is throwing error as it is expecting 3 parameters. How to make it work ?
@RezaDorrani
3 жыл бұрын
Would have to look at your App to provide any direction. I would recommend you post your issue with screenshots on the forum - powerusers.microsoft.com/
@vishwachaitanya9221
Жыл бұрын
Hi dorrani, I need your help I have a single entry field like engine type drop-down and engine name input text , date etc are single entry fields , I have multiple entries also . Like reson, category, details etc. I want to save the data into excel , i already uploaded the excel into SharePoint. I want output like this Engtype engno date category details. reso A. 1. 20/2/23. C1. Eng fail r1 A. 1. 20/2/23. C2. Eng repair r3 A. 1. 20/2/23. C3 Startingprb r8 First three fields are single entry remaining multiple entries
@RezaDorrani
Жыл бұрын
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
@juancamilopalacioospina1281
Жыл бұрын
Reza, Currently I have a big issue with the patch function. I use it for update +200 records every day, but sometimes the function doesnt update all the records and it doesnt show me error about it. Do you know what is happening in that escenary?
@RezaDorrani
Жыл бұрын
I have not come across this issue hence not sure. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@revanerraboina9872
2 жыл бұрын
I have learnt a lot from your videos more than I have learnt in my 4 years of B.E... Reza, could you please create a video on how to create the view that is being presented in this video with the drop downs and buttons?
@RezaDorrani
2 жыл бұрын
Thanks Revan. I have a video on the view and dropdown filters with buttons - kzitem.info/news/bejne/pKtu1nilb4mhhX4
@revanerraboina9872
2 жыл бұрын
@@RezaDorrani Thank you Reza. Have a good day!
@saratchandra7388
3 жыл бұрын
Hi Reza ,How to reset checkbox inside gallery once bulk update happens? Not able to reset checkbox inside gallery as it is not creating collection and bulk update is also not happening. Could you please provide workaround.Appreciate your response.
@RezaDorrani
3 жыл бұрын
Just empty the collection. If bulk update is not happening, then there must be some error in your case. Video description has link to download solution file. I will recommend you post your issue on forums to further deep dive into your issue - powerusers.microsoft.com/
@majamller3589
2 жыл бұрын
Hi. Thank you for this really great turtorial! A follow up question: If a user uses the 'check all' function and afterwards wants to uncheck a few options (Example: lets say that there are 30 records and the user wants to check all except 2 items), this is not updated in the collection (Example: the collection still contains 30 records). Is it possible to change this?
@RezaDorrani
2 жыл бұрын
Logic would need to be changed. When all is checked, then add all items to collection so that when an item is unchecked it is removed from the collection.
@majamller3589
2 жыл бұрын
@@RezaDorrani Thanks for your reply! I am trying to do the bulk update. However, the value is not updated in dataverse. I have tried with different records. Do you have a suggestion why it is not patching? The 'update x records' indicates that there is a record in the collection. UpdateIf( ColUpdates; true; { 'Leverancegodkendelse retur': DatePicker_leverance.Value } );; Patch( Salgsobjekter; ColUpdates );; Notify( "Records Updated Successfully"; NotificationType.Success );; Clear(ColUpdates);; Set( varBulkUpdate; false );;Set(varCheckSelect;false)
@RezaDorrani
2 жыл бұрын
@@majamller3589 Difficult to provide guidance here on chat without looking at your scenario in action. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@SachinPatil-bz3ku
Жыл бұрын
Hi Reza I am trying to update my share point list in bulk using forall but it’s update only first record looks everything ok is that because multiple conditions used in lookup while patching. I used three conditions
@RezaDorrani
Жыл бұрын
Should not be the case. I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@harinathreddy3614
10 ай бұрын
Rexa i have used the same function to update my SharePoint list but it's giving me network error field is only read only.can you please help me out
@RezaDorrani
10 ай бұрын
Hi Harinath, I have not come across the mentioned issue and hence not sure what the reason for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@limychelseafc
Жыл бұрын
Hi Reza, thanks for the great video, I believe UpdateIf is not delegable, is there a workaround to remove multiple items that meet conditions in a delegable way?
@RezaDorrani
Жыл бұрын
Since we are working with collections, we need not worry about delegation. User will select items from gallery which is delegable and we are adding it to collection to update.
@saratchandra7388
3 жыл бұрын
Hi Reza is it possible to patch bulk update with out checkbox we want to update only records where combobox and textbox is filled against each record .Appreciate your answer.
@RezaDorrani
3 жыл бұрын
Possible. By querying items in the gallery matching your criteria and accordingly creating collection to Patch.
@kanwalsaini9717
3 жыл бұрын
Hi Reza, Good evening . I want to understand the way of creating bulk new records into sharepoint with single button in power app with patch command ?
@RezaDorrani
3 жыл бұрын
This video showcases exactly that. Create a collection, schema should match SP list, remove the primary key column (ID) and then patch the collection.
@lasyalavya7224
Жыл бұрын
Hi Reza, Can we do bulk update in SharePoint list with a condition in Powerapps
@RezaDorrani
Жыл бұрын
Can be done. Filter the collection based on your condition and patch that.
@saratchandra7388
3 жыл бұрын
hi Reza could please write code how to pass check all to check box in gallery and patch and same for unpatch. Appreciate your answer.
So in order to patch the entire collection to a datasource like dataverse, all the columns in the collection have to match all the columns in the datasource(dataverse)?
@RezaDorrani
Жыл бұрын
Yes. Same concept works with other data sources as well.
@WanabY85
3 жыл бұрын
The 'select all' button sets the checkbox in the gallery on true, but the collection does not update. Could you explain me what I do wrong?
@RezaDorrani
3 жыл бұрын
It would be difficult to track the issue in the chat. The description of this video has link to download the sample solution. You can check the exact code in the App.
@sthanleyoliveira5300
3 жыл бұрын
I have the same problem, I could send the code you used here below, because I'm not able to open the solution you put in the link.
@RezaDorrani
3 жыл бұрын
@@sthanleyoliveira5300 I have exported just the App here - github.com/rdorrani/PowerApps/blob/master/BulkUpdates-CDS_20210407173055.zip Try and see if this works. This is best I can do at the moment.
@gustavomonne4921
3 жыл бұрын
Great video as always Reza. Will you address on a future video, inline editing on the gallery?
@RezaDorrani
3 жыл бұрын
I like your suggestion and I will surely add it to my backlog.
@RezaDorrani
3 жыл бұрын
Yes and here it is - kzitem.info/news/bejne/mX9mtqiVcXtnnm0
@arlequin71
3 жыл бұрын
Hi Reza, really great demo video. I would be totally willing to pay for a course taught by you. Just one question... i tried to import both Dataverse and CSD Bulkupdated files on my environment with no success. The firs one was not able to be imported and in the second one Task table has no data. Do you have any tip to solve it?. Thanks a lot in advance. Regards.
@RezaDorrani
3 жыл бұрын
Solution imports do not contain data. So empty task table is as expected. What error are you getting while importing? You only need to import the solution file github.com/rdorrani/PowerApps/blob/master/BulkUpdatesDataverse_1_0_0_4.zip
@arlequin71
3 жыл бұрын
@@RezaDorrani Thanks... finally i could import as solution with no data. I would like to replicate you example so i really appreciate if you could share an excel the data to populate the task table.
@RezaDorrani
3 жыл бұрын
@@arlequin71 I keep updating my data for different use cases. My table hardly has an records now. To add sample data, just go to the Table in Dataverse, click edit in excel, and add your own sample data in there.
@ehabatme5324
3 жыл бұрын
Great Video. Bulk operation is a must activity in PowerApps
@RezaDorrani
3 жыл бұрын
Thank you. Let’s do bulk operations the right way :)
@RezaDorrani
3 жыл бұрын
And thank you for suggesting the topic. Going by the initial response, this is a hot topic. Keep the suggestions flowing.
@rosariofalero9858
2 жыл бұрын
Thank you so much Reza, you are such a great teacher! Is is possible to use these methods to update the user to an empty or blank value for Sharepoint?
@RezaDorrani
2 жыл бұрын
Thank You. Possible to empty values. Here is the technique kzitem.info/news/bejne/x51jmqKrmJOefX4
@rosariofalero9858
2 жыл бұрын
@@RezaDorrani Thanks! Would I have to hardcode the empty value in the combobox? Using distinct does not give me an empty value.
@RezaDorrani
2 жыл бұрын
@@rosariofalero9858 Yes, based on your scenario. I will recommend to post your query with screenshots on the forums at powerusers.microsoft.com
@synkventures
3 жыл бұрын
Great video and thanks for explaining in details
@RezaDorrani
3 жыл бұрын
Most welcome and thanks for watching
@upputuriyamini3121
3 жыл бұрын
Hi Reza, I Need help to slove one scenario, I have a collection it have multiple records and some records have attachment and some récord doesn't have attachment How i save and update all that above data in to sharepoint list. Please help me to slove this scenario.
@RezaDorrani
3 жыл бұрын
Collections with attachments cannot be Patched to SharePoint using this technique. Patch does not support attachments.
@jray1429
2 жыл бұрын
Reza, I’m using Sharepoint and I’m wanting to take a value in field 1 and duplicate that value into field 2 for each record. Each record will have a unique value in field 1, so am I still able to use the UpdateIf since it’s not an across the board all having a static value for all of them. Thanks for your work!
@RezaDorrani
2 жыл бұрын
Thanks for watching
@jray1429
2 жыл бұрын
@@RezaDorrani sorry Reza…Part of that was a question…Is UpdateIf a good method to use in the situation I described?
@RezaDorrani
2 жыл бұрын
@@jray1429 Yes.
@jray1429
2 жыл бұрын
@@RezaDorrani I tried it and conquered!! Thank you, you’ve helped me multiple times - In multiple videos
@nohelsolares3328
Жыл бұрын
Hello thank you for you help, when I try copy, field id is required
@RezaDorrani
Жыл бұрын
I have not come across this issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@saravanank1994
3 жыл бұрын
Hi, I am using SQL database, kindly help me the patch code
@RezaDorrani
3 жыл бұрын
Hi, for that I would have to see your code and screenshots and debug. I will recommend you post your issue with screenshots on the forums at powerusers.microsoft.com/
@Johanvanderschelling
2 жыл бұрын
Superb video Reza, thanks! I Learned so much from your tutorials. The direct patch from collection to sharepoint list works however as soon as I include a ForAll loop to add items to the collection before the Patch I get an error: Invalid argument type (Table). I expect some of the sharepoint list fields expect a record which I explicitly have to supply when creating new items. I know the whole point here is to avoid the ForAll but in my scenario I do want to add a few records before patching the collection to the sp list. Welcome any suggestions.
@RezaDorrani
2 жыл бұрын
I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@Johanvanderschelling
2 жыл бұрын
@@RezaDorrani Thanks Reza! In the meantime I have been able to resolve the issue.
@RezaDorrani
2 жыл бұрын
@@Johanvanderschelling Great!
@damianmichalczyk4716
2 жыл бұрын
@@Johanvanderschelling i'm struggling with the same problem, could you please share your solution with me
@btoz6237
2 жыл бұрын
Another awesome video Reza!!
@RezaDorrani
2 жыл бұрын
Thanks :)
@fam.giannakisflores7780
Жыл бұрын
Reza good day, if i delete and app is there a way to get it back?? development enviroroment?
@RezaDorrani
Жыл бұрын
Probably environment restore or storing app version prior to deletion
@mrwhammer
Жыл бұрын
This can help a lot for me. Power automate workflows keeps getting triggered two times in a row
@RezaDorrani
Жыл бұрын
I have not come across this issue hence not sure. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@divyagowda2766
2 жыл бұрын
Hi reza and I am facing an issue like how to save the allready existing line items to gallery when we add an new line item it should not be get erased.. Provide an solution for this
@RezaDorrani
2 жыл бұрын
Video description has link to download sample App. Give that a try. As for your issue, I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@unni9942
Жыл бұрын
Hi Reza can you share the code that you use in Button (check all ) to select all the individual text boxes
@RezaDorrani
Жыл бұрын
Video description has link to download sample solution. All the code is in it.
@barnaliroy8703
3 жыл бұрын
Hi...can you tell me what is written in "Check All" btn?
@RezaDorrani
3 жыл бұрын
Video description has link to download the sample solution.
@shaikzuber7945
3 жыл бұрын
Thanks for the video..
@RezaDorrani
3 жыл бұрын
Most welcome
@sanjaysy
3 жыл бұрын
Hello Reza, I'm trying to update records from gallery, It works fine for "CostCode", "Department","Description" , However the moment I start adding "Day1", "Day2", etc Powerapp starts giving me error, "Expecting a record value instead...", can you please help me with this? Here is my formula , Clear(CollToUpdate); ForAll( gallTimesheet.AllItems, Collect( CollToUpdate, { ID: Value(ThisRecord.ID), CostCode: txtCostCode.Text, Department: Value( lblDept.Text), Day1: Value(txtDay1.Text), Day2: Value(txtDay2.Text), Day3: Value(txtDay3.Text), Day4: Value(txtDay4.Text), Day5: Value(txtDay5.Text), Day6: Value(txtDay6.Text), Day7: Value(txtDay7.Text), Description:txtDescri.Text } ) ); Patch(Timesheet,ShowColumns(CollToUpdate, "ID", "CostCode", "Department","Description","Day1"))
@RezaDorrani
3 жыл бұрын
Depends on column types, data source etc. Not possible to provide guidance here on chat without looking at your App and data source. I will recommend you post your issue with screenshots on the forums at powerusers.microsoft.com/
@sanjaysy
3 жыл бұрын
@@RezaDorrani ok, will do that, Thank you!
@kimsalas8197
3 жыл бұрын
Great video. Will this also work with SQL?
@RezaDorrani
3 жыл бұрын
This video was inspired from a project I am working on with SQL :)
@RezaDorrani
3 жыл бұрын
Answer is Yes
@deepikaradhakrishnan01
2 жыл бұрын
Hi I was wondering if there is way to edit and save the person field inside a gallery
@RezaDorrani
2 жыл бұрын
Possible. For that you need to build gallery as an editable grid. I have done a few videos on grids on my channel.
@FadyAnwarS
3 жыл бұрын
This is awesome one. Thanks Reza
@RezaDorrani
3 жыл бұрын
Most welcome and thanks for watching
@Bloatlord101
3 жыл бұрын
Hello, I can’t get that second ”more efficient” way to work at 7:12. At the patch line of the code, the app gives me red and says, that ”createdby: the specified column is read-only and can’t be modified”. As a result, the whole button does not work. Edit: I don’t know what happened, but it suddenly started to work. I changed nothing except perhaps close the editing app. Power Apps bugging again I guess.
@RezaDorrani
3 жыл бұрын
Sometimes when you change the collection schema, Power Apps runtime does not like it.
@Bloatlord101
3 жыл бұрын
@@RezaDorrani Thanks. By the way, I created an app which has also that same Check / Uncheck all button (3:11) which I created with the same code as you. But there is a bug which might be a little difficult to explain but I'll try. Let's pretend we have the same dataset and I would have the same 41 in progress records as at 3:11. If I press Check all, it works like it should and checks all the checkboxes. But If I start Unchecking the checkboxes while the button is showing "Uncheck all" the amount 41 does not change in the "Remove 41 records button". In other words, the collection does not update. So if I uncheck 1 or 2 or 3 checkboxes, it still says "Remove 41 records". But when I check them again, it starts to add them together and the remove button starts to say "Remove 42 records", "Remove 43 records", "Remove 44 records" depending on whether I have checked 1, 2 or 3 boxes (or any arbitrary number of boxes). So in other words, the "OnUncheck" property (Remove(CollectionName,ThisItem) of the checkbox in the gallery does not work when I have selected all the records using the button "check all". Does this happen in your app?
@RezaDorrani
3 жыл бұрын
@@Bloatlord101 yes it does. probably add a radio button where user can either check individually or use the bulk check, uncheck feature.
@Bloatlord101
3 жыл бұрын
@@RezaDorrani Alright thanks. I worked around it so that when check all is pressed, the checkboxes become selected but disabled from editing. The user can still select them individually without using the Check all button. Just wondering, do you know what causes that problem? Is it some Power Apps backend bug?
@RezaDorrani
3 жыл бұрын
@@Bloatlord101 Probably something to do with the logic or variable setting part of the code.
@itmesneha
3 жыл бұрын
when i give remove(datasource, collection) it says the second argument has to be a record and it does not work? edit: got it to work another way.
@RezaDorrani
3 жыл бұрын
You know I did face the same issue in a recent project as well. Looks like something must have changed with the remove formula. I got it to work another way too :)
Пікірлер: 423