Great video! How would one use a sort function with an editable grid? It seems that everytime i edit a field the gallery is re-sorted immediately and i have to go search for it to enter the remaining fields?
For that you would need to change the concept. You can connect the grid to a collection. Then onchange of grid patch data to another collection (temp collection). Once all changes are done and user clicks save, then patch the temp collection to data source and reload the grid collection.
@@RezaDorrani Another awesome benefit of using a separate collection to post the changes to in the "OnChange" property of the gallery is that one can now easiliy see which "cells" have been modified by setting the fill property to something like this: If(ThisItem.(ItemName) = Self.Text, White, Red). Awesome stuff!!! TY again!!
You not only designed, but explained perfectly, this entire application in 42 minutes and 49 seconds. Tell me Power Apps is not a great application development platform.
This is one of the best technical "how to" videos I've ever watched. Perfect level of detail and great explanation of the "why" of each step. Thank you!
Hey Reza, thank you for the reply. Do you think there is any other way to accomplish this? Other than using a component? Would a Concatenate of 3 different dropdowns work to write into a Date/Time Field?
I literally don't know what I would do without your videos Reza. You have helped me to start getting PowerApps built and propagated across my company and changed my career path. Can't thank you enough for everything that you do!
15 days ago, I had zero knowledge on Powerapps. I started with Reza's video and truely speaking the way you described each and every situations are really to the point, and clean instructions. You are truely have great knowledge and you know how to pass it to others. Thanks Reza once again for your amazing learning videos..
This is why it is impossible to skip any of your videos. FANTASTIC FANTASTIC FANTASTIC tutorial/master class. Learnt a tonne about functions and functionality that I did not know I even needed to know about. Really incredible content Reza. Thank you. So real-world applicable and an absolute God-send. 🙏🏾
I'm so glad to have come across your video, I was lost in Microsoft purgatory. It seemed like every time I tried to create something I would end up with a headache and about fifty open internet pages. I own a small business and have always tried to push the boundaries. (which isn't hard because sadly most of my competitors are still using pencil and paper. ) I was starting to lose the faith in my company and myself because I knew we could do what I wanted to, but I couldn't get it to work. I spoke with MS and they put me in touch with multiple companies that wanted over 50k to do what I wanted, so I was about to tuck my tail and join the crowd until you finally showed me exactly what I was missing. I have gone back through sites and books and there wasn't a snowball's chance in hell, I would have ever figured it out without coming across your video. Thank you Thank you Thank you, can wait to learn more from you !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Makes me so happy to know the content is making a difference and being appreciated. Thank You for watching the videos. I hope to keep contributing to the best of my abilities.
Hi Reza, this is the BEST Power Apps tutorial I have seen yet. This tutorial covers everything I was looking for and solves so many problems in terms of app speed and writing to the data source as little as possible!! Thank you so much!!
Awesome video Reza. The pace is perfect, and I'm particularly pleased that there is no "fluff" in the Video, everything is to the point. You're definitely the "go to" guy for PowerApps and Power Automate content.
Wow! I’m so impressed, this solves SO many of my user requests. Thanks SO much!!! Now if I can figure out how to filter on different columns like in Excel, that would be fantastic!
Thanks Reza! I was starting from scratch before christmas with powerapp with none/less IT Background. Your tutorials helped me a lot. Keep on doing such great videos!!!
Wow, it is really great, I just started watching SharePoint list videos, your video is really very informative and good to know these features, please do post video like this. Thanks
Fantastic video Reza, great work! Really comprehensive video, keep up the good work. Being a newbie I only got one minor issue which I managed to resolve, if anyone else faces this, its on the entering of values to a number field in sharepoint, it's worth a mention if it's a number format simply include value(field.Text) which will resolve the error.
@@RezaDorrani Thanks Reza, I had another business issue you may be able to help with. Basically, I have 4 textboxes (one for each quarter of the year) and a Total text box for the year. I was wondering how you can get the total text box to sum the value entered in each of the four boxes so that it totals automatically and populates the SharePoint list with the total of what has been entered when the user submits?
@@Reviews365 Use the CountRows function. I do not have a specific video on this scenario. Try giving it a shot and in case of issues, post your query with screenshots on forums at powerusers.microsoft.com/
First, smash that like button and comment, Even UA-cam likes Reza's content so it transcribes each word correctly while transcribing Hollywood's movie and native UA-camrs English in some gibberish language 😄🙇. Very helpful for international non-English speakers .
Hi Reza, this is fantastic👌 you have packed a lot of content in 42 minutes and I watched this for over 6 hours….I’m almost there 😅. Thank you for providing the how and the why!
@@RezaDorrani 😅I’m done! My issue with patching is due to a metadata field that allows the creation of new terms by the user. I’ve searched but can’t find whether this is supported or not. I would appreciate your comment on this! Thanks again for such an amazing videos!
@@olgamelo4416 Not sure about managed metadata fields. They are more complicated to handle in Power Apps. Check ua-cam.com/users/AudrieGordon She did a few videos on managed metadata columns.
Certainly the best video I've seen, and used I might add, on editable grid. As a bonus you added the option for adding a way to bulk-edit the records which was a nice touch, or very helpful in providing this requirement. You have some great videos that have enhanced what I already have, and have given me ideas for creating additional features to my existing apps. Thanks for the great videos and you now have another subscriber.
Reza you are my hero! Thanks a milion for your helpful videos! You have a solution to all my questions on Power App and as a beginner it is easy to follow you! Great pace and reeeeeeaaaaally useful explanations on why each step is needed. Simply great! Thank you!
Reza, this is just brilliant. You have a knack for explaining complex scenarios in a simple manner. What an asset you are to the community. Thank you. Question: would there be an easy way to make this grid functionality reusable across multiple canvas apps? Perhaps as a component? I'm thinking it would be amazing if you could built the grid functionality once and then to reuse it across multiple apps, just supply it with the data source and bam all the columns and functionality are created automatically. How would one go about doing that?
Thanks for this video Reza, you really break down every detail of building powerapps so well. Just 2 questions pls: 1) if I have an ID and Attachments header, what would be the Default/DefaultSelectedItems input function (15:27)? Similarly, when creating the Patch, what would the functions for ID and attachments be? Thank you!!
Great informative video Reza! I truly appreciate the effort you put in to create such an excellent content as I can find everything what I can think of about Grids behaviour! Eagerly waiting for 2nd part of the video. Thanks a lot for sharing information 🙏
This was AWESOME! Perfect pace , explanation, and details. I know this is a bit old but I just stumbled across it. I put it into one of my apps and the only issue I have is that my controls in the grid are mostly text boxes and tabbing between them isn't happy. I have to click twice in the box to be able to add/edit. I suspect that has something to do with the container and the onchange but this was a super cool video!
@@davidtimm4382 I believe it is at you say, OnChange fires when tabbing to next control, the new value gets loaded to the control where the change happened, and powerapps loses focus of what you were tabbing to. something like that. I believe i saw a comment here somewhere about a workaround where you use two collections. One to display values, one to apply the changes... have not got it working yet myself tho.
Hi Reza, brilliant and amazingly simple approach for complicated task shown here, one of best tutorials I have seen for Powerapps. I tried to apply this for my case but I am running across one issue, for some reason the gallery is generating half empty row duplicates when grid screen is shown. Do you know what might be the issue?
Thanks Roman. I believe if you save your App, close browser and then reopen app to edit, it should solve the problem. Video description includes link to download sample App as well.
@@RezaDorrani Hey Reza. I know I'm a little late to the game as this was recorded a couple years ago, but I've just recently began my PowerApps journey. After 26 minutes in, I'm having issues and wanted to look at the App to see if it's just me. However, the App does not appear to be available when I click on the link. The ISSUE: Network error when using update function. The specified column is read only and can't be modified. Thanks for any help you can provide.
Awesome video Reza, well presented & great content. Helped me spin up a form in no time! Question : I have built an editable grid like yours (7 columns - 2 drop downs & 5 text boxes) however I am finding that after I edit a column and click on the next column I need to click on it twice - always. I have added the OnChange for each control to Select(Parent), and the gal onselect does the patch to the collection. Is there a setting somewhere that needs to be changed to allow the target column to receive the focus on a single click rather than clicking twice?
Workaround is to have 2 collections. colGridData is the collection you bind to the grid (items property). OnChange of grid values you update a different collection (colgriddatatemp). Once changes are saved, you patch colgriddatatemp to the data source and then reload colgriddata.
Workaround is to have 2 collections. colGridData is the collection you bind to the grid (items property). OnChange of grid values you update a different collection (colgriddatatemp). Once changes are saved, you patch colgriddatatemp to the data source and then reload colgriddata.
Hi Reza. Love all of your videos. I've learnt everything about powerapps from you since last 1 month and currently working on a POC. In this video at 17:00 when we set OnChange for all the gallery controls we set Select(Parent). This thing is creating some issue for my app. When i play the app it keeps loading and loading for 1-2 minutes and nothing works. Then i tried removing the OnChange code from all controls and it stopped happening. I have 200+ records in my SharePoint list. Is this because i have huge data its loading so much? Also i am getting errors inside the patch function OnSelect of gallery 17:10 "The type of this argument 'field_4' does not match the expected type "text". Found type 'record'." My column name is "Support group" in SharePoint list. I don't know why it says field 4 here. This issue is with all drop-down control. I found a solution online which says. - 'Support group': Group.Selected.'Support group' After adding the.'support group' in the end the error goes away but In this video you never used such syntax. Do you have any resources i can refer to? And i am still confused why some column names on my collection is named as Foeld1.2.4 etc instead of the real column name. Sorry for the long message but im really stuck here for days. Thanks in advance ♥️
Thanks for watching & liking the videos. Video description has link to download sample App. There is a known bug with the comb box control. Replace it with drop down control in grid. As for your issue(s), 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
This is amazing. Thank you so much Reza. I saw another comment saying that your video's have changed their career path, and this is true for me also. I'm now teaching our own small group of citizen developers and if I find anything I don't know, I always search your videos first. I feel like getting a custom coffee cup with "Reza is my hero". You should sell them! I'd buy one! 😀
So happy to hear this! You are doing good work by teaching other citizen developers Fleur. Wish you all the best! As long as I am a hero in people’s hearts, I am happy 😊
Very good video , the only way to get an editable grid on a canvas app pointing to a SharePoiint list . Very valuable , could not have developed that myself from scratch !
Did not think of copying a datacard control to get the lookup i wanted with the data i needed in an editable grid via gallery. :D Great tutorial, the results of this tutorial are a cut above the rest.
This is really a very good Tutorial where the video has been covered with through . Finally So much of content in just one video to learn implement and apply . I solemnly thank you for such a deep dive explination and I know the amount of work it would had taken to cover this whole topic in just 42 mins .
Glad to hear that! I did spend a lot of effort in this video. The original video recording was around 2 hrs. and 15 mins. I did a rehearsal prior to recording the video and built everything live on the fly.
This is awesome Reza. I have been waiting for editable grid from long time. You are making us feel everything is possible with Power Apps. Great job as always.
Hmmm with Reza the boring SP world is dynamically converting into exciting workplace & fun. I'm now getting addicted to the PP because of Reza's teaching style, Ain't boring or complicated. Rather fun and enticing to learn more. ...
Bets of luck. Video description has link to download sample App. Give that a try. Also there is a bug with combo box control so make sure to replace it with drop down control.
@@RezaDorrani Yes, I found that yesterday. Something about not being available for evaluation? Also, can you explain how you can move things freely around in your header? I have just tried this and I am unable to resize or move anything?
Adding to this point so can we copy these line of items into another screen ? Let’s say we have a main gallery which stores some key field of these line items and we have the copy icon on the gallery so when we click on the copy it may navigate to a new screen which shows the same line items ? Is this scenario possible . Can we use a condition in the items property of the gallery control ?
Reza this is so powerful great pace and quality of instruction - Right at the end of the video you showcased a 'second version of the grid with the ability to update multiple records with a priority' where can I check this version out?
Thanks again Reza, I also noted that towards the end of the video around 41 minutes, that you utilized some options of using the button to bulk copy or delete the collections. So, I was wondering if there are videos that showcase how those options were programmed. Regards
Wow, I truly appreciate your help Raza your the best always bringing something useful and interesting thanks Raza, also when will you show us or share with us the same app other version you demonstrated on the ending the video, the one you update with checkbox and delete only after you have checked that's so nice thank you
Cannot thank you enough for these videos, the way you explain and make it easy to understand is just amazing…. I have a question once I do changes using this editable grid app, will I be able to see those changes, updates and copied items in the original share point list, I guess the answer is yes but would like to confirm 🙂
Thank You for watching and liking my videos. Answer is Yes. I even have a bulk updates based video on similar lines. Check ua-cam.com/video/P6yqIpjmPrs/v-deo.html
@@RezaDorrani thank you for responding, im trying to display a couple of columns from my sharepoints that contains formula (concanate and sums) but the option Default or Default Selected items does not show up for these, do you know which property i can use?
@@caro1853 Not sure about that. Something that I would have to try out to provide guidance. I will recommend checking on the forums at powerusers.microsoft.com/
Reza - Thank you so much for the clear and concise details. You will have to forgive though, as I have more than likely missed something that is important. I have recreated an editable responsive grid for prototyping to a customer and find that it is not updating my SharePoint list. In brief, it retrieves the correct data when the screen loads, it allows me to enter a data change, and when clicking Exit grid view it appears to do the update but actually does not. I verify that in the SP List. Oddly, the Load button does show activity when the the app leaves the grid view, so i am not sure where my disconnect is. Any thoughts would be appreciated.
Video description has link to download sample app. 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
Thank You. Downloaded zip will be after version 2. I have bulk features video planned with this grid. You can select records with checkbox or check all and bulk update, copy, delete and create.
Hello Reza, thank you for an incredibly informative video. I have used it to create an app and it works as expected. One thing is I would like to request is if you could tell me the best way to show all the datasource records on start of the app and how to clear the filter so all records are shown again when exiting editing. Thanking you in advance.
Great video Reza! I really appreciate your approach to solving the various challenges with data collection. Would you recommend this method for a multiuser environment where someone maybe editing a record at another workstation?
Multiuser can work. For that though a lot more work is required. When patching, you would need to check if record was updated by another user, if yes then do not patch and notify user about changes.
Great video Reza !! Informative ! I implemented the same step by step , one thing am noticing is whenever the app loads for the first time , it creates duplicate record of first row . It would be really helpful if u could help me resolve this
Thank you Reza for positing Grid view tutorial. It is very useful and infact step by step guidance helps us learn faster. Keep posting more videos. One question i do have is, in View mode if I want to highlight each row as I move my mouse pointer how to enable it. In Edit mode when I move my mouse over each row it gets highlighted whereas in View mode it is not working.. Pls advice.
It's been a while I did this. I believe in view mode, it does not show that. There must be a way of putting like some rectangle shape over controls and highlighting it or something. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@@RezaDorrani Can we create hierarchies in our grid columns, like the ones we have in Power BI Matrix visuals? We have the small +/- symbols before them and they expand when we go for + and contract when we select - .
Hi Reza - sorry to disturb you again. I am working with some calculations here and everything works perfectly so far, all thanks to you. The only issue that I am facing is that once I change an independent variable using Power Apps, other visuals show the change in derived calculations once I refresh from Power BI Desktop but the Power App Grid only shows the changed value of the independent variable - the derived calculations don't change in the Power Apps Grid. Everything is changing correctly at the backend - but not in Power Apps Grid. Only the value that we change is changing in Power Apps, associated calculations are not. Is there some way around this ? I hope I'm able to get my point across. As always, thank you so much for everything.
Love the video! Great Stuff in using collections and mass updating. One problem I encountered was in trying to add the description. It just would not update. I was care to set the OnChange Event to Select(Parent). I just can't see why it doesn't update.
Morning Reza, another outstanding video, I'm having great fun recreating it! I wonder if you can help though, upon hitting 'copy' in play mode, it is adding hundreds of new rows. I think I've done everything the same/ can't spot why it might be happening. Your insights would be very welcomed :-). All the best
@@RezaDorrani thank you! For the benefit of anyone else who runs in to this... My combo boxes came from the items I 'borrowed' from an edit form. To swap them: - Select current combo box from gallery in edit mode - COPY formula from the Items property - delete the current combo box - insert drop down - PASTE formula in to drop down items propert - reset X and Width properties to match the header - rename drop down to same name the combo box had (so other previously written formulas continue to work)
Thank you so much for this video.. It was the exact requirement I was looking for and I had it on a platter :) Thanks a lot for your efforts. One quick query what is your current screen width? Can you share the exact dimensions of it?
Such a nice tutorial Reza .. helped me a lot in my task … just one doubt what if don’t want to load data in my grid in any mode edit or view. Just want to insert new record. Where I need to make changes here
I would have to try out your scenario to let you know the steps for changes. You can check to see if item is new or existing based on ID column and accordingly lock the row. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Reza, great video! I don't know if this question has already been answered. The only problem I have with this approach is that when I use the tab key to go to the next label, I have to press the tab key twice. After the first press, the onchange triggers to save/update the item in the collection. I was wondering if you have a solution for this?
There are a few comments on this. Workaround is to have 2 collections. colGridData is the collection you bind to the grid (items property). OnChange of grid values you update a different collection (colgriddatatemp). Once changes are saved, you patcch colgriddatatemp to the data source and then reload colgriddata.
Hi Reza - great video. The new page template for the Header & Footer Layout makes this sort of a pain to try and resize and shape. Other than that, very helpful as always.
Thanks! New page templates use responsive containers. I have also done a newer video on grid with responsive containers. All grid based videos are placed in a playlist on my channel.
Great video! How would one use a sort function with an editable grid? It seems that everytime i edit a field the gallery is re-sorted immediately and i have to go search for it to enter the remaining fields?
For that you would need to change the concept.
You can connect the grid to a collection. Then onchange of grid patch data to another collection (temp collection). Once all changes are done and user clicks save, then patch the temp collection to data source and reload the grid collection.
@@RezaDorrani Genius!! Ty!!
@@RezaDorrani Another awesome benefit of using a separate collection to post the changes to in the "OnChange" property of the gallery is that one can now easiliy see which "cells" have been modified by setting the fill property to something like this: If(ThisItem.(ItemName) = Self.Text, White, Red). Awesome stuff!!! TY again!!
@@hnk5965 + you can have combo box controls in grid :)
@@RezaDorrani Thanks @Reza Dorrani.. new this power app.. will try as advised.
You not only designed, but explained perfectly, this entire application in 42 minutes and 49 seconds. Tell me Power Apps is not a great application development platform.
Thank You Bob. Appreciate the fantastic feedback.
This is one of the best technical "how to" videos I've ever watched. Perfect level of detail and great explanation of the "why" of each step. Thank you!
So glad to heat that. Thank You for watching.
Hey Reza, thank you for the reply. Do you think there is any other way to accomplish this? Other than using a component? Would a Concatenate of 3 different dropdowns work to write into a Date/Time Field?
@@cperry420 Possible! But I have not tried it :)
I literally don't know what I would do without your videos Reza. You have helped me to start getting PowerApps built and propagated across my company and changed my career path. Can't thank you enough for everything that you do!
Awesome! So happy to hear the videos are making a difference.
Thank You for watching & liking the videos.
This is so true!!
15 days ago, I had zero knowledge on Powerapps. I started with Reza's video and truely speaking the way you described each and every situations are really to the point, and clean instructions. You are truely have great knowledge and you know how to pass it to others. Thanks Reza once again for your amazing learning videos..
Thanks so much for your kind words Rohan!
Made my day.
This is GENIUS and you are better at explaining what you're doing than ANYONE else doing tutorials. Thank you SO much for sharing this!
Very happy to hear the feedback.
Thank You Emily.
Non-Coder here. It took me 4 hours to get through this 42 min video. So much value had to take it slow. I will now watch the rest of them. Thanks
Glad to hear you are getting through the complete video. It is packed in with a lot of content. Thank You for watching.
This is why it is impossible to skip any of your videos. FANTASTIC FANTASTIC FANTASTIC tutorial/master class. Learnt a tonne about functions and functionality that I did not know I even needed to know about. Really incredible content Reza. Thank you. So real-world applicable and an absolute God-send. 🙏🏾
Wow, thank you!
I'm so glad to have come across your video, I was lost in Microsoft purgatory. It seemed like every time I tried to create something I would end up with a headache and about fifty open internet pages. I own a small business and have always tried to push the boundaries. (which isn't hard because sadly most of my competitors are still using pencil and paper. ) I was starting to lose the faith in my company and myself because I knew we could do what I wanted to, but I couldn't get it to work. I spoke with MS and they put me in touch with multiple companies that wanted over 50k to do what I wanted, so I was about to tuck my tail and join the crowd until you finally showed me exactly what I was missing. I have gone back through sites and books and there wasn't a snowball's chance in hell, I would have ever figured it out without coming across your video. Thank you Thank you Thank you, can wait to learn more from you !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Makes me so happy to know the content is making a difference and being appreciated.
Thank You for watching the videos. I hope to keep contributing to the best of my abilities.
Doing those in power apps seemed impossible... until today. Thank you Reza!!!
You're most welcome.
It's one of those videos that you watch and stand speechless at the end. Well done
Thanks so much
Hi Reza, this is the BEST Power Apps tutorial I have seen yet. This tutorial covers everything I was looking for and solves so many problems in terms of app speed and writing to the data source as little as possible!! Thank you so much!!
Great to hear! Thank you so much.
Awesome video Reza. The pace is perfect, and I'm particularly pleased that there is no "fluff" in the Video, everything is to the point. You're definitely the "go to" guy for PowerApps and Power Automate content.
Wow! Thank You so much.
When I set out making videos, that was my no 1 goal (no fluff) :)
This is a masterclass! I have improved a lot in PowerApps because of your videos. Thank you, Rezza!
Great to hear!
By watching and implementing the ideas from tutorial your videos, I am learning power platform so easily and I feel confident.
Wonderful! Thank You.
Wow! I’m so impressed, this solves SO many of my user requests. Thanks SO much!!! Now if I can figure out how to filter on different columns like in Excel, that would be fantastic!
Thank You. I did show a couple of filters in the video :)
Thanks Reza!
I was starting from scratch before christmas with powerapp with none/less IT Background. Your tutorials helped me a lot. Keep on doing such great videos!!!
Great to hear!
Thanks so much for watching & liking the videos.
Wow, it is really great, I just started watching SharePoint list videos, your video is really very informative and good to know these features, please do post video like this. Thanks
Great to hear! Thanks for watching.
I finally created this one. Still have to play with the Slider. Overall, you're always amazing. I appreciate you!
You got this! Thanks for watching.
Great, informative video as always. 👍 One downsize of such video format that I can like only once instead of 10 times per each chapter. Kudos to you.
Thank you so much.
Each chapter could have been its own video but I wanted to build a one stop shop for building Grids in Power Apps.
I wish I can hit 👍 10 times too! 😂
make sure you hit the 'like' odd number of times though ;-)
Reza, you’re opening a whole new universe to me. Already impacting my work. Thanks, man, and keep up the great job!
Thank You Euben
Fantastic video Reza, great work! Really comprehensive video, keep up the good work. Being a newbie I only got one minor issue which I managed to resolve, if anyone else faces this, its on the entering of values to a number field in sharepoint, it's worth a mention if it's a number format simply include value(field.Text) which will resolve the error.
Thanks Prakash! Great point on the number format using Value function.
@@RezaDorrani Thanks Reza, I had another business issue you may be able to help with. Basically, I have 4 textboxes (one for each quarter of the year) and a Total text box for the year. I was wondering how you can get the total text box to sum the value entered in each of the four boxes so that it totals automatically and populates the SharePoint list with the total of what has been entered when the user submits?
@@Reviews365 Use the CountRows function. I do not have a specific video on this scenario. Try giving it a shot and in case of issues, post your query with screenshots on forums at powerusers.microsoft.com/
Ha! I ran into that very issue when setting up my own version of this. A quick Google found the answer.
First, smash that like button and comment, Even UA-cam likes Reza's content so it transcribes each word correctly while transcribing Hollywood's movie and native UA-camrs English in some gibberish language 😄🙇. Very helpful for international non-English speakers .
Thank You so much. Happy to know that my speech & language are easy to understand.
Hi Reza, this is fantastic👌
you have packed a lot of content in 42 minutes and I watched this for over 6 hours….I’m almost there 😅. Thank you for providing the how and the why!
Thank You 😊
Wow 6 hours :)
1 tip: there is a known issue with combo box control. Replace it with dropdown.
@@RezaDorrani 😅I’m done! My issue with patching is due to a metadata field that allows the creation of new terms by the user. I’ve searched but can’t find whether this is supported or not. I would appreciate your comment on this! Thanks again for such an amazing videos!
@@olgamelo4416 Not sure about managed metadata fields. They are more complicated to handle in Power Apps. Check ua-cam.com/users/AudrieGordon
She did a few videos on managed metadata columns.
Certainly the best video I've seen, and used I might add, on editable grid. As a bonus you added the option for adding a way to bulk-edit the records which was a nice touch, or very helpful in providing this requirement. You have some great videos that have enhanced what I already have, and have given me ideas for creating additional features to my existing apps. Thanks for the great videos and you now have another subscriber.
Thank You Jose for the appreciation and thanks for the sub
Thank you Reza. This tutorial is really insightful. I can't wait for the second part
Glad to hear that!
2nd part coming soon. I feel it is better than the first :)
@@RezaDorrani anxiously standing by... :D Amazing stuff you have done here!
@@csponge1 Part 2 is live ua-cam.com/video/P6yqIpjmPrs/v-deo.html
Reza you are my hero! Thanks a milion for your helpful videos! You have a solution to all my questions on Power App and as a beginner it is easy to follow you! Great pace and reeeeeeaaaaally useful explanations on why each step is needed. Simply great! Thank you!
Thank You so much for the appreciation!
Reza, this is just brilliant. You have a knack for explaining complex scenarios in a simple manner. What an asset you are to the community. Thank you.
Question: would there be an easy way to make this grid functionality reusable across multiple canvas apps? Perhaps as a component? I'm thinking it would be amazing if you could built the grid functionality once and then to reuse it across multiple apps, just supply it with the data source and bam all the columns and functionality are created automatically. How would one go about doing that?
Thank You.
I was thinking about component as well.
Challenge is the data types & columns, creating controls based on column schema on the fly etc.
Thanks for this video Reza, you really break down every detail of building powerapps so well. Just 2 questions pls: 1) if I have an ID and Attachments header, what would be the Default/DefaultSelectedItems input function (15:27)? Similarly, when creating the Patch, what would the functions for ID and attachments be?
Thank you!!
Attachments is not supported in Patch function.
ID is an inbuilt system column. You cannot specifically Patch it.
Thank you!
Great informative video Reza! I truly appreciate the effort you put in to create such an excellent content as I can find everything what I can think of about Grids behaviour! Eagerly waiting for 2nd part of the video. Thanks a lot for sharing information 🙏
My pleasure!
This was AWESOME! Perfect pace , explanation, and details. I know this is a bit old but I just stumbled across it. I put it into one of my apps and the only issue I have is that my controls in the grid are mostly text boxes and tabbing between them isn't happy. I have to click twice in the box to be able to add/edit. I suspect that has something to do with the container and the onchange but this was a super cool video!
Thanks for watching and liking the video.
@@RezaDorrani again, thanks for the video. Any idea why the tab not behaving and I have to select textboxes twice in the container to enter?
@@davidtimm4382 No idea
@@davidtimm4382 I believe it is at you say, OnChange fires when tabbing to next control, the new value gets loaded to the control where the change happened, and powerapps loses focus of what you were tabbing to. something like that. I believe i saw a comment here somewhere about a workaround where you use two collections. One to display values, one to apply the changes... have not got it working yet myself tho.
Hi Reza, brilliant and amazingly simple approach for complicated task shown here, one of best tutorials I have seen for Powerapps. I tried to apply this for my case but I am running across one issue, for some reason the gallery is generating half empty row duplicates when grid screen is shown. Do you know what might be the issue?
Thanks Roman.
I believe if you save your App, close browser and then reopen app to edit, it should solve the problem.
Video description includes link to download sample App as well.
@@RezaDorrani Hey Reza. I know I'm a little late to the game as this was recorded a couple years ago, but I've just recently began my PowerApps journey. After 26 minutes in, I'm having issues and wanted to look at the App to see if it's just me. However, the App does not appear to be available when I click on the link. The ISSUE: Network error when using update function. The specified column is read only and can't be modified. Thanks for any help you can provide.
@@TrinaLHough The link is to my GitHub repo which is publicly accessible and very much working
@@RezaDorraniThanks so much for the response! I do see it now.
This is great, I've implemented this on one of my lists. I can now direct everyone to use the App over share point. Thanks Reza!
Fantastic! Thank You.
Awesome video Reza, well presented & great content. Helped me spin up a form in no time! Question : I have built an editable grid like yours (7 columns - 2 drop downs & 5 text boxes) however I am finding that after I edit a column and click on the next column I need to click on it twice - always. I have added the OnChange for each control to Select(Parent), and the gal onselect does the patch to the collection. Is there a setting somewhere that needs to be changed to allow the target column to receive the focus on a single click rather than clicking twice?
I am also facing the same issue. Any solution?
Workaround is to have 2 collections. colGridData is the collection you bind to the grid (items property). OnChange of grid values you update a different collection (colgriddatatemp). Once changes are saved, you patch colgriddatatemp to the data source and then reload colgriddata.
Workaround is to have 2 collections. colGridData is the collection you bind to the grid (items property). OnChange of grid values you update a different collection (colgriddatatemp). Once changes are saved, you patch colgriddatatemp to the data source and then reload colgriddata.
@@RezaDorrani Hello Reza, is there a video that explains this workaround or anywhere else i can see an example?
@@rbeltranl I do not have a video on it.
Thank you Reza! You've made PowerApps development fun by covering some of the unchartered waters. Looking forward to more of your tutorials.
Awesome, thank you!
Hi Reza.
Love all of your videos. I've learnt everything about powerapps from you since last 1 month and currently working on a POC.
In this video at 17:00 when we set OnChange for all the gallery controls we set Select(Parent).
This thing is creating some issue for my app. When i play the app it keeps loading and loading for 1-2 minutes and nothing works.
Then i tried removing the OnChange code from all controls and it stopped happening.
I have 200+ records in my SharePoint list. Is this because i have huge data its loading so much?
Also i am getting errors inside the patch function OnSelect of gallery 17:10
"The type of this argument 'field_4' does not match the expected type "text".
Found type 'record'."
My column name is "Support group" in SharePoint list. I don't know why it says field 4 here. This issue is with all drop-down control.
I found a solution online which says. -
'Support group': Group.Selected.'Support group'
After adding the.'support group' in the end the error goes away but In this video you never used such syntax.
Do you have any resources i can refer to? And i am still confused why some column names on my collection is named as Foeld1.2.4 etc instead of the real column name.
Sorry for the long message but im really stuck here for days.
Thanks in advance ♥️
Thanks for watching & liking the videos.
Video description has link to download sample App.
There is a known bug with the comb box control. Replace it with drop down control in grid.
As for your issue(s), 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
I am facing the same issue with records duplication
@@Hbhammad you have to export the updated app from his git Repository. Then study and learn from that app. I did it and it helped me.
Simply the best tutorial I've ever watched.
Congratulations and thank you for your dedication!!
Wow, thank you!
Mixing this tutorial and the newer one with modern controls, I am pretty sure that I can build my grid. Thanks a lot.
Great to hear!
This is amazing. Thank you so much Reza. I saw another comment saying that your video's have changed their career path, and this is true for me also. I'm now teaching our own small group of citizen developers and if I find anything I don't know, I always search your videos first. I feel like getting a custom coffee cup with "Reza is my hero". You should sell them! I'd buy one! 😀
So happy to hear this! You are doing good work by teaching other citizen developers Fleur. Wish you all the best!
As long as I am a hero in people’s hearts, I am happy 😊
Very good video , the only way to get an editable grid on a canvas app pointing to a SharePoiint list . Very valuable , could not have developed that myself from scratch !
Glad it was helpful!
Did not think of copying a datacard control to get the lookup i wanted with the data i needed in an editable grid via gallery. :D
Great tutorial, the results of this tutorial are a cut above the rest.
Great to hear!
This is really a very good Tutorial where the video has been covered with through . Finally So much of content in just one video to learn implement and apply . I solemnly thank you for such a deep dive explination and I know the amount of work it would had taken to cover this whole topic in just 42 mins .
Glad to hear that! I did spend a lot of effort in this video.
The original video recording was around 2 hrs. and 15 mins.
I did a rehearsal prior to recording the video and built everything live on the fly.
So informative Reza. All your videos have always been the GO TO SOURCE for me. Thank you.
Happy to hear that!
Awesome video! Thank you. I also appreciate your delivery method and speaking clearly for me to understand.
Most welcome
Extraordinary! Yet another exemplary video with succinct and clear explanations not only of the how, but just as importantly, the WHY. Top marks Reza.
Wow, thank you so much for the amazing feedback.
Another great video, it is amazing how quickly you can build a CRUD application with PowerApps.
Thanks Matt!
This is awesome Reza. I have been waiting for editable grid from long time. You are making us feel everything is possible with Power Apps. Great job as always.
Great to hear!
Hmmm with Reza the boring SP world is dynamically converting into exciting workplace & fun. I'm now getting addicted to the PP because of Reza's teaching style, Ain't boring or complicated. Rather fun and enticing to learn more. ...
🤩 Thank You so much for the amazing feedback.
I will keep trying my best to provide engaging and quality content.
This video was very helpful. I had a few snagged on Patching a number field back to the SharePoint list, but I solved that problem.
Your most welcome. Video does include a link to download sample App.
This is simply superb and great to see the possibilities with PowerApps. Thanks Reza
My pleasure!
Thanks Reza. Excellent video. Dense with useful information, clear presentation. Bravo. I'm going to implement this and give it a try.
Thank You so much
So useful! I will be trying this out today on a project I am working on. Thank you very much.
Bets of luck. Video description has link to download sample App. Give that a try. Also there is a bug with combo box control so make sure to replace it with drop down control.
@@RezaDorrani Yes, I found that yesterday. Something about not being available for evaluation? Also, can you explain how you can move things freely around in your header? I have just tried this and I am unable to resize or move anything?
@@RezaDorrani Sorry one last thing! How can you 'use' the buttons without previewing the app? You seem to be able to execute the buttons?
@@CarFinanceSimplified I have explained that in video. Try sample app in video description.
@@CarFinanceSimplified Hold the Alt key
This is amazing! I love how you always give us caution about performance hits and use ways to make it better. Thank yoU!
You're so welcome!
Super liked. Another video from which i can "steal" the ideas, best practices and some effective presentation learnings.
Thank You 🙏
excellent video indeed, new techniques, every video you had posted I had learn something new thanks for sharing, keep it up.
Great to hear! A lot more to come.
Copy of the item was amazing ! Thankyou for such informative video 😃
My pleasure 😊
Adding to this point so can we copy these line of items into another screen ? Let’s say we have a main gallery which stores some key field of these line items and we have the copy icon on the gallery so when we click on the copy it may navigate to a new screen which shows the same line items ? Is this scenario possible . Can we use a condition in the items property of the gallery control ?
@@aishwaryagorthi5288 Possible. You can use conditions in gallery items property.
This was so well done! Thank you for sharing your knowledge with us!
Most welcome
Reza this is so powerful great pace and quality of instruction - Right at the end of the video you showcased a 'second version of the grid with the ability to update multiple records with a priority' where can I check this version out?
Thanks Mike.
The bulk update version is here ua-cam.com/video/P6yqIpjmPrs/v-deo.html
Great Video and Content. and the way you explain is really awesome and that is why I don't want to miss any videos.
Happy to hear that!
Reza is king of the power apps.
Thank You so much
Outstanding… ALWAYS OUTSTANDING!!! Thank you Reza!!!🙋🏾♂️
Thanks for listening
Thanks again Reza,
I also noted that towards the end of the video around 41 minutes, that you utilized some options of using the button to bulk copy or delete the collections. So, I was wondering if there are videos that showcase how those options were programmed.
Regards
All videos are on my channel and publicly available :)
Here is the link ua-cam.com/video/P6yqIpjmPrs/v-deo.html
Fantastic video Reza! Thanks for your expertise and coaching with these videos! It is MUCH APPRECIATED!!! :)
Your most welcome.
You are one of the best I have came across thanks for all your good work
Wow, thanks!
Wow, I truly appreciate your help Raza your the best always bringing something useful and interesting thanks Raza, also when will you show us or share with us the same app other version you demonstrated on the ending the video, the one you update with checkbox and delete only after you have checked that's so nice thank you
Thank You.
Version 2 will be out next week.
Make sure to hit the bell icon on my channel so you get notified the moment I post my latest video.
Horizontal scroll & Freeze Pane Effect 👌👌
Thanks You saved lot of time . Waiting for second version
Coming soon
Awesome... You just helped me with an idea for something in my org and yes looking forward for many more videos...Keep them coming...cheers👍
Glad to hear it!
Thank you for this awesome video!
I now have a better idea on how to create a similar solution for creating mass booking through SPO.
Glad it was helpful!
Another great vid by Reza, its been a wonderful experience. Thanks again 👌👌
Most welcome. Thanks for watching this one
No.1 fan here. You really got the POWERapps :)
Thank You 🙏
Cannot thank you enough for these videos, the way you explain and make it easy to understand is just amazing….
I have a question once I do changes using this editable grid app, will I be able to see those changes, updates and copied items in the original share point list, I guess the answer is yes but would like to confirm 🙂
Thank You for watching and liking my videos.
Answer is Yes. I even have a bulk updates based video on similar lines. Check ua-cam.com/video/P6yqIpjmPrs/v-deo.html
@@RezaDorrani thank you for responding, im trying to display a couple of columns from my sharepoints that contains formula (concanate and sums) but the option Default or Default Selected items does not show up for these, do you know which property i can use?
@@caro1853 Not sure about that. Something that I would have to try out to provide guidance. I will recommend checking on the forums at powerusers.microsoft.com/
Very helpful video. Thank you Reza. Looking forward to Part 2
My pleasure! I will be working on bulk update features soon.
Reza - Thank you so much for the clear and concise details. You will have to forgive though, as I have more than likely missed something that is important. I have recreated an editable responsive grid for prototyping to a customer and find that it is not updating my SharePoint list. In brief, it retrieves the correct data when the screen loads, it allows me to enter a data change, and when clicking Exit grid view it appears to do the update but actually does not. I verify that in the SP List. Oddly, the Load button does show activity when the the app leaves the grid view, so i am not sure where my disconnect is. Any thoughts would be appreciated.
Video description has link to download sample app.
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
Great video that summarise many patching issues, love it! Btw When will the download zip of the app be available? Again, Thank you!
Thank You.
Downloaded zip will be after version 2.
I have bulk features video planned with this grid.
You can select records with checkbox or check all and bulk update, copy, delete and create.
@@RezaDorrani Thank you very much
Hello Reza, thank you for an incredibly informative video. I have used it to create an app and it works as expected. One thing is I would like to request is if you could tell me the best way to show all the datasource records on start of the app and how to clear the filter so all records are shown again when exiting editing. Thanking you in advance.
The grid will show all records on start of the App. Since grid loads data from data source.
Filters will be cleared when App starts.
can't thank you enough for these tutorials.
Most welcome
Hi Reza, great video from you - again :) Best wishes from germany, awaiting lots of more videos like this!!!
Thank you! Will do!
Great video and explanation. Really helpful. Thanks Reza as always!
Glad you liked it!
Great video Reza! I really appreciate your approach to solving the various challenges with data collection. Would you recommend this method for a multiuser environment where someone maybe editing a record at another workstation?
Multiuser can work. For that though a lot more work is required. When patching, you would need to check if record was updated by another user, if yes then do not patch and notify user about changes.
Great video Reza !! Informative !
I implemented the same step by step , one thing am noticing is whenever the app loads for the first time , it creates duplicate record of first row .
It would be really helpful if u could help me resolve this
Issue is with the combo box controls (known bug). Replace them with dropdown controls.
Thank you Reza for positing Grid view tutorial. It is very useful and infact step by step guidance helps us learn faster. Keep posting more videos. One question i do have is, in View mode if I want to highlight each row as I move my mouse pointer how to enable it. In Edit mode when I move my mouse over each row it gets highlighted whereas in View mode it is not working.. Pls advice.
It's been a while I did this. I believe in view mode, it does not show that. There must be a way of putting like some rectangle shape over controls and highlighting it or something. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Another awesome video Reza. You’re the best 👍🏼
Thank You
Absolutely awesome! Thank you very much! Do you show how to do the variant seen at the end anywhere?
Thank You.
The variant is in my latest video - ua-cam.com/video/P6yqIpjmPrs/v-deo.html
Another great tutorial. Really enjoyed it. Thanks Reza.
Thanks for watching
Another priceless content. Thank you, Reza !!!
Most welcome
You are simply amazing Reza. Thanks for the wonderful content. May god bless you!
Thank you! You too!
@@RezaDorrani Can we create hierarchies in our grid columns, like the ones we have in Power BI Matrix visuals?
We have the small +/- symbols before them and they expand when we go for + and contract when we select - .
@@apoorvsharma2087 Not an option with these grids.
@@RezaDorrani Thanks Reza. Help much appreciated.
Hi Reza - sorry to disturb you again.
I am working with some calculations here and everything works perfectly so far, all thanks to you.
The only issue that I am facing is that once I change an independent variable using Power Apps, other visuals show the change in derived calculations once I refresh from Power BI Desktop but the Power App Grid only shows the changed value of the independent variable - the derived calculations don't change in the Power Apps Grid.
Everything is changing correctly at the backend - but not in Power Apps Grid. Only the value that we change is changing in Power Apps, associated calculations are not. Is there some way around this ?
I hope I'm able to get my point across.
As always, thank you so much for everything.
Love the video! Great Stuff in using collections and mass updating. One problem I encountered was in trying to add the description. It just would not update. I was care to set the OnChange Event to Select(Parent). I just can't see why it doesn't update.
Thanks!
Im not sure why that would not work in your case.
Amazing Raza and thanks to you for this video. A true great learning experience.
Glad you enjoyed it
Please do next part
video is just awesome great and thanks a ton
Next part link ua-cam.com/video/P6yqIpjmPrs/v-deo.html
Morning Reza, another outstanding video, I'm having great fun recreating it!
I wonder if you can help though, upon hitting 'copy' in play mode, it is adding hundreds of new rows. I think I've done everything the same/ can't spot why it might be happening.
Your insights would be very welcomed :-). All the best
Issue is with combo box control. Delete it and replace it with dropdowns.
@@RezaDorrani thank you!
For the benefit of anyone else who runs in to this...
My combo boxes came from the items I 'borrowed' from an edit form. To swap them:
- Select current combo box from gallery in edit mode
- COPY formula from the Items property
- delete the current combo box
- insert drop down
- PASTE formula in to drop down items propert
- reset X and Width properties to match the header
- rename drop down to same name the combo box had (so other previously written formulas continue to work)
@@jimmydoe1653 Thank You for sharing. Much appreciated.
@@jimmydoe1653 Thanks a ton. I was stuck on this autocreation of new rows for 2 days and you saved me.
Reza, great video. I can't wait for V2 and for the Zip File.
I will be working on it soon.
Once again an amazing video tutorial, Thank you Reza.
Glad you liked it!
Thank you so much for this video.. It was the exact requirement I was looking for and I had it on a platter :) Thanks a lot for your efforts. One quick query what is your current screen width? Can you share the exact dimensions of it?
Its a standard tablet layout app.
Awesome Reza...I am addicted of your videos. 👍
Wow! Thanks.
Such a nice tutorial Reza .. helped me a lot in my task … just one doubt what if don’t want to load data in my grid in any mode edit or view. Just want to insert new record. Where I need to make changes here
I would have to try out your scenario to let you know the steps for changes. You can check to see if item is new or existing based on ID column and accordingly lock the row. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Very detail video and explanation. Wow, really good!
Thank You
Hi Reza, great video! I don't know if this question has already been answered. The only problem I have with this approach is that when I use the tab key to go to the next label, I have to press the tab key twice. After the first press, the onchange triggers to save/update the item in the collection. I was wondering if you have a solution for this?
There are a few comments on this.
Workaround is to have 2 collections. colGridData is the collection you bind to the grid (items property). OnChange of grid values you update a different collection (colgriddatatemp). Once changes are saved, you patcch colgriddatatemp to the data source and then reload colgriddata.
Very interesting video - thanks for sharing this presentation
Thanks for watching
Hi Reza - great video. The new page template for the Header & Footer Layout makes this sort of a pain to try and resize and shape. Other than that, very helpful as always.
Thanks! New page templates use responsive containers. I have also done a newer video on grid with responsive containers. All grid based videos are placed in a playlist on my channel.
Ah perfect - will go and check it out. You rock @@RezaDorrani 😎