Power Apps Editable Table

[@angrybatvoice]

Great job, April. Making it look easy as usual!

[@AprilDunnam]

Thank you! 😊

[@prateepdasgupta]

This is the exact functionality I was looking for. I looked into lot of places but couldn't find some content that explains it so clearly. You explained it in an amazing way and I can't thank you enough for that. Kudos April for the awesome work you are doing and making our lives easy.

[@baselabuobeid3801]

This video by this professional lady ... saved more than 36 hours of work🥰

[@AprilDunnam]

That makes me so happy to hear!! ♥

[@ahmadjauharudin1353]

I'm newbie in powerApps, and I'm planning to create apps in my office to help my team. This is what I have been looking for all this time. Thank you. Terimakasih

[@AprilDunnam]

I'm glad this was helpful!

[@kevindibb6534]

Wanted to also say I watched a couple of other PowerApps Editable Table videos and found yours to be the best one for me. The others were fine too but I followed yours better. Thanks again!

[@kirillperian]

Thank so much for posting this, April - this is perfect! I really appreciate it. I also appreciate your complete approach to building this out - from the attention to detail such as border colors/thickness, fills, alignment and even the hover fills to being mindful about the performance and building that all into your approach. Bravo!

[@AprilDunnam]

Thanks so much Kirill, as they say, the beauty is in the details! 😊

[@ShihChiWang]

This is great!! I added edit icon and save icon and delete icon in my gallery (each row has these three icons) then user can edit by rows because they like to view items like in excel mode not a form. Your method is much better. Thanks for this sharing.

[@AprilDunnam]

Thanks, glad this was helpful!

[@dandrem.4074]

I've come to the conclusion these creators do things in the background and you have to be really skilled to figure that out. I literally did the same thing she did and I have red x's everywhere.

[@breadandcheese1880]

My god, after all the videos out there, this one helped me out straight forward! So very helpful! Thank you!!!

[@AprilDunnam]

I'm so glad to hear this helped you!

[@komanguy]

Amazing! I made a lot of search on this matter, and finally, I’ve got a great answer. Today I learned a lot. You should write a book on power apps. Thanks a lot for your help!

[@AprilDunnam]

Glad you found it and it was helpful!

[@teresaagustin5191]

Great video April! I really like the way you optimized for performance with the toggle, leveraged Boolean values to minimize the number of If statements and how you referenced other controls. Nice, clean code. Please keep your terrific videos coming :)

[@AprilDunnam]

Thanks so much Teresa!

[@robertmcghee6815]

When I click "save", all the toggle values are set to "true", and the function no longer works. Meaning the filter becomes redundant. Has anyone found a work-around for this?

[@bree3073]

The best tutorial of ediitable table! Cant be done easier! You have an amzing talent!

[@AprilDunnam]

Thank you so much 😀

[@cordeirofilho4024]

Não sei falar nem digitar em inglês, mas, preciso dizer que você é simplesmente sensacional. Você deu mais aula em um único vídeo que um professor normal daria em semanas. kkkkkkkkk

[@AprilDunnam]

Muito obrigado! Estou tão feliz em saber que meus vídeos foram úteis. Obrigado por assistir!

[@ramandeepsingh9611]

Thank you for the video. Can you please suggest how to apply this logic with Dropdowns as well ?

[@daniloxaugusto]

Very impressed with how you conveyed the steps, this was my 4th video on the topic and you just helped me get a breakthrough :) Thanks!

[@AprilDunnam]

So glad that I could help!

[@eli.jiah.meowmeow]

I have been searching for how to do this for hours. Thanks for the video!

[@AprilDunnam]

Glad you found my video. Thanks for watching!

[@marciokataoka]

That was awesome, April! Much easier than I thought at the first! It will be very helpful!

[@AprilDunnam]

Thanks for watching - glad it was easier than you thought :)

[@tenisviejos]

I like the way you set the "Edited" hidden property. I have a different approach (I would add a boolean column on the Items property)... I guess I have to test both options to measure and compare performances. Your approach is simpler because it requires way less logic on each control in the table. Thanks for such a quick and efficient video, as usual.

[@AprilDunnam]

That's an interesting approach Fernando. If you do run a performance comparison between the two approaches I'd love to hear what the results were!

[@stevenpride5459]

I've handled it the same way Fernando, April's approach was an interesting new way I hadn't thought of.

[@q-breezy4826]

