Reza, you certainly not mucking around! Others drag what actually can be done in 5 mins into an hour. Yours is succent and spot on! Love your videos. We neeeeeeeeeed videos like yours!
Reza, thank you so much for this. This will make the users of my app very happy. I was patching directly to the sharepoint list every time the users made a change. This will save hours!! Brilliantly and so simply explained too.
Assalamualkum Mr.Reza, What a Noble Soul you are. Very rare these days. Mashallah. Please keep up the good work, you are my virtual guide . Learnt a lot from scratch , just because of you. May Allah bless you with Health , Happiness, Prosperity & Emaan. Regards,
Seriously you are an amazing guy, you sound extremely knowledgeable. I have zero knowledge in coding but the way you are explaining, making me to learn PowerApps. Thank you Reza..
Galleries ! Yes! Best way to present data in different formats is playing with galleries ! Thanks for this informative video sir ! As always - Precise and helpful !
Reza, I like all your videos, and you are truly an inspiration for me to use Power Apps/Power Automate. You cover real life issues and struggles, and you are like this one person that gets born to create something amazing and pass it to the others, kind of like Mozart, or Beethove, all your apps are an art!
Thank You so much for your kind words 🙏 Happy to hear the feedback. I started the channel with one goal in mind: "To cover real world use cases" & always try to showcase something new.
Good Day Reza, I need your support to do an horizontal progress bar to reflect the values of 9 columns of Yes/No. To count the “Yes” and progress till reaches 100. If you have similar video, please share, or if you have any similar component or anything that can help? ❤️
Really great video and clearly explained. I always wanted to make this grid functionality by using some custom jsgrid with rest api calls.. Now this solution has made much more simpler than this. I really wanted to try out with SP list having more than 5k records and need to try paging, sorting, filtering in this grid. Thanks again Reza for this wonderful video.
Thank you for such amazing feedback. The description of this video contains a link to download the entire solution. I also have videos on my channel with SharePoint and delegation that will help working with large data sources (5k records). My next video is planned to be around filtering. I hope that one is useful as well.
@@RezaDorrani out of context of this video. Want to know if you have any video, when flow return stringify JSON in "response to PowerApps" and string is collected and saved in PowerApps, then how to convert that to collections. Tried many things but not working. Thanks for help in advance.
Thanks for sharing, excellent video. I would like to add an idea on the "Change mode of Grid view" when it's on View Mode we should stop the timer from running to avoid queries with no data.
Hi Reza, Thank you for all the videos, so helpful! When I create this app from a SharePoint list, the save button refreshes the collection (as if running ClearCollect) so that the warning messages for unsaved changes light up on all items. If I click the button again, it clears the collection and the warnings. When I create from a Dataverse table as in your example, it works as expected. Ideally, would like to run this from the SharePoint list. Any thoughts on what might be happening?
I have a video on SharePoint List based Grid. th-cam.com/video/wI6SHGQ9ATg/w-d-xo.html Video description also has link to download sample App. Make sure you do not use combo boxes as they cause issues in grids.
Great case dealt with clarity, as usual Reza! I faced one problem though which is the gallery items resetting, and probably triggering OnChange action, upon executing patch as provided in Add row. Thus, this pushes all items from gallery to the Collections and not the only one changed, when Add row is clicked. Any way to resolve this? Thank.
Thanks! I have not faced that issue based on technique should in video. Also, I have done 3-4 more grid based videos showcasing different approaches. Check those and see if they help.
Thanks Reza for this wonderful tutorial ! Very very useful indeed. If I may ask you a question please ? In my project I have 3 different screens, each of which will have an Editable Table/Grid (like the one you have shown in this video). In this case, the user is expected to input data from different (but similarly structured) Excel files into these grid tables. The Excel files are like templates and values to be input are very conveniently arranged in a row. The user needs to copy only one (or two) row(s) from each Excel file into the Grid Table. So ideally, it would be very time-saving for the user, if he/she could simply copy the row from the Excel file and paste the same to the Grid Table (in PowerApps). This will not only save time but it can potentially reduce errors in manual data entry. In short, is it possible to copy rows from Excel file (one row at a time is fine) and paste the same into a corresponding row in the Grid table ? (Of course, we will design the Grid tables so that the columns in the Grid match exactly with the columns in the Excel file). Thanks in advance for any advice you may have !
Thank you for watching. Copy paste is not a feature in Power Apps. User would have to copy cell by cell and paste which is not ideal. I can think of a case where we could leverage flow to read data from an excel file and populate the table. Sounds simple but will require some amount of effort to build.
@@RezaDorrani Thanks for your response ! Yes, this seems like a more complicated issue to solve. Wish Microsoft made copy/paste possible in this case. In any case, there is so much that I have learnt from your videos. You are awesome :-).
Thanks a lot for an excellent video. You made my day. I have a requirement. Do not patch the data source until user fills all the mandatory fields. I have created a collection & added the records to this collection whenever user clicks on "Add" button. My question is how to make sure that user fills all the mandatory fields in the collection. Your timely reply would be highly appreciated. Thanks once again for this great video.
Most welcome. Its been a long while since I did this hence do not remember the specifics. I have done 4-5 videos on grids and put them in a playlist. May be I did show mandatory validation in one of them. Alternatively, I would also recommend posting your query on forums in case someone has done something similar powerusers.microsoft.com
Thank you for this valuable sharing on how to create editable table in powerapps Reza. I would like to ask if I can use the same procedure using my SharePoint list as the data source?
The gallery was conncected live to the data source (no collection set as Items property). Since my App had no delegation warnings the gallery will load data from CDS in batches of 100 in a performant and optimized manner. So really no limit as the records are being fetched in batches.
@RezaDorrani You are a great teacher! Thanks for share !!! Question: I can´t use set focus in gallery components... Do you have a tip for this? Sorry, my English it´s not good!
I don’t believe OnFocus is supported on gallery. There is an idea for it. I would recommend to upvote powerusers.microsoft.com/t5/Power-Apps-Ideas/Enable-Set-Focus-in-Gallery-items/idi-p/630177
@@RezaDorrani More than welcome! I do have a question, it may be good to email. I want to use a gallery to divide a budget up to several people already stored in the table.
@@bwebmasta1 I would recommend you post your query/requirements on the forums. Many a times folks have done something similar. powerusers.microsoft.com
Hi Reza ! You are a Life saver ! 1 thing, when you check if changes were made on a specific record, you use an UPDATE function to update the collection, why not using REMOVE to remove the entire record from the collection and than proceed to the collect function again ? Thanks :)
@@RezaDorrani Thanks! a ton. Also, my requirement is only to update records and not add new one. I am populating collection based on a filter. But when I update record using "on change" code on editable controls in grid, it updates the records to blank and even non-editable fields also gets blank in the collection. Any clue?
@@santoshdwivedi726 Not sure. This is something I would have to try out to provide guidance. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Hi Reza, This was really helpful. The way you explained everything is amazing, I wanted to ask how can we do data validation in this grid any way you can suggest ?
Thanks. I have done multiple grid videos. I think I did cover validation in one of them. Check the playlist th-cam.com/play/PLTyFh-qDKAiHeIy4xwTFpz_03poNzPuQU.html
Video description has link to download entire solution. You can check the code base. As for your issue, I would need to look at your app in action to know more about the cause of your issue. I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Hi, I found the problem. Becasue in Excel table there is no primary key, I used Lookup function to identify the row to update in the table.
Great video. I've been querying the data source directly and now want to start looking into collections. I don't know if something has changed in the last couple of years but when I create the empty collection to capture the schema, then clear the collection, it clears the whole thing and gives me a blank table. Any help on this would be appreciated.
I have not come across this issue and hence not sure what is the cause for your issue. I have done newer videos on this topic, I would recommend checking my playlist on grid.
Hi Reza, Its really nice and helpful, I have requirement that I need to disable delete icon for the first item of gallery. Can you help me how to achieve this.
I do not have a video reference on this scenario and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Ciao Reza, kudos for the video: moving from Access to Powerapps, I am having headshakes to understand the logic here, but this video helped a lot! Proposed feature is to add the possibility for users to disable autosaving, similarly to your button for editable. I can't get the Delete button to work when data are connected to SQL Azure... it seems the Remove or RemoveIf does not work... RemoveIf(tblTest, idTblTest = lbl_ID)
It should as long as it relates to a valid ID and your condition matches. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi... Thank you so much for the presentation. I am curious to know if similar grid in power app we can make on top of few SQL data table (instead of share point table) where tables are also having a after trigger to log insert/update/delete on a audit table. Please could you advise?
Absolutely, can be made. Just connect to SQL and use Patch statements against SQL Tables. I have a video coming out next week which shows the grid with Dataverse - th-cam.com/video/vRn7br2OaxE/w-d-xo.html
Loved the video, it's amazing. I am trying to replicate this with a SQL database but facing challenges, which I will post on the forum with snapshot. Just wondering if you can please do more videos with SQL database please. Thank you.
Reason I do not make videos with SQL is because: 1 - SQL requires a database and server setup 2 - SQL is a premium connector I mostly use SharePoint or Dataverse since they are easy to setup and get started with. My goal is always to put forth a concept that can be applied to most data sources.
Excellent...!, thanks for sharing... really helpfull, maybe i'll expand this using header and detail table, on your case (header will be total of task by person name) and (detail was list of task to do) both will using collection first, then if ready, will be push and save to datasource. if that possible ?
Great video Reza, thank you. I followed your example, but on the undo button, it seems like the refresh statement is causing my gallery items to add back to my collection. I've searched the knowledge bases extensively, no luck.
Hi Reza, Thank you for the video. Excellent and easy to follow. Is there a way to add a filter to show the blank rows added along with an another criteria ? I am trying to filter entries based on Location along with any blank rows that are added from the add row button. Please let me know.
@@RezaDorrani Thank you Reza - i have made a separate grid for editing and viewing - However, i am finding that when i add new row enter text and then add a new row the entered information in the first row goes missing - do you have any insights into fixing this please?
@rohithyalamanchali6055 I have not experienced the mentioned issue and hence not sure of the cause or fix for it. I will recommend checking or posting your issue on forums in case someone has experienced something similar community.powerplatform.com/
Thanks, Reza for all the videos. These are of great help to us. I have a similar problem as above with some additional requirements. I have to add the rows, input data, save data in a disconnected state, and upload the data back when again connected to the internet. Would you please help with how this can be done?
Great video Reza, like always! Is there way to input many rows like you did in the beginning (manually) at the same time? Like 30+ I want that the user edit just other columns that are not presets Have you videos talking about it? Thank you
Hi Reza, Thanks for the clear description. I made the same app and everything worked fine untill I wanted to patch my data. The patch functions gives an error called "Invalid argument type (Table), Expecting a Record value instead. Do you know how to solve this?
Video description has link to download the sample solution. You can give that a try. As for your issue, I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Love the statement. "Always think of galleries first"
Galleries is our friend
Indeed so - the InifinityForm concept shown by Clarissa Gillingham works around this concept!
@@TheCRMNinja That surely is an amazing concept
@@TheCRMNinja do you have a link you can share regarding the InfinityForm concept that you mentioned above?
@@RezaDorrani hi Reza , how to create table's
Reza, you certainly not mucking around! Others drag what actually can be done in 5 mins into an hour. Yours is succent and spot on! Love your videos. We neeeeeeeeeed videos like yours!
Thanks so much!
I hope to keep going as long as possible
This is EXACTLY what I need for my app. This has just saved me many hours of trial and error. Thank you, Reza!
Glad to hear that! Thank you for watching.
Me too. Reza, thanks a lot for your explanations!
You are an excelent trainer! Believe me, i've watched a lot of tutorials and I never leave comments. Bravo!
Awesome! Thank you!
I will wait for your next comment 😊
Just watched it again after 6 months...I learn more the second time. Thanks again Reza.
Great to hear! Thanks George.
Reza, thank you so much for this. This will make the users of my app very happy. I was patching directly to the sharepoint list every time the users made a change. This will save hours!! Brilliantly and so simply explained too.
Great to hear and thank you for watching
Your videos are having all the answers popping up in my mind about power app. Sending Lots of Love and Thanks from Chennai.
Wonderful! Thank You!
Explained from basics of power apps so beginners are also getting what you want to say... Really appreciated... Thank you so much
So happy to hear that. Thanks for watching.
Can't explain how much I have learnt from this video... wonderful 👍
Thank you so much
Assalamualkum Mr.Reza,
What a Noble Soul you are. Very rare these days. Mashallah.
Please keep up the good work, you are my virtual guide .
Learnt a lot from scratch , just because of you.
May Allah bless you with Health , Happiness, Prosperity & Emaan.
Regards,
Thanks so much 🙏
Excellent video Reza, fast and not a second wasted. Great!
Thank you
Thanks Reza, that was a brilliant tutorial and thanks for the clarity of the details provided. Very helpful.
Glad it was helpful!
Couldn't say enough thanks to you! This video saved my day🎉
Glad it helped!
Reza you literally saved me hours of work with this video. Thank you very much!
Glad it was helpful! Thank you for watching.
Seriously you are an amazing guy, you sound extremely knowledgeable. I have zero knowledge in coding but the way you are explaining, making me to learn PowerApps. Thank you Reza..
You are most welcome
Galleries ! Yes! Best way to present data in different formats is playing with galleries ! Thanks for this informative video sir ! As always - Precise and helpful !
My pleasure!
Thanks ... I'm taking my first steps on PowerApps, and I found your video very useful. I wish you a great success
Thank You for your kind words & welcome to my channel.
Best of luck on your journey with Power Apps.
Reza, I like all your videos, and you are truly an inspiration for me to use Power Apps/Power Automate. You cover real life issues and struggles, and you are like this one person that gets born to create something amazing and pass it to the others, kind of like Mozart, or Beethove, all your apps are an art!
Thank You so much for your kind words 🙏
Happy to hear the feedback. I started the channel with one goal in mind: "To cover real world use cases" & always try to showcase something new.
Very helpful. Awesome. Now I feel like I am an expert in powerapps.:-) After watching your videos I got more Ideas and I did experiments.
Thank You. So happy to hear the feedback. Keep watching!
I am really impressed by this video. Thanks a ton Mr. Reza. I am bit new to power apps so I learnt lot of things from this
You are very welcome
Another excellent tutorial! Very informative, superbly put together and edited. You are such a gift to those of us learning PowerApps.
Thank You so much for your kind words 🙏
Excellent! This is the best and what I need for my new app. Thanks a bunch. You saved my day.
Glad it helped! Thank you for watching.
Reza, this video with CRUD operations is really cool, but with the UNDO option I don't have words to describe it. Thanks for sharing !!!
You are most welcome!
Perfect lesson. Clear explanation.
Glad you liked it!
I recreated this Excel grid and worked well. Great Video Reza.. Thank you so much
Great to hear!
Suddenly found that you look like Messi, I feel like you are the Messi of the power platform, GOAT!
😊 I’m a big Messi fan
Thanks Reza , i was about of end up trying power apps but your videos' helped me excel
Thank You for watching & liking my videos.
As usual, perfect.
You focus on the subject while redesigning techniques the right way.
Simple, light, for complex scenarios ❤️
Wow, thank you!
Good Day Reza, I need your support to do an horizontal progress bar to reflect the values of 9 columns of Yes/No. To count the “Yes” and progress till reaches 100.
If you have similar video, please share, or if you have any similar component or anything that can help? ❤️
@@ehabatme5324 Do not have anything on this use case. Check on the community forum.
Excellent tutorial, Reza. Lots of great ideas.
Glad it was helpful!
one word, Awesome! Its not about how you teach, Its only about what you teach 👍👏. Somewhere I have a feeling that you know what an user wants ✌
Thank You for your kind words. Goal of my videos is always to provide value and showcase common issues/features/ideas.
@@RezaDorrani Thank you so much for you efforts 👍
Reza, Wow! I'm immensely Grateful for all your exceptional experience you share so coherently🙌
My pleasure!
Reza, Most kind thank you, As always you make it perfectly with answering questions that might popup 👌👍👏👏👏
My pleasure!
I do have a latest version of this as well. th-cam.com/video/wI6SHGQ9ATg/w-d-xo.html
Yes, Auto save thing , I was looking for. Thanks a lot for quick reply.
Welcome 👍
This is awesome!! This is exactly I was looking for! Thanks!!!!!!!!!
You are most welcome!
Absolutely fantastic. Thanks a lot for sharing such good content.
Most welcome and thanks for watching
Hi Reza, you're the best in Power Apps. :):):)
Thank you 😊
Brilliant stuff. Thanks a bunch for this amazing video, Reza!
Glad you enjoyed it!
Fantastic explanation Reza! Thank you.
Glad you enjoyed it!
Reza: your channel is, by far, the best Power Apps TH-cam channel. Can I hire you for a consulting project?
My email is reza.dorrani@outlook.com
Really great video and clearly explained. I always wanted to make this grid functionality by using some custom jsgrid with rest api calls.. Now this solution has made much more simpler than this. I really wanted to try out with SP list having more than 5k records and need to try paging, sorting, filtering in this grid.
Thanks again Reza for this wonderful video.
Thank you for such amazing feedback.
The description of this video contains a link to download the entire solution.
I also have videos on my channel with SharePoint and delegation that will help working with large data sources (5k records).
My next video is planned to be around filtering. I hope that one is useful as well.
I have watched all your videos and it is very helpful. Great work 👏👏
Thank you for watching all my videos
This awesome.....
You have all scenario covered as per my current projects 🥳🥳🥳🥳🥳🥳
Great going.... Very very much. Helpful
Glad to hear that the videos are helpful
@@RezaDorrani out of context of this video.
Want to know if you have any video, when flow return stringify JSON in "response to PowerApps" and string is collected and saved in PowerApps, then how to convert that to collections.
Tried many things but not working.
Thanks for help in advance.
@@raj7sam I do not have a video on that. Tried it in one project and was a complex undertaking.
Very well explained. In my case it's loading the excel in other tab of browser rather than download.
The video does not show downloading an excel file.
@@RezaDorrani opps right comment on wrong video
Reaza excellent session ,rely appreciate, thank lot for a video
You are most welcome
nice, very clear explanation.
Thanks
Reza, thanks for helping me again :)
Your most welcome
Thank you so much for this video, well explained😊
My pleasure 😊
You are a genius!
Thank you! Just trying my best to explain Power Platform concepts in a simple way.
Superb, thanks Reza....
You are most welcome
I really enjoy your videos!!
Thank You
Great Videa Reza, many thanks!
My pleasure!
Great tutorial !!!!
Thanks
It's simply amazing. 😍 🎉
Thank you!
This helped tons, thanks!
Welcome
Amazing intuitive video.
Glad you liked it
Excellent video, very well explained 👍
Thank you! 👍
Very well presented as usual. Thank you😊
You are most welcome
Thanks for sharing, excellent video. I would like to add an idea on the "Change mode of Grid view" when it's on View Mode we should stop the timer from running to avoid queries with no data.
That's a great idea! I should have added that in there :)
Thank you, great example, muchisimas gracias un gran ejemplo, muy util
gracias
really good video, which exactly i am looking for.
Great to hear
So much useful. Truly loved it 😍
Thank you so much
Hi Reza, Thank you for all the videos, so helpful!
When I create this app from a SharePoint list, the save button refreshes the collection (as if running ClearCollect) so that the warning messages for unsaved changes light up on all items. If I click the button again, it clears the collection and the warnings.
When I create from a Dataverse table as in your example, it works as expected. Ideally, would like to run this from the SharePoint list. Any thoughts on what might be happening?
I have a video on SharePoint List based Grid.
th-cam.com/video/wI6SHGQ9ATg/w-d-xo.html
Video description also has link to download sample App.
Make sure you do not use combo boxes as they cause issues in grids.
Amazing content!
Thanks Edwin
Thank you for this video, is is possible to certain grid field required base on another field on the grid.
Possible but not something I have tried
Hello, how are you ?
I'm from Brazil and I'm loving your videos. Will you allow me to use these examples to teach people here?
Hello, all my videos are meant for sharing. Feel free to use them. Thank you for doing this.
Great case dealt with clarity, as usual Reza! I faced one problem though which is the gallery items resetting, and probably triggering OnChange action, upon executing patch as provided in Add row. Thus, this pushes all items from gallery to the Collections and not the only one changed, when Add row is clicked. Any way to resolve this? Thank.
Thanks!
I have not faced that issue based on technique should in video. Also, I have done 3-4 more grid based videos showcasing different approaches. Check those and see if they help.
Thanks Reza for this wonderful tutorial ! Very very useful indeed. If I may ask you a question please ?
In my project I have 3 different screens, each of which will have an Editable Table/Grid (like the one you have shown in this video). In this case, the user is expected to input data from different (but similarly structured) Excel files into these grid tables. The Excel files are like templates and values to be input are very conveniently arranged in a row. The user needs to copy only one (or two) row(s) from each Excel file into the Grid Table. So ideally, it would be very time-saving for the user, if he/she could simply copy the row from the Excel file and paste the same to the Grid Table (in PowerApps). This will not only save time but it can potentially reduce errors in manual data entry.
In short, is it possible to copy rows from Excel file (one row at a time is fine) and paste the same into a corresponding row in the Grid table ? (Of course, we will design the Grid tables so that the columns in the Grid match exactly with the columns in the Excel file).
Thanks in advance for any advice you may have !
Thank you for watching.
Copy paste is not a feature in Power Apps. User would have to copy cell by cell and paste which is not ideal.
I can think of a case where we could leverage flow to read data from an excel file and populate the table. Sounds simple but will require some amount of effort to build.
@@RezaDorrani Thanks for your response ! Yes, this seems like a more complicated issue to solve. Wish Microsoft made copy/paste possible in this case.
In any case, there is so much that I have learnt from your videos. You are awesome :-).
🤓👏👏👏👏👏👏 thank you for this perfect video!!!!
You're so welcome!
Thanks a lot for an excellent video. You made my day.
I have a requirement. Do not patch the data source until user fills all the mandatory fields. I have created a collection & added the records to this collection whenever user clicks on "Add" button. My question is how to make sure that user fills all the mandatory fields in the collection. Your timely reply would be highly appreciated. Thanks once again for this great video.
Most welcome.
Its been a long while since I did this hence do not remember the specifics. I have done 4-5 videos on grids and put them in a playlist. May be I did show mandatory validation in one of them. Alternatively, I would also recommend posting your query on forums in case someone has done something similar powerusers.microsoft.com
Super to the point video. Thanks Reza
My pleasure
Thank you for this valuable sharing on how to create editable table in powerapps Reza. I would like to ask if I can use the same procedure using my SharePoint list as the data source?
Check th-cam.com/video/wI6SHGQ9ATg/w-d-xo.html link and also its comments.
@@RezaDorrani Will do, thank you for your support! :)
Excellent video
Well presented :)
Wanted to check what would be max records to display pulling from CDS at one time ?
The gallery was conncected live to the data source (no collection set as Items property).
Since my App had no delegation warnings the gallery will load data from CDS in batches of 100 in a performant and optimized manner.
So really no limit as the records are being fetched in batches.
This is gold.
Thanks
@RezaDorrani
You are a great teacher! Thanks for share !!!
Question: I can´t use set focus in gallery components... Do you have a tip for this?
Sorry, my English it´s not good!
I don’t believe OnFocus is supported on gallery. There is an idea for it. I would recommend to upvote powerusers.microsoft.com/t5/Power-Apps-Ideas/Enable-Set-Focus-in-Gallery-items/idi-p/630177
Excellent video! Subscribed! I have a budget project similar that this helps with.
Thanks for the sub!
@@RezaDorrani More than welcome! I do have a question, it may be good to email. I want to use a gallery to divide a budget up to several people already stored in the table.
@@bwebmasta1 I would recommend you post your query/requirements on the forums. Many a times folks have done something similar.
powerusers.microsoft.com
@@RezaDorrani Great idea, I am in that forum & Automate as well.
Hi Reza ! You are a Life saver ! 1 thing, when you check if changes were made on a specific record, you use an UPDATE function to update the collection, why not using REMOVE to remove the entire record from the collection and than proceed to the collect function again ? Thanks :)
Most welcome!
Its been a long while since I did this so do not remember why I did something.
If remove works for you then use it :)
@@RezaDorrani Oh - I thought you had a reason and i missed somthing ! thanks, as usual, a true hero!
@@adirnagar6940 I don’t remember to be honest. If remove works then please use it.
Can't wait for it 👏🔥🔥🔥
Hope the wait is worthed
Waiting. Hopefully more easier than smartsheet.😁
Lol. Not so easy but hopefully I have explained it in a simple manner.
This is helpfull how can I connect this same grid with a dropdown and automatically add number of rows depending on the selection of the dropdown
Possible, but I do not have a video on that use case.
I will recommend you check on the forums at powerusers.microsoft.com/
Thanks! Reza for another awesome and very useful video. How to add an attachment column from SharePoint list (data source) to the the grid?
Thank You. Attachments is part of my video coming next week.
@@RezaDorrani Thanks! a ton. Also, my requirement is only to update records and not add new one. I am populating collection based on a filter. But when I update record using "on change" code on editable controls in grid, it updates the records to blank and even non-editable fields also gets blank in the collection. Any clue?
@@santoshdwivedi726 Not sure. This is something I would have to try out to provide guidance. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Hi Reza,
This was really helpful. The way you explained everything is amazing, I wanted to ask how can we do data validation in this grid any way you can suggest ?
Thanks.
I have done multiple grid videos. I think I did cover validation in one of them.
Check the playlist th-cam.com/play/PLTyFh-qDKAiHeIy4xwTFpz_03poNzPuQU.html
Thanks for sharing. I have question for my apps. How can update value on gallery and edit form on same row?
A form control cannot be inside a gallery, but can be connected to it.
Check th-cam.com/video/HHXKfB1iAH4/w-d-xo.html
Thx for ur efforts
My pleasure!
Thank you Mr. Reza!
👍
Very nice and clear video as usual. I try to do the same with an Excel table but on save a new row is always created, any advice? Thank you in advance
Video description has link to download entire solution. You can check the code base.
As for your issue, I would need to look at your app in action to know more about the cause of your issue. I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Hi, I found the problem. Becasue in Excel table there is no primary key, I used Lookup function to identify the row to update in the table.
Great video. I've been querying the data source directly and now want to start looking into collections. I don't know if something has changed in the last couple of years but when I create the empty collection to capture the schema, then clear the collection, it clears the whole thing and gives me a blank table. Any help on this would be appreciated.
I have not come across this issue and hence not sure what is the cause for your issue.
I have done newer videos on this topic, I would recommend checking my playlist on grid.
Just found it. WOW you actually responded. Thank you so much.@@RezaDorrani
Hi Reza, Its really nice and helpful, I have requirement that I need to disable delete icon for the first item of gallery. Can you help me how to achieve this.
I do not have a video reference on this scenario and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Ciao Reza, kudos for the video: moving from Access to Powerapps, I am having headshakes to understand the logic here, but this video helped a lot!
Proposed feature is to add the possibility for users to disable autosaving, similarly to your button for editable.
I can't get the Delete button to work when data are connected to SQL Azure... it seems the Remove or RemoveIf does not work... RemoveIf(tblTest, idTblTest = lbl_ID)
It should as long as it relates to a valid ID and your condition matches.
I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
perfect for power platform learners
Great! Thanks for watching.
Hi... Thank you so much for the presentation. I am curious to know if similar grid in power app we can make on top of few SQL data table (instead of share point table) where tables are also having a after trigger to log insert/update/delete on a audit table. Please could you advise?
Absolutely, can be made.
Just connect to SQL and use Patch statements against SQL Tables.
I have a video coming out next week which shows the grid with Dataverse - th-cam.com/video/vRn7br2OaxE/w-d-xo.html
Loved the video, it's amazing.
I am trying to replicate this with a SQL database but facing challenges, which I will post on the forum with snapshot. Just wondering if you can please do more videos with SQL database please.
Thank you.
Reason I do not make videos with SQL is because:
1 - SQL requires a database and server setup
2 - SQL is a premium connector
I mostly use SharePoint or Dataverse since they are easy to setup and get started with.
My goal is always to put forth a concept that can be applied to most data sources.
I am looking to do SQL as well. I can query sequel from Power Apps, haven't tried the write yet.
Excellent...!, thanks for sharing... really helpfull, maybe i'll expand this using header and detail table,
on your case (header will be total of task by person name) and (detail was list of task to do) both will using collection first,
then if ready, will be push and save to datasource. if that possible ?
Possible. Many have extended this App for their business use cases.
Great video Reza, thank you. I followed your example, but on the undo button, it seems like the refresh statement is causing my gallery items to add back to my collection. I've searched the knowledge bases extensively, no luck.
Video description has link to download the sample solution. You can check the exact code by installing it.
Hi Reza, Thank you for the video. Excellent and easy to follow. Is there a way to add a filter to show the blank rows added along with an another criteria ? I am trying to filter entries based on Location along with any blank rows that are added from the add row button. Please let me know.
I would have to try that scenario out to know how. It's been a long while since I did this video.
@@RezaDorrani Thank you Reza - i have made a separate grid for editing and viewing - However, i am finding that when i add new row enter text and then add a new row the entered information in the first row goes missing - do you have any insights into fixing this please?
@rohithyalamanchali6055
I have not experienced the mentioned issue and hence not sure of the cause or fix for it.
I will recommend checking or posting your issue on forums in case someone has experienced something similar
community.powerplatform.com/
Saving the day once again, the only thing i need to figure out is how to send an email based on the due date or approaching due date.
th-cam.com/video/VnWg-Eox37Q/w-d-xo.html video may help.
Thanks, Reza for all the videos. These are of great help to us. I have a similar problem as above with some additional requirements. I have to add the rows, input data, save data in a disconnected state, and upload the data back when again connected to the internet. Would you please help with how this can be done?
I have done no videos on canvas offline. You will need to explore loaddata and savedata functions to see how this could be done.
@@RezaDorrani Thanks for the suggestion.
I'm ready for this!!!
Edited this video 3 times. Wanted to make sure it stays with 30 mins.
@@RezaDorrani no worries, even if it's longer than that, it will be worth it. I already set up the reminder!
@@tenisviejos Thank You.
I will be live on the chat during the video premiere.
Excellent !!!
Thank you
Great video Reza, like always!
Is there way to input many rows like you did in the beginning (manually) at the same time? Like 30+ I want that the user edit just other columns that are not presets
Have you videos talking about it?
Thank you
Check my playlist on grids - th-cam.com/play/PLTyFh-qDKAiHeIy4xwTFpz_03poNzPuQU.html
Hi Reza, Thanks for the clear description. I made the same app and everything worked fine untill I wanted to patch my data. The patch functions gives an error called "Invalid argument type (Table), Expecting a Record value instead. Do you know how to solve this?
Video description has link to download the sample solution. You can give that a try.
As for your issue, I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com