Power Apps Editable Table
HTML-код
- Опубликовано: 22 май 2024
- #PowerApps #EditableTables #InlineEditing
In this video I'll walk you through all of the steps needed to create a repeating, inline editable table within Power Apps similar to what you would see in SharePoint's Quick Edit Mode, Excel and InfoPath repeating tables.
Here's a breakdown of what's covered:
✅ How to style the elements to look like an editable grid
✅ How to detect changes in the gallery
✅ How to add a new row/record to the grid
✅ How to delete a row/record
✅ How to disable and enable the inline editing
🔗 Links
Here's a link to download the sample app: github.com/aprildunnam/PowerA...
Check out Matthew Devany's blog post where he shows another way to patch multiple records at a time: matthewdevaney.com/patch-mult...
Matthew also has a detailed blog post on how to implement an editable grid: matthewdevaney.com/power-apps...
Table of Contents:
00:00 - Intro
01:44 - Styling the Table
08:31 - Checking for Changed Items
14:02 - Patching the Table Changes
15:42 - Add New Item to the Table
17:04 - Deleting an Item from the Table
18:01 - Disable/Enable Inline Editing 
Наука
Great job, April. Making it look easy as usual!
Thank you! 😊
This video by this professional lady ... saved more than 36 hours of work🥰
That makes me so happy to hear!! ♥
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!
Thanks so much Kirill, as they say, the beauty is in the details! 😊
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.
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!
That was awesome, April! Much easier than I thought at the first!
It will be very helpful!
Thanks for watching - glad it was easier than you thought :)
I love the way you explain everything, so easy to understand! Great job! Thank you!
You are so welcome!
Great Video!!. The way the UI was set for the demo is really pleasing. Thanks Again
Glad you liked it - thanks for watching!
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 :)
Thanks so much Teresa!
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?
Clear, concise and absolutely well planned. Thanks for a great video!!
Thanks Ben!
Fantastic video and soooo muuuuuch knowledge in a few minutes!!!!
THANK YOU!!!
You're very welcome Sarah - glad it was helpful!
This tutorial is awesome. It's exactly what I am looking for. Thank you!
Thanks for watching Susan - glad it was helpful!
Awesome April ,much needed. Loved the way you make it easy.
Glad you liked it!! Thanks for watching!
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!
So glad that I could help!
One more excellent video April!! Many thanks for sharing the technique with us.!!!
Thanks!!
My god, after all the videos out there, this one helped me out straight forward! So very helpful! Thank you!!!
I'm so glad to hear this helped you!
Thank you for the video. Can you please suggest how to apply this logic with Dropdowns as well ?
Seriously that’s amazing. Thank you. Hope you do one with sorting in this same layout.
Thanks for watching and for the suggestion Ammar!
Amazing! Best 20+ minutes I've spent today! Thank you for sharing!
That's great to hear, thank you Emmanuel! ☺
Wow! What a perfect explanation! You've made it so clear and easy to understand! Thank you for the video! It saved my week :)
Thank you - glad it was easy to understand!
This is so helpful and thoughtful ! Thanks for sharing !
Glad it was helpful!
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
Awesome, I'll never turn down a virtual hug. Thanks for watching Olga!
Great stuff! You make it look so easy.
Thank you! Cheers!
great instruction and video, always clear and easy to follow, thanks!
Thanks Simon!
that's exactly what I needed today. Your video is very good. helped me a lot. Thanks very much ❤
I'm so glad!
What a great video, I'm glad I've found your channel, subscribed!
Thanks for watching and subscribing!
Thanks April, very very useful tutorial.
Glad it was helpful!
April you're a legend! Thank you for sharing this.
Thanks so much :)
Great Videos April. You are really helpfull in my PowerApps study progress. Thanks a lot and Greetz from The Netherlands.
Hi Steven - so happy to hear that my videos have been helpful for you!
Thanks so much April, this is going to be super useful
Thanks for watching Wendy - glad it's helpful!
I have been searching for how to do this for hours. Thanks for the video!
Glad you found my video. Thanks for watching!
wow. April.. This is beautiful. Almost covered the necessities.
Thanks!
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
I'm glad this was helpful!
This video just saved me so much time. You’re a genius
That's awesome Shane, glad it helped you save some time. Thanks for watching!
The best tutorial of ediitable table! Cant be done easier! You have an amzing talent!
Thank you so much 😀
Thanks for sharing this video, After look this video many doubt of different approach to UX/UI got cleared
Thanks for watching - glad it was helpful!
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.
Thanks, glad this was helpful!
Concise and clear. Perfect!
Thanks Chris!
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!
Glad you found it and it was helpful!
Superb! Thanks April!
Thanks for watching!
Thank you, really good example!
You're very welcome!
Great stuff April! I have clients who greatly benefit from features like this. Keep up the good work!
Thanks for watching Andy - glad it's helpful for you!
Really Awesome!!!!! Thanks for sharing!
Thanks for watching Daniel!
Thanks for sharing excellent functionality as usual.
Thanks Ricardo!
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.
Thank you so much for this!
You're so welcome!
What an amazing video, thanks for sharing!
Glad you enjoyed it! Thanks for watching!
Excellent Demo!
Thanks Morten!
That was god-level! Thank you!
Wow! Thank you Ricky!
@@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.
This saved my life, thank you April ! I had an issue with the ForAll function tho, maybe because of the french synthax :(
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
this is fantastic, thanks so much!!
Glad you enjoyed it, thanks for watching!
thank you for the video, I can see users used to excel really like this
You are welcome!
Wow what a great video thanks lots of information.
Thank you!
awesome video! Thank you!
My pleasure!
Thanks!, Your video was very useful.
Thanks Marcos - glad it was useful!
Thank you dear for your amazing video
Most welcome 😊
@@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
Awesome video, this is going to help me with an app Im currently building.
Great to hear!
Very helpful-thanks
Glad it was helpful!
Quite creative! thanks.
Thank you! Cheers!
Thank you for the great tutorial April!
I was able to get this working on a data source with about 115 items, but I'm having trouble moving the focus to the new blank row at the bottom after it creates it. Any thoughts on how to move to the bottom of the gallery once the new line is added? Since I have more than a handful of items, it's a lot of scrolling and the user may not know that the new entry line is at the bottom.
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
Muito obrigado! Estou tão feliz em saber que meus vídeos foram úteis. Obrigado por assistir!
I’m very thankful for your clip video.
Thanks for watching!
Great job.
Thank you! Cheers!
Just what I was looking for
Yay!
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
Great video April
Thank you!!
Great. It's more simple than my old way
Glad it was helpful!
thanks you so much for this video
You're welcome!
Great video. I'm interested if it's possible to use patch function for dropdown menu lookup field from another table in sql database, so you choose from values in another table and show different value for display and write only ID into the fact table?
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!
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.
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!
I've handled it the same way Fernando, April's approach was an interesting new way I hadn't thought of.
@@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?
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?
Hi April, Again great video. Can we add attachment column from SharePoint list to the grid? so that we can attach.
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?
wow great job done....
Thanks so much!
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?
Thanks for this April, this walk through is really useful, and you've made it look really easy to do.
You're very welcome, thank you Stuart!
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
Great April, Thank you a lot ~Oman~
You're welcome - thanks for watching!
Hey April great videos! How would you filter the table for only rows that match certain column value based on user input? I tried to use filter() but didn't work. Any tips?
Thank you so much for your videos April. They're fantastic and I appreciate all the work you've put into them. I'm working at recreating the editable table but working in Powerapps within Teams. I don't have all the same options on my Text Input box (no default, border, etc). Is this because I'm working inside of teams or is there something I've not set up properly?
I am having the same issue. Is there a workaround?
This video = Perfect 👍
Thank you!
Goooooood as always, seen similar grid designs but my takeaway is FORALL👍👍👍, Tks
Thanks!
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.
Thanks for vidéo :)
You're welcome, thanks for watching!
Nice work, can you please help me on how to compare combo box value when you showing toggle on or off?
Hi, thank you for this great video! I am only having an issue with the patch for the record. It changes all text boxes in the column to the next value when I try to change. Any ideas? Thank you!!!
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.
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.
Thank you.
You're welcome!
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?
Awesome video, April! just curious if this can be done for a datasource with table relationship (PO, customer, item). Like for example a PO header with PO line details. Do you happen to have a version of an editable grid for that or do you think it is possible or not and how would you approach that? Thanks in advance!
I'm interested in doing something similar, wondering if this would work with dropdown controls for some of the fields.
great video
Thanks!
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.
Thanks for this, How to compare the lookup values?
👍 Nice one
Thank you! Cheers!
Hi April, after attached picture thru powerapp and data source is sharepoint, I can't view the picture attachment. unless I go each list and view under edit. how to have this attachment just beside say last column on the sharepoint list? thank you for this great tutorial
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?
Sure here you go: ruclips.net/video/FLHVJdoDSNE/видео.html
Nice explanation !
I have see a new colunm "__PowerAppsId__" linked to the record ...
So If I add manually a record, I do not received this key, do you have an idea to create this key ?
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!
Hi April, could do a video with display data from API to power apps and do bulk edit and update those bulk changes through web api?