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!
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.
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.
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
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!
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!
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?
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 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?
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
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 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.
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.
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!!!
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.
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?
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/
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 ?
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.
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, 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.
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.
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
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?
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
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 😂
@@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.
Super April... thank you. I need to do something similar but with an Excel from business onedrive as source... could you teach us how to achieve this? Thanks again in advance.
Hey! So the method that I show wouldn't really be any different with another data source. You should be able to do everything that I've did in the video with an Excel/OneDrive data source too
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!
@@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
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?
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.
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
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 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?
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?
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.
Hello April, Many thanks for sharing the technique. I have a request for you. We can enable version history of sharepoint list where we can see all the changes made by all users with date and time stamp. It would be great if you can demonstrate any functionality where we can show the version history of all items in the powerapps itself. Thanks Again, Akshay
If anybody can come up with that one without using a ton of JavaScript, I'd sure like to see it too. BTW: I'd be mighty impressed, unless I'm missing something here.
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?
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.
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);
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! 😊
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!
This video by this professional lady ... saved more than 36 hours of work🥰
That makes me so happy to hear!! ♥
Thank you for the video. Can you please suggest how to apply this logic with Dropdowns as well ?
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.
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!
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!
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!
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!
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 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?
Seriously that’s amazing. Thank you. Hope you do one with sorting in this same layout.
Thanks for watching and for the suggestion Ammar!
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 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?
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!
Fantastic video and soooo muuuuuch knowledge in a few minutes!!!!
THANK YOU!!!
You're very welcome Sarah - glad it was helpful!
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
The best tutorial of ediitable table! Cant be done easier! You have an amzing talent!
Thank you so much 😀
I have been searching for how to do this for hours. Thanks for the video!
Glad you found my video. Thanks for watching!
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!
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!
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!
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!
Great Video!!. The way the UI was set for the demo is really pleasing. Thanks Again
Glad you liked it - thanks for watching!
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.
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.
This tutorial is awesome. It's exactly what I am looking for. Thank you!
Thanks for watching Susan - glad it was helpful!
wow. April.. This is beautiful. Almost covered the necessities.
Thanks!
thank you for the video, I can see users used to excel really like this
You are welcome!
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!!!
that's exactly what I needed today. Your video is very good. helped me a lot. Thanks very much ❤
I'm so glad!
Awesome April ,much needed. Loved the way you make it easy.
Glad you liked it!! Thanks for watching!
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 :)?
Thanks April, very very useful tutorial.
Glad it was helpful!
April you're a legend! Thank you for sharing this.
Thanks so much :)
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!
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!
This is so helpful and thoughtful ! Thanks for sharing !
Glad it was helpful!
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!
Amazing! Best 20+ minutes I've spent today! Thank you for sharing!
That's great to hear, thank you Emmanuel! ☺
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 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!
Great stuff! You make it look so easy.
Thank you! Cheers!
Clear, concise and absolutely well planned. Thanks for a great video!!
Thanks Ben!
One more excellent video April!! Many thanks for sharing the technique with us.!!!
Thanks!!
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
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/
great instruction and video, always clear and easy to follow, thanks!
Thanks Simon!
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 ?
What a great video, I'm glad I've found your channel, subscribed!
Thanks for watching and subscribing!
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.
awesome. aside from being a tech guru, are you also a musician? so impressive!
Awesome video, this is going to help me with an app Im currently building.
Great to hear!
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
Great. It's more simple than my old way
Glad it was helpful!
I wish you could have a complete tutorial for power apps with modern control features for beginners.. 🥰
That is a great idea. I'll work on that ☺
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!
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!
Thanks so much April, this is going to be super useful
Thanks for watching Wendy - glad it's helpful!
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.
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
Superb! Thanks April!
Thanks for watching!
Thanks April. Can you do a video around web API's in dataverse
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: ua-cam.com/video/FLHVJdoDSNE/v-deo.html
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
Thanks for this fantastic video. Can we add more than 50 columns in gallery which should be editable like excel spreadsheet.
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 😁
Thank you, really good example!
You're very welcome!
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.
So good! I'd love it if sometime you'd consider a timesheet app. :)
Hey there - it's your lucky day, I've already considered that and have built one! Watch here: ua-cam.com/video/A8SiNTnQw0Q/v-deo.html
@@AprilDunnam omg thank you!!
Concise and clear. Perfect!
Thanks Chris!
Super April... thank you. I need to do something similar but with an Excel from business onedrive as source... could you teach us how to achieve this?
Thanks again in advance.
Hey! So the method that I show wouldn't really be any different with another data source. You should be able to do everything that I've did in the video with an Excel/OneDrive data source too
@@AprilDunnam Ok. Thank You.
Hi April, Again great video. Can we add attachment column from SharePoint list to the grid? so that we can attach.
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!
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
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?
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.
Great Video. Great help. Can you please do one video on pdf viewer in power apps.
Great suggestion! I'll add that to my list.
Thanks for sharing excellent functionality as usual.
Thanks Ricardo!
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?
Wow what a great video thanks lots of information.
Thank you!
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
Nice work, can you please help me on how to compare combo box value when you showing toggle on or off?
this is fantastic, thanks so much!!
Glad you enjoyed it, thanks for watching!
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 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?
Great job.
Thank you! Cheers!
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?
Thank you so much for this!
You're so welcome!
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.
Hello April,
Many thanks for sharing the technique. I have a request for you. We can enable version history of sharepoint list where we can see all the changes made by all users with date and time stamp. It would be great if you can demonstrate any functionality where we can show the version history of all items in the powerapps itself.
Thanks Again,
Akshay
If anybody can come up with that one without using a ton of JavaScript, I'd sure like to see it too. BTW: I'd be mighty impressed, unless I'm missing something here.
amaaaaaaaaaaazing April as usual. Many thanks. does it work also for the instructor field ? (Field of type people..) please advice
I would appreciate your confirmation if it works for the "people" type fileds in sharepoint
Yes this should work with a person or group field too
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?
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?
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.
What an amazing video, thanks for sharing!
Glad you enjoyed it! Thanks for watching!
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);