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.

[@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! 😊

[@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!

[@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!

[@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!

[@bree3073]

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

[@AprilDunnam]

Thank you so much 😀

[@ramandeepsingh9611]

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

[@MrsLaubie]

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

[@AprilDunnam]

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

[@baselabuobeid3801]

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

[@AprilDunnam]

That makes me so happy to hear!! ♥

[@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!

[@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!

[@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?

[@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 :)

[@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!

[@eil3354]

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

[@AprilDunnam]

You are so welcome!

[@imran002ali]

Hi April, great video and very informative. I have used Modern Form and created the "Save Option" @9:00, it worked great, thank you for sharing your knowledge. 👍

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

[@divyaakula4822]

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

[@AprilDunnam]

Glad you liked it!! Thanks for watching!

[@davidhodowany8029]

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

[@AprilDunnam]

Thanks so much :)

[@andyqngo]

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!

[@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!

[@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!

[@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!

[@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!

[@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!

[@athompson794]

This is so helpful and thoughtful ! Thanks for sharing !

[@AprilDunnam]

Glad it was helpful!

[@susanteng3592]

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

[@AprilDunnam]

Thanks for watching Susan - glad it was helpful!

[@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!

[@akshaynm]

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

[@AprilDunnam]

Thanks!!

[@DavideGalloni]

Thanks April, very very useful tutorial.

[@AprilDunnam]

Glad it was helpful!

[@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!

[@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!

[@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!

[@juansepowerplatform]

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

[@AprilDunnam]

You are welcome!

[@simoncrowder6765]

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

[@AprilDunnam]

Thanks Simon!

[@jigsaw751]

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

[@AprilDunnam]

Thanks for watching and subscribing!

[@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!

[@GOV221]

Great video...throughly enjoyed it.

[@bensande7251]

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

[@AprilDunnam]

Thanks Ben!

[@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 ?

[@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!

[@mastalayne]

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

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

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

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

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

[@wendymason3263]

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

[@AprilDunnam]

Thanks for watching Wendy - glad it's helpful!

[@hungtranduyhoang5920]

Great. It's more simple than my old way

[@AprilDunnam]

Glad it was helpful!

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

[@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!

[@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?

[@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 :)?

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

[@okidipekimbambo]

Thanks for sharing excellent functionality as usual.

[@AprilDunnam]

Thanks Ricardo!

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

[@JoJo-dc2ey]

Wow what a great video thanks lots of information.

[@AprilDunnam]

Thank you!

[@codysikes2348]

Thank you, really good example!

[@AprilDunnam]

You're very welcome!

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

[@rpsbr2009]

What an amazing video, thanks for sharing!

[@AprilDunnam]

Glad you enjoyed it! Thanks for watching!

[@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!!!

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

[@kevindibb6534]

this is fantastic, thanks so much!!

[@AprilDunnam]

Glad you enjoyed it, thanks for watching!

[@DanielADamico]

Really Awesome!!!!! Thanks for sharing!

[@AprilDunnam]

Thanks for watching Daniel!

[@newmbz9585]

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

[@AprilDunnam]

Great to hear!

[@wanvipamata7835]

I’m very thankful for your clip video.

[@AprilDunnam]

Thanks for watching!

[@azhaaralsiyabi9505]

Great April, Thank you a lot ~Oman~

[@AprilDunnam]

You're welcome - thanks for watching!

[@stephenchristensen7062]

When checking for changed items with the hidden toggle how do you write the fit for toggles and drop-down in the gallery? For instance you fixed the number column by adding “value”.

[@RachelTamez]

I'm needing help here too. Any luck?

[@franksomto3211]

Thank you so much for this!

[@AprilDunnam]

You're so welcome!

[@simonetic]

Thanks!, Your video was very useful.

[@AprilDunnam]

Thanks Marcos - glad it was useful!

[@LeanCleanZ]

Very helpful-thanks

[@AprilDunnam]

Glad it was helpful!

[@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!

[@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!

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

[@surajnautiyal8810]

Nice work, can you please help me on how to compare combo box value when you showing toggle on or off?

[@vilaymaortega7477]

awesome video! Thank you!

[@AprilDunnam]

My pleasure!

[@usurper762]

This video = Perfect 👍

[@AprilDunnam]

Thank you!

[@sytzebuz]

Quite creative! thanks.

[@AprilDunnam]

Thank you! Cheers!

[@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!

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

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

[@Nic_Wood]

Great video, do you think it would be possible to add a filter to only show items created by currently logged in user? I would like to have the same list, viewable by all, but only showing items created by the person viewing the form? Thanks

[@AprilDunnam]

Hey Nic - Absolutely. If you're using SharePoint as your data source then you can modify your "Items" property of the gallery to only show items the current logged in user created like so: Filter(MyDataSource, Created = User())

[@Nic_Wood]

@@AprilDunnam Im going to try this tomorrow, we have to create a list for people in the business to make declarations, and it can be one item or 10 per time, I was going to have separate lists for each person, but this is soooooo much nicer :)

[@Nic_Wood]

I failed! the list has 15 rows, and they cant all fit on one line in PowerApps, so I tried adding them below, and it looks pants :) I need to go on some PA training :)

[@JamieWillisRose]

Great video April

[@AprilDunnam]

Thank you!!

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

[@afonte8552]

Great job.

[@AprilDunnam]

Thank you! Cheers!

[@lisamyers5693]

April, Great video. My sharepoint list includes the People picker field. I'm having issues with the function to write back these changes from my edit screen. Can you provide the function for writing back the people picker option?

[@burogs]

Thanks for the great video. Any chance of instead of using the + icon for new record, showing a blank row for user to enter the information?

[@juniorxInnovationAcademy]

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

[@mojpage]

This is really useful, thank you. Any suggestions on getting round a toggle issue I have because not all of my fields are .text. Some are records and apparently you can't compare records?

[@anpesworld]

Thank you so much April. This help me a lot but the toggle not work with my lookup column. I use DefaultSelectedItems property on the combobox to retrieve the value from SP list. Do you have any suggestions ?

[@AprilDunnam]

Hey there - sorry for the delayed reply. Comboboxes are tricky. The default values have to pull from the same data source as the items. My guess would be it's a mismatch.

[@fedesrrz3046]

Hi Susan, Great video !!, Just I'd like to ask you something regarding to add one functionality. Is it possible to add a "Create new column" button, and another "Delete column" button in order to add/delete a column directly in sharepoint ? could you show it ? many thanks

[@DevendraSingh-tx2pt]

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

[@cedricbouve]

thanks you so much for this video

[@AprilDunnam]

You're welcome!

[@shilpaambala7939]

Thanks for this, How to compare the lookup values?

[@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/

[@santoshdwivedi726]

Hi April, Again great video. Can we add attachment column from SharePoint list to the grid? so that we can attach.