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.
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!
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!
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'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.
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 :)
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?
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.
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!
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!
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
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 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?
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.
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?
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!
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
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 ?
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.
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
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?
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!
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.
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?
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?
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.
@@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.
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?
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.
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 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?
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 ?
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?
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
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")
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!
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?
Hi April, Your video is a saver. However, I do have question on delete feature. When I added delete feature, it is working to remove row, but I notice that it is removing previous row not the one I selected. I used similar formula showed in you video. My formula is as "Select(Parent);Remove(CollItems,ThisItem)". Have you encounter this error previously?
@@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
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.
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?
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.
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
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 ?
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.
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.
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!!!
Hi April. Thanks for nice video. If Im working with dataverse instead of collection or sharepoint, how do i write the forall function? I can´t manage to patch to my dataverse table using the forall formula you wrote. Thanks in advance!
Does this process work with ComboBox as one of the items? I have Choice/Lookup fields in my Dataverse table that would be great to have a selection field
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
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 😂
Buenas tengo un problema al momento de mostrar en una table o grafico informacion con fechas... por ejemplo tengo la data de temperatura diaria de 01/01 al 31/01 en mi excel ! pero cuando lo muestro en mi table . se adelanta un dia. mostrando desde el 02/01 al 01/02 . me podrian porfavor indicar a que se debe Hi, I have a problem when displaying information with dates in a table or graph ... for example, I have the daily temperature data from 01/01 to 01/31 in my excel! but when i show it on my table. is one day early. showing from 02/01 to 01/02. Could you please tell me why
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
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())
@@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 :)
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 :)
Just viewed this again April, in a custom gallery with same as approach as this, it doesn't seem that an input drop down control will work? If you initially set displaymode to view, the corresponding choices in a SharePoint list is not available in the drop-down automatically. Can it be set by a formula or should I just create a collection or different data source for the drop down control choices in edit mode?
Hey Emmanuel - Yes you are correct, all you need to do is configure the Default property of the drop down control and make sure the dropdown items are set and it should work
Hi April. Great video. I have a use case. I have a power app screen with input text by user and once user submits this text fields it get saved in my sharepoint list. At the moment I have two text filed "Name" and "Employee code". Subsequently I want to add "Invoice numbers" and "amounts". so that each employee can submit their respective invoices to be saved in SP list. there can be 1 invoice line item or multiple upto 20. please share the solution for this.
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?
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
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/
Hi, I have tried this but in my case its updating the same value to all the rows. Example: I have entered ABC in row 1 and XYX in row 2. But it is updating XYZ in both the rows. Kindly advice to resolve this issue.
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.
Great job, April. Making it look easy as usual!
Thank you! 😊
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.
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! 😊
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!
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!
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.
This video by this professional lady ... saved more than 36 hours of work🥰
That makes me so happy to hear!! ♥
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 ?
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?
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!
Fantastic video and soooo muuuuuch knowledge in a few minutes!!!!
THANK YOU!!!
You're very welcome Sarah - glad it was helpful!
I have been searching for how to do this for hours. Thanks for the video!
Glad you found my video. Thanks for watching!
The best tutorial of ediitable table! Cant be done easier! You have an amzing talent!
Thank you so much 😀
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 :)
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!
I love the way you explain everything, so easy to understand! Great job! Thank you!
You are so welcome!
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!
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!
Great Video!!. The way the UI was set for the demo is really pleasing. Thanks Again
Glad you liked it - thanks for watching!
Awesome April ,much needed. Loved the way you make it easy.
Glad you liked it!! Thanks for watching!
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!
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!
April you're a legend! Thank you for sharing this.
Thanks so much :)
Seriously that’s amazing. Thank you. Hope you do one with sorting in this same layout.
Thanks for watching and for the suggestion Ammar!
wow. April.. This is beautiful. Almost covered the necessities.
Thanks!
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!
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?
This is so helpful and thoughtful ! Thanks for sharing !
Glad it was helpful!
Thanks April, very very useful tutorial.
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!
One more excellent video April!! Many thanks for sharing the technique with us.!!!
Thanks!!
that's exactly what I needed today. Your video is very good. helped me a lot. Thanks very much ❤
I'm so glad!
Amazing! Best 20+ minutes I've spent today! Thank you for sharing!
That's great to hear, thank you Emmanuel! ☺
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
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.
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!
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?
Answer for global choices in dataverse: ThisItem.*TableChoiceColumnName* *PowerAppsDropDownControlName*.Selected.Value
Clear, concise and absolutely well planned. Thanks for a great video!!
Thanks Ben!
What a great video, I'm glad I've found your channel, subscribed!
Thanks for watching and subscribing!
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!
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
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!
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!
thank you for the video, I can see users used to excel really like this
You are welcome!
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 ?
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!
very great video, 1 question, after I patch multi items, every toggles value became true, how could I overcome it, thanks.
Having the same issue. did you find a work-around for this :)?
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.
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
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?
Superb! Thanks April!
Thanks for watching!
Thanks so much April, this is going to be super useful
Thanks for watching Wendy - glad it's helpful!
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!
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.
Concise and clear. Perfect!
Thanks Chris!
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?
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?
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.
Great. It's more simple than my old way
Glad it was helpful!
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.
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?
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.
@@AprilDunnam thanks!
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 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?
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 ?
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?
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
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")
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!
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: th-cam.com/video/FLHVJdoDSNE/w-d-xo.html
Hi April, Your video is a saver. However, I do have question on delete feature. When I added delete feature, it is working to remove row, but I notice that it is removing previous row not the one I selected. I used similar formula showed in you video. My formula is as "Select(Parent);Remove(CollItems,ThisItem)". Have you encounter this error previously?
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
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.
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?
Thank you, really good example!
You're very welcome!
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.
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
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 ?
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.
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.
I agree... Is it because it would be a related table that would be needed to be referenced?
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!!!
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!
Wow what a great video thanks lots of information.
Thank you!
Hi April. Thanks for nice video.
If Im working with dataverse instead of collection or sharepoint, how do i write the forall function? I can´t manage to patch to my dataverse table using the forall formula you wrote.
Thanks in advance!
What an amazing video, thanks for sharing!
Glad you enjoyed it! Thanks for watching!
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 sharing excellent functionality as usual.
Thanks Ricardo!
Hi April, Again great video. Can we add attachment column from SharePoint list to the grid? so that we can attach.
Thanks for this fantastic video. Can we add more than 50 columns in gallery which should be editable like excel spreadsheet.
Does this process work with ComboBox as one of the items? I have Choice/Lookup fields in my Dataverse table that would be great to have a selection field
Awesome video, this is going to help me with an app Im currently building.
Great to hear!
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
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 😂
I figured it out. I just did the same as in the "New" button. Worked perfectly. Thanks again.
That was fast! Glad you figured it out!
Yes, sometimes the brain works slowly 😁
Buenas tengo un problema al momento de mostrar en una table o grafico informacion con fechas... por ejemplo tengo la data de temperatura diaria de 01/01 al 31/01 en mi excel ! pero cuando lo muestro en mi table . se adelanta un dia. mostrando desde el 02/01 al 01/02 . me podrian porfavor indicar a que se debe
Hi, I have a problem when displaying information with dates in a table or graph ... for example, I have the daily temperature data from 01/01 to 01/31 in my excel! but when i show it on my table. is one day early. showing from 02/01 to 01/02. Could you please tell me why
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
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())
@@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 :)
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 :)
Just viewed this again April, in a custom gallery with same as approach as this, it doesn't seem that an input drop down control will work? If you initially set displaymode to view, the corresponding choices in a SharePoint list is not available in the drop-down automatically. Can it be set by a formula or should I just create a collection or different data source for the drop down control choices in edit mode?
Geez... i think you just set the value in Default property and then set the choices in the Items property on edit mode?
Hey Emmanuel - Yes you are correct, all you need to do is configure the Default property of the drop down control and make sure the dropdown items are set and it should work
Hi April. Great video. I have a use case. I have a power app screen with input text by user and once user submits this text fields it get saved in my sharepoint list. At the moment I have two text filed "Name" and "Employee code". Subsequently I want to add "Invoice numbers" and "amounts". so that each employee can submit their respective invoices to be saved in SP list. there can be 1 invoice line item or multiple upto 20. please share the solution for this.
awesome. aside from being a tech guru, are you also a musician? so impressive!
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?
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
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/
Hi, I have tried this but in my case its updating the same value to all the rows.
Example: I have entered ABC in row 1 and XYX in row 2. But it is updating XYZ in both the rows.
Kindly advice to resolve this issue.
I’m very thankful for your clip video.
Thanks for watching!
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.