@@AprilDunnam I was building in a toggle that was checking for any updated items and noticed an issue and then came across this video while I was researching. I had the same thought/implementation as you however I noticed it wasn't actually working for the patch/filter statement (I first noticed when I tried to count rows with that filter to see how many pending changes there were). I added a second gallery below to do some testing and set the items property of the second gallery to "Filter(MyMainGallery.AllItems,Toggle.Value = true), and what I saw was that either no items or all items in the main gallery are showing up. My guess is that this is because the toggle control is not part of all items so there is not a unique instance of the control per item, there is only a single instance, and I think* the Toggle.Value that is being referenced is the instance related to the single selected item in the main gallery. If you do this do you get the same results that I do, or are you getting the unique rows that have been changed?

[@MrsLaubie]

Fantastic video and soooo muuuuuch knowledge in a few minutes!!!! THANK YOU!!!

[@AprilDunnam]

You're very welcome Sarah - glad it was helpful!

[@AndyNgo_ItAll]

Great stuff April! I have clients who greatly benefit from features like this. Keep up the good work!

[@AprilDunnam]

Thanks for watching Andy - glad it's helpful for you!

[@NileshHingu1978]

Thanks for sharing this video, After look this video many doubt of different approach to UX/UI got cleared

[@AprilDunnam]

Thanks for watching - glad it was helpful!

[@user-nq8kf9qz7m]

Thank you April! Just what I was looking for :)) Although I am encountering an issue that when adding new item, the previous item that the user has entered is gone. How do encounter this issue? Does it mean user need to save/patch for every changes made? Would appreciate the help/tips and thanks again for your wonderful videos it helped a lot!

[@davidhodowany8029]

April you're a legend! Thank you for sharing this.

[@AprilDunnam]

Thanks so much :)

[@iamthedon11]

Great Video!!. The way the UI was set for the demo is really pleasing. Thanks Again

[@AprilDunnam]

Glad you liked it - thanks for watching!

[@devilo737]

Seriously that’s amazing. Thank you. Hope you do one with sorting in this same layout.

[@AprilDunnam]

Thanks for watching and for the suggestion Ammar!

[@jaysizmir9432]

This saved my life, thank you April ! I had an issue with the ForAll function tho, maybe because of the french synthax :(

[@AprilDunnam]

You're very welcome! Yeah the syntax can vary based on region. I believe for French anywhere I use a comma you would need to use a semi colon instead

[@eil3354]

I love the way you explain everything, so easy to understand! Great job! Thank you!

[@AprilDunnam]

You are so welcome!

[@emmanuelmaceda2475]

Amazing! Best 20+ minutes I've spent today! Thank you for sharing!

[@AprilDunnam]

That's great to hear, thank you Emmanuel! ☺

[@vinayayinapurapu]

wow. April.. This is beautiful. Almost covered the necessities.

[@AprilDunnam]

Thanks!

[@ShaneC0271]

This video just saved me so much time. You’re a genius

[@AprilDunnam]

That's awesome Shane, glad it helped you save some time. Thanks for watching!

[@divyaakula4822]

Awesome April ,much needed. Loved the way you make it easy.

[@AprilDunnam]

Glad you liked it!! Thanks for watching!

[@DavideGalloni]

Thanks April, very very useful tutorial.

[@AprilDunnam]

Glad it was helpful!

[@juansepowerplatform]

thank you for the video, I can see users used to excel really like this

[@AprilDunnam]

You are welcome!

[@susanteng3592]

This tutorial is awesome. It's exactly what I am looking for. Thank you!

[@AprilDunnam]

Thanks for watching Susan - glad it was helpful!

[@athompson794]

This is so helpful and thoughtful ! Thanks for sharing !

[@AprilDunnam]

Glad it was helpful!

[@anatolijkovalenko9696]

Hello! I really enjoyed your tutorials on Power apps. Maybe you can upload a video on how to create a power apps visitor registration form where you can see the time, when they arrived, when they left, who came and to whom. How to enable search and edit data. Thank you very much.

[@bensande7251]

Clear, concise and absolutely well planned. Thanks for a great video!!

[@AprilDunnam]

Thanks Ben!

[@akshaynm]

One more excellent video April!! Many thanks for sharing the technique with us.!!!

[@AprilDunnam]

Thanks!!

[@itubeHirschberg]

that's exactly what I needed today. Your video is very good. helped me a lot. Thanks very much ❤

[@AprilDunnam]

I'm so glad!

[@stephenmusau2394]

Great stuff! You make it look so easy.

[@AprilDunnam]

Thank you! Cheers!

[@hermysstory8333]

I have extended on your theme by adding a Column to the collection that can have 4 statuses (Added; Deleted; Updated and Unchanged). Upon saving, the ForEach takes the necessary action on the record in a nested switch statement.

[@ronaldssali2122]

Hi April, thanks for the amazing content. i am trying to build an app that updates my sharepoint list. I want the app to have 5 columns to be filled out but the first column will be a text box and i have dropdowns for the other columns. Can i have set up that when someone enters text in the first box and it matches an existing record.. data in the other fields is automatically pulled but allow the user to update them. Or else, if its a new record in the first column, then the user is allowed to just add details of other columns.. i am trying ro avoid suolicate entries in the datasource. Your advice on how i can go about this will be highly appreciated. CHEERS.

[@olgamelo7056]

Hi April, Thank you very much for this video, it is very complete and easy to follow. I'm sending yiu a virtual hug. Thank you, thank you

[@AprilDunnam]

Awesome, I'll never turn down a virtual hug. Thanks for watching Olga!

[@stevenpride5459]

To add on to your edit mode, I've done something similar, but made it more of a toggle. Set(editMode, !editMode) and Button.Text = If(editMode, "Read Mode", "Edit Mode")

[@AprilDunnam]

That's awesome Steven - one of the things I love about Power Apps is there's multiple ways to handle things. I like seeing how other people tackle the same problem!

[@taisa.s]

Wow! What a perfect explanation! You've made it so clear and easy to understand! Thank you for the video! It saved my week :)

[@AprilDunnam]

Thank you - glad it was easy to understand!

[@mastalayne]

awesome. aside from being a tech guru, are you also a musician? so impressive!

[@jamiehandelman1566]

Thanks so much for this! Made it super easy. I have 2 quick questions if you have the time to answer. 1. How do you start with a blank gallery? I don't want to edit any existing list items, just add new ones. 2. When you write the formula for the "plus" icon for OnSelect, the end of the formula ends ....;Refresh(Gallery2). I'm getting an error on this - is there something i'm missing? thanks so much!

[@mazlinanis294]

Hi, here's my suggestion: 1. For the blank gallery you can follow all the steps until the end then just delete all the lines to start with blank table 2. The formula ends with ...; Refresh('name of your data source') or you can just drop the Refresh() function. The formula still works fine

[@stevenned23]

Great Videos April. You are really helpfull in my PowerApps study progress. Thanks a lot and Greetz from The Netherlands.

[@AprilDunnam]

Hi Steven - so happy to hear that my videos have been helpful for you!

[@saeedsm57]

Superb! Thanks April!

[@AprilDunnam]

Thanks for watching!

[@jigsaw751]

What a great video, I'm glad I've found your channel, subscribed!

[@AprilDunnam]

Thanks for watching and subscribing!

[@simoncrowder6765]

great instruction and video, always clear and easy to follow, thanks!

[@AprilDunnam]

Thanks Simon!

[@hungtranduyhoang5920]

Great. It's more simple than my old way

[@AprilDunnam]

Glad it was helpful!

[@pulle30]

Excellent Demo!

[@AprilDunnam]

Thanks Morten!

[@ScottBendigo]

Just what I was looking for

[@AprilDunnam]

Yay!

[@ScottBendigo]

Can you do a video on: I have a yes/no field and need someone to click a button on the app to set the yes or no in the SP list. Example: Do you still need this? Yes/ No buttons - Click an answer and it posts back to the SP list. Is that possible? TIA

[@powerappstw]

very great video, 1 question, after I patch multi items, every toggles value became true, how could I overcome it, thanks.

[@robertmcghee6815]

Having the same issue. did you find a work-around for this :)?

[@oldhem]

Concise and clear. Perfect!

[@AprilDunnam]

Thanks Chris!

[@kevindibb6534]

16:54 - the video cuts before you finish typing, but did you mean to say refresh the SharePoint datasource vs the Gallery? When I try with Gallery I get errors but it works when I tell it to refresh the datasource.

[@monicaquiroz1181]

This is awesome! Exactly what I have been looking for. I do have one question. In my case there will be multiple users. So is it possible to restrict record display to only the records that the user originally entered? This way the user can't edit records that they didn't create.

[@sandrakeenboyd1455]

It would be great to include a parent table to this edit grid. For example, a Purchase Request parent table and the quick edit details are the individual line items. I can't figure out how to get both together.

[@saradehond3293]

I agree... Is it because it would be a related table that would be needed to be referenced?

[@TheMKTube]

Omg I totally agree! Would love to see this appear in a parent form as a sub list where we can see experience with ability to perform CRUB operations within the sublist and the parent. Hope April sees this comment!!!

[@wendymason3263]

Thanks so much April, this is going to be super useful

[@AprilDunnam]

Thanks for watching Wendy - glad it's helpful!

[@Ricobeans27]

That was god-level! Thank you!

[@AprilDunnam]

Wow! Thank you Ricky!

[@Ricobeans27]

@@AprilDunnam trying to do the same thing with a SQL Server table and it is giving me difficulty since it is viewing a NULL value as a Null value in SQL Server but a blank in the Gallery. So it is saying that anything that is Null Blank.

[@stevenned23]

Hi April. I've a question. You insert a Toggle to check if there are changes in the row thisItem . That works for text fields as you showed in your video. But my row has also a Datepickers field, a Choices column and a view yes/no toggles. What are the functions to see if there are changes?

[@coryschwartz]

Answer for global choices in dataverse: ThisItem.*TableChoiceColumnName* *PowerAppsDropDownControlName*.Selected.Value

[@ShashiSadasivan]

Question regarding adding a new record (based on the point made at 16:07). How do you add a line to the gallery instead of patching directly to the data source ?

[@ahmadyamout1115]

Thank you dear for your amazing video

[@AprilDunnam]

Most welcome 😊

[@ahmadyamout1115]

@@AprilDunnam you are the hero of powerapps dear . I don't know if you accept my suggestion about doing like invoice template for example autogenerate and autoincrement the invoice number every time the user create a new invoice without any interferance of the user that should be locked so the user can only view it . I don't know if it can be done using form control instead of gallery control

[@SothearithKONGMrMuyKhmer]

I wish you could have a complete tutorial for power apps with modern control features for beginners.. 🥰

[@AprilDunnam]

That is a great idea. I'll work on that ☺

[@stuandrews1618]

Thanks for this April, this walk through is really useful, and you've made it look really easy to do.

[@AprilDunnam]

You're very welcome, thank you Stuart!

[@codysikes2348]

Thank you, really good example!

[@AprilDunnam]

You're very welcome!

[@DevendraSingh-tx2pt]

Thanks for this fantastic video. Can we add more than 50 columns in gallery which should be editable like excel spreadsheet.

[@newmbz9585]

Awesome video, this is going to help me with an app Im currently building.

[@AprilDunnam]

Great to hear!

[@JoJo-dc2ey]

Wow what a great video thanks lots of information.

[@AprilDunnam]

Thank you!

[@mdhruv1]

This is awesome,. I had used Shane young . This is more simpler. Please can you extend this to see versions on the list item in SharePoint how could I go about doing that or a comment with a date stamp. That will be awesome

[@AprilDunnam]

Hello - There's not an easy way to get version history into Power Apps. You pretty much have to leverage Power Automate and SharePoint API calls to do it. This blog post is pretty detailed and shows you the steps needed: www.about365.nl/2019/08/08/view-sharepoint-item-version-history-in-powerapps/

[@afonte8552]

Great job.

[@AprilDunnam]

Thank you! Cheers!

[@junbecks]

Hi April, great easy to understand tutorial. Question, if the sharepoint list has to be shared with whomever is using this powerapp, why cant they just go to sharepoint to edit what they need?

[@AprilDunnam]

Thanks and great question. They could absolutely go to the SharePoint list directly to edit the data. It comes down to use case and user experience. Often times you don't want to make your users go to a different system which is why you would build something like this into the Power App.

[@junbecks]

@@AprilDunnam thanks!

[@kevindibb6534]

this is fantastic, thanks so much!!

[@AprilDunnam]

Glad you enjoyed it, thanks for watching!

[@radiosonicfan1726]

Thanks for the lesson. For me, Patch formula needed amending (using aRecord) to get your lesson to work. I had a gallery populated with items: SortByColumns(Filter(Gateways, MasterID = ProgramGallery.Selected.ID),"VPPDate"). Patch formula change: Using aRecord. ForAll(Filter(ExcelGallery.AllItems, Toggle1.Value = true) As aRecord, Patch(Gateways, aRecord, {'Model Year': aRecord.MYInput.Text, Program: aRecord.ProgramInput.Text, Reference_Only: {Value: RefOnlyInput.Selected.Value}, 'VPP Dates': aRecord.VPPDateInput.SelectedDate})); Navigate(Home);

[@lylecurtis8837]

Excellent video. How can I hide or reset the rows so that I am not starting the app and seeing data in the fields from a previous session? And I don't want the content to get deleted where it is stored in the SharePoint list. Thanks!

[@okidipekimbambo]

Thanks for sharing excellent functionality as usual.

[@AprilDunnam]

Thanks Ricardo!

[@juniorxInnovationAcademy]

Thanks April. Can you do a video around web API's in dataverse

[@naveenr85]

Thank you for this video April. I was trying a use case based on this Use case: I have a SharePoint list in which lookup is a column. In PowerApps I am using a combo box to display the value. challenge: how to do a comparison with toggle method. Appreciate if you can demo this please.

[@franksomto3211]

Thank you so much for this!

[@AprilDunnam]

You're so welcome!

[@andreawatkins9926]

Hi April, I was so hopeful to correct my inability to update items in my Gallery (grid gallery) when I found your video. However, I get the error you did with the two underlying red lines when I do my in my default toggle properties. The Value function does not work for me and I am thinking it is because that is only a number function and my dropdown fields are selected text types. Can you point me in the right direction?

[@rpsbr2009]

What an amazing video, thanks for sharing!

[@AprilDunnam]

Glad you enjoyed it! Thanks for watching!

[@azhaaralsiyabi9505]

Great April, Thank you a lot ~Oman~

[@AprilDunnam]

You're welcome - thanks for watching!

[@litf2009]

Awesome. Helped a lot! Question. If I'd like to copy one selected row of data and save as new entry in SPO. How can that be done? I tried and failed miserably 😂

[@litf2009]

I figured it out. I just did the same as in the "New" button. Worked perfectly. Thanks again.

[@AprilDunnam]

That was fast! Glad you figured it out!

[@litf2009]

Yes, sometimes the brain works slowly 😁

[@deepalichauhan9848]

Thank you April for such a great video. I tried to Patch data in my CDS table inside ForAll function but it gave me error. Can you please tell me what could be the reason?

[@pennaiahnagarajappa5639]

Good solution however i see that we cannot add more controls in gallery to look like actual grid.. (you do not get horizontal scroll button in gallery to create this view if i have 10 plus columns to make it happen)

[@DanielADamico]

Really Awesome!!!!! Thanks for sharing!

[@AprilDunnam]

Thanks for watching Daniel!

[@usurper762]

This video = Perfect 👍

[@AprilDunnam]

Thank you!

[@Zodiac65ForU]

Very helpful-thanks

[@AprilDunnam]

Glad it was helpful!

[@DeepDeep-zd5jq]

It's very informative videos I have one query if I am creating editable grid form datavers and want to display lookup column how we can implement this? thanks.

[@ojsojs6004]

Nice tutorial April. I have just a question. Is this possible with SQL? Using SQL View as Data Source, How to update a specific table only? I am new to Power Apps. I have an empty vertical gallery with sql view as data source. Let say I have a view name SampleView created at SQL. This SampleView has table1 and table2 joined.If I use Sampleview as data source for empty vertical gallery. How can I update record on table2 only? Let's say I put Text Input named TextInput1 in the gallery. Its value came from table2. If I modified the value of the first row of TextInput1, how can I update it back on table2?

[@mikhailk5690]

Hi April, thank you for the great video! Perhaps an idea for a future one: is it possible to have a similar editable table in PowerApps that allows easy copy-pasting from Excel? Otherwise each value has to be copied/changed one by one. See, the grid view in a SharePoint list will allow the user to paste a table from Excel to the grid. But, unfortunately, the gallery does not allow me to do that... Would you mind giving a thought about that?

[@AprilDunnam]

There's not an out-of-the-box way to do this right now. There's a hack that you can do with pasting the Excel data in a Text Input and adding that into a collection that you can then put in the gallery like so: ForAll(Split(TextInput3.Text;Char(10));Collect(TotalCollection2;{C1:First(Split(Result;Char(9))).Result;C2:Last(FirstN(Split(Result;Char(9));2)).Result;C3:Last(FirstN(Split(Result;Char(9));3)).Result

[@vidhoo29]

Great Video. Great help. Can you please do one video on pdf viewer in power apps.

[@AprilDunnam]

Great suggestion! I'll add that to my list.

[@vilaymaortega7477]

awesome video! Thank you!

[@AprilDunnam]

My pleasure!

[@sytzebuz]

Quite creative! thanks.

[@AprilDunnam]

Thank you! Cheers!

[@wanvipamata7835]

I’m very thankful for your clip video.

[@AprilDunnam]

Thanks for watching!

[@JamieWillisRose]

Great video April

[@AprilDunnam]

Thank you!!

[@rubainarahman6401]

Thank you for this video. The step where you set default to "ThisItem.Length", I tried to do the same, but it is showing error. I am trying to retrieve the data from a choice list for which it is showing data is record type. Please can you help me how to solve it?

[@smartin8707]

Hi April. Thanks for this video. Can you link to the video that you have about creating a pop up for the deleting button to avoid against accidental deletes?

[@AprilDunnam]

Sure here you go: kzbin.info/www/bejne/fH2rh32apKmGhKc

[@simonetic]

Thanks!, Your video was very useful.

[@AprilDunnam]

Thanks Marcos - glad it was useful!