Power Apps Editable Table/Gallery like Excel (Tutorial)

#PowerApps #EditableTable #EditableGrid #InlineEditing #EditableGallery
In this video on Power Apps Editable Excel like Gallery or Table (Tutorial), we will go through a step-by-step tutorial of creating an Excel like Editable table/grid. This is like the Quick Edit Mode in SharePoint lists/libraries or the Grid view in Dataverse for Teams or InfoPath repeating tables.
We will use Power Apps Galleries to create the editable grid and live update our data source.
Video covers the following:
✅ Style gallery to look like an editable grid
✅ Add a new row or record to the grid
✅ Record grid updates in a collection and patch all the changes with a single query (performance boost)
✅ Delete a row or record in the grid
✅ Put grid in view mode or edit mode
✅ Undo grid updates
✅ Auto-save grid updates using timer control
Here's a link to download the sample solution:
github.com/rdorrani/PowerApps...
Solution includes Dataverse Tables, Choices column and the Power App.
**Please note: You need to import the zip file as a solution.**
Table of Contents:
00:00 - Intro
00:42- What is an editable grid/table
01:32 - Data source information
02:55 - Building and styling the Editable Table
04:22 - Add New Row to the Table
08:50 - Delete Row from the Table
09:36 - Update Rows & bulk Patch data from the Table
23:48 - Auto Save Grid/Table data
25:30 - Change Mode of Grid View
27:34 - Undo changes in Grid/Table

[@DanielChristian19]

Love the statement. "Always think of galleries first"

[@RezaDorrani]

Galleries is our friend

[@TheCRMNinja]

Indeed so - the InifinityForm concept shown by Clarissa Gillingham works around this concept!

[@RezaDorrani]

@@TheCRMNinja That surely is an amazing concept

[@johnheck1551]

@@TheCRMNinja do you have a link you can share regarding the InfinityForm concept that you mentioned above?

[@kusumamuralik625]

@@RezaDorrani hi Reza , how to create table's

[@logiman]

This is EXACTLY what I need for my app. This has just saved me many hours of trial and error. Thank you, Reza!

[@RezaDorrani]

Glad to hear that! Thank you for watching.

[@vladimirpeshkov4846]

Me too. Reza, thanks a lot for your explanations!

[@munkybutler1]

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.

[@RezaDorrani]

Great to hear and thank you for watching

[@ehabatme5324]

As usual, perfect. You focus on the subject while redesigning techniques the right way. Simple, light, for complex scenarios ❤️

[@RezaDorrani]

Wow, thank you!

[@ehabatme5324]

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? ❤️

[@RezaDorrani]

@@ehabatme5324 Do not have anything on this use case. Check on the community forum.

[@ventureinozaustralia7619]

Excellent video Reza, fast and not a second wasted. Great!

[@RezaDorrani]

Thank you

[@u1sweety]

You are an excelent trainer! Believe me, i've watched a lot of tutorials and I never leave comments. Bravo!

[@RezaDorrani]

Awesome! Thank you! I will wait for your next comment 😊

[@RadoslavovK]

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!

[@RezaDorrani]

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.

[@truptinalnikar]

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 !

[@RezaDorrani]

My pleasure!

[@RudeyCapone]

Brilliant stuff. Thanks a bunch for this amazing video, Reza!

[@RezaDorrani]

Glad you enjoyed it!

[@ourhappiness...khushi5212]

Explained from basics of power apps so beginners are also getting what you want to say... Really appreciated... Thank you so much

[@RezaDorrani]

So happy to hear that. Thanks for watching.

[@samehsabet7566]

Another excellent tutorial! Very informative, superbly put together and edited. You are such a gift to those of us learning PowerApps.

[@RezaDorrani]

Thank You so much for your kind words 🙏

[@wmcnabb]

Reza you literally saved me hours of work with this video. Thank you very much!

[@RezaDorrani]

Glad it was helpful! Thank you for watching.

[@jayadeeppv821]

Thanks Reza, that was a brilliant tutorial and thanks for the clarity of the details provided. Very helpful.

[@RezaDorrani]

Glad it was helpful!

[@limitlessartsglobalsouthaf342]

Reza, Wow! I'm immensely Grateful for all your exceptional experience you share so coherently🙌

[@RezaDorrani]

My pleasure!

[@georgeellis5237]

Just watched it again after 6 months...I learn more the second time. Thanks again Reza.

[@RezaDorrani]

Great to hear! Thanks George.

[@Sustainable.149]

Reza, Most kind thank you, As always you make it perfectly with answering questions that might popup 👌👍👏👏👏

[@RezaDorrani]

My pleasure! I do have a latest version of this as well. kzbin.info/www/bejne/rXqZhHt9hp50isk

[@such1]

Yes, Auto save thing , I was looking for. Thanks a lot for quick reply.

[@RezaDorrani]

Welcome 👍

[@anilkumar-ml2sl]

Can't explain how much I have learnt from this video... wonderful 👍

[@RezaDorrani]

Thank you so much

[@Nalada2007]

Excellent! This is the best and what I need for my new app. Thanks a bunch. You saved my day.

[@RezaDorrani]

Glad it helped! Thank you for watching.

[@krishnabairi1581]

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

[@RezaDorrani]

You are most welcome

[@NaveenKumar-lm7qj]

I recreated this Excel grid and worked well. Great Video Reza.. Thank you so much

[@RezaDorrani]

Great to hear!

[@kirankumari1985]

This is awesome!! This is exactly I was looking for! Thanks!!!!!!!!!

[@RezaDorrani]

You are most welcome!

[@karukarthi2609]

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.

[@RezaDorrani]

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.

[@CookWithNouriMuhammad]

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,

[@RezaDorrani]

Thanks so much 🙏

[@rgil78]

Absolutely fantastic. Thanks a lot for sharing such good content.

[@RezaDorrani]

Most welcome and thanks for watching

[@georgeellis5237]

Fantastic explanation Reza! Thank you.

[@RezaDorrani]

Glad you enjoyed it!

[@ganpathji]

Your videos are having all the answers popping up in my mind about power app. Sending Lots of Love and Thanks from Chennai.

[@RezaDorrani]

Wonderful! Thank You!

[@majdyazigi8185]

I really enjoy your videos!!

[@RezaDorrani]

Thank You

[@andreahbon20]

Excellent tutorial, Reza. Lots of great ideas.

[@RezaDorrani]

Glad it was helpful!

[@prajwalskateel]

I have watched all your videos and it is very helpful. Great work 👏👏

[@RezaDorrani]

Thank you for watching all my videos

[@adanielmacedo]

Thanks ... I'm taking my first steps on PowerApps, and I found your video very useful. I wish you a great success

[@RezaDorrani]

Thank You for your kind words & welcome to my channel. Best of luck on your journey with Power Apps.

[@vladimirpeshkov4846]

Perfect lesson. Clear explanation.

[@RezaDorrani]

Glad you liked it!

[@satryoanugerahwibowo2408]

Can't wait for it 👏🔥🔥🔥

[@RezaDorrani]

Hope the wait is worthed

[@Michael_Burris]

This helped tons, thanks!

[@RezaDorrani]

Welcome

[@nishachoudhary7639]

Thank you so much for this video, well explained😊

[@RezaDorrani]

My pleasure 😊

[@abnavalagatti]

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

[@RezaDorrani]

You are very welcome

[@FadyAnwarS]

Very well presented as usual. Thank you😊

[@RezaDorrani]

You are most welcome

[@nikhiltiwari8482]

So much useful. Truly loved it 😍

[@RezaDorrani]

Thank you so much

[@nunobarbosa4753]

Great Videa Reza, many thanks!

[@RezaDorrani]

My pleasure!

[@Samshujayanagar]

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 ✌

[@RezaDorrani]

Thank You for your kind words. Goal of my videos is always to provide value and showcase common issues/features/ideas.

[@Samshujayanagar]

@@RezaDorrani Thank you so much for you efforts 👍

[@oricchannel2811]

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

[@RezaDorrani]

You are most welcome!

[@maciejszczypek817]

Reza, thanks for helping me again :)

[@RezaDorrani]

Your most welcome

[@jemi4364]

Super to the point video. Thanks Reza

[@RezaDorrani]

My pleasure

[@NobuAtreides]

Thank you, great example, muchisimas gracias un gran ejemplo, muy util

[@RezaDorrani]

gracias

[@markjosephlagan3150]

I can't wait ! :)

[@RezaDorrani]

Same here. Just that I can’t wait to see the response.

[@ajit382]

Reaza excellent session ,rely appreciate, thank lot for a video

[@RezaDorrani]

You are most welcome

[@tenisviejos]

I'm ready for this!!!

[@RezaDorrani]

Edited this video 3 times. Wanted to make sure it stays with 30 mins.

[@tenisviejos]

@@RezaDorrani no worries, even if it's longer than that, it will be worth it. I already set up the reminder!

[@RezaDorrani]

@@tenisviejos Thank You. I will be live on the chat during the video premiere.

[@frederickching1142]

Thank you Mr. Reza!

[@RezaDorrani]

👍

[@this.developer415]

Great tutorial !!!!

[@RezaDorrani]

Thanks

[@Deadpool12353]

Amazing intuitive video.

[@RezaDorrani]

Glad you liked it

[@rahulkurwe1492]

Excellent video, very well explained 👍

[@RezaDorrani]

Thank you! 👍

[@remoanil8532]

Thanks Reza , i was about of end up trying power apps but your videos' helped me excel

[@RezaDorrani]

Thank You for watching & liking my videos.

[@NIKUNJPATEL-si1ep]

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.

[@RezaDorrani]

Thank You. So happy to hear the feedback. Keep watching!

[@ricolaterreur7339]

🤓👏👏👏👏👏👏 thank you for this perfect video!!!!

[@RezaDorrani]

You're so welcome!

[@subrataranjanpal6518]

Excellent !!!

[@RezaDorrani]

Thank you

[@edwinjonah]

Amazing content!

[@RezaDorrani]

Thanks Edwin

[@GreyDob]

You are a genius!

[@RezaDorrani]

Thank you! Just trying my best to explain Power Platform concepts in a simple way.

[@varaprasadlakshmi5110]

Superb, thanks Reza....

[@RezaDorrani]

You are most welcome

[@kevindibb6534]

This is gold.

[@RezaDorrani]

Thanks

[@rayhuang1712]

really good video, which exactly i am looking for.

[@RezaDorrani]

Great to hear

[@user-qo1tm7ze4f]

nice, very clear explanation.

[@RezaDorrani]

Thanks

[@ExcelExciting]

Awesome 😎 👍🏻

[@RezaDorrani]

Thank you! Cheers!

[@garimatewari2212]

It's simply amazing. 😍 🎉

[@RezaDorrani]

Thank you!

[@kavirenga]

Nice Job!

[@RezaDorrani]

Thank you

[@AvikMukherjee1984]

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?

[@RezaDorrani]

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 - kzbin.info/www/bejne/rIPRaJWoZ7SUrqc

[@sunshinelabz]

Excellent video Well presented :) Wanted to check what would be max records to display pulling from CDS at one time ?

[@RezaDorrani]

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.

[@raj7sam]

This awesome..... You have all scenario covered as per my current projects 🥳🥳🥳🥳🥳🥳 Great going.... Very very much. Helpful

[@RezaDorrani]

Glad to hear that the videos are helpful

[@raj7sam]

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

[@RezaDorrani]

@@raj7sam I do not have a video on that. Tried it in one project and was a complex undertaking.

[@EasyLife2035]

Hi Reza, you're the best in Power Apps. :):):)

[@RezaDorrani]

Thank you 😊

[@mohamedamine7839]

Thx for ur efforts

[@RezaDorrani]

My pleasure!

[@shaundenholm8433]

Hi Reza, This is a great demo of how to create repeating tables. This is something we use often at my workplace. We have always used collections as the data for our repeating tables to display the data rather than the data direct from the datasource as you have in your video. Then onchange we would update the collections data. This would cause the gallery to refresh and the input that the user is currently in would lose focus. This isn't the best user experience, and following your demo you mostly get around this issue; however, I have noticed that after making changes to a cell, and then clicking the delete button on another row will reset the changed cell to the data within the datasource. Do you have anyway around this? Thank you in advance.

[@RezaDorrani]

I have done multiple grid-based videos showcase different techniques. Collections is the best way to do it. Here is my video on it - kzbin.info/www/bejne/rXqZhHt9hp50isk

[@cedarhurstdev3590]

THIS IS EPIC

[@RezaDorrani]

Thank You

[@hizke1]

Thank you sir.

[@RezaDorrani]

Most welcome

[@eli.jiah.meowmeow]

Hi Reza! This is super helpful. Thank you. Question: Is there a way to populate a Word document with the data from these tables? I am trying to build a proposal where products can be added to a list, like in the table you created, but porposal must be in Word (first then PDF). Haven't yet been able to find a solution.

[@RezaDorrani]

Possible. I do not have any video reference though for this use case. Idea would be to query flow, flow to use word online business connector to populate the data, then store than file in OneDrive and convert it to PDF.

[@reneramirez17]

@@RezaDorrani Any videos since this replay? I am very interested in this as well. I love your videos they are awesome!!

[@RezaDorrani]

@@reneramirez17 No videos since. I did not get many requests on this topic.

[@julien8979]

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.

[@RezaDorrani]

That's a great idea! I should have added that in there :)

[@colinadevivero]

Reza: your channel is, by far, the best Power Apps KZbin channel. Can I hire you for a consulting project?

[@RezaDorrani]

My email is [e-mail]

[@prasadsirigiri]

perfect for power platform learners

[@RezaDorrani]

Great! Thanks for watching.

[@bwebmasta1]

Excellent video! Subscribed! I have a budget project similar that this helps with.

[@RezaDorrani]

Thanks for the sub!

[@bwebmasta1]

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

[@RezaDorrani]

@@bwebmasta1 I would recommend you post your query/requirements on the forums. Many a times folks have done something similar. powerusers.microsoft.com

[@bwebmasta1]

@@RezaDorrani Great idea, I am in that forum & Automate as well.

[@appelsinism]

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 !

[@RezaDorrani]

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.

[@appelsinism]

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

[@sushil3np]

Thank you for this video, is is possible to certain grid field required base on another field on the grid.

[@RezaDorrani]

Possible but not something I have tried

[@danielrumbak2530]

Hi Reza, I learned a lot from this video. Thanks again for the amazing, rich content. Is it possible to make the gallery scroll laterally like a sharepoint list if there are lots of columns? If so how would the headers move with the gallery?

[@RezaDorrani]

Horizontal scroll is not possible. Data Table has the horizontal scroll but then it does not provide an editable grid.

[@danielrumbak2530]

This helps me tremendously! Thank you again as always!

[@SheaStith]

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?

[@RezaDorrani]

I have a video on SharePoint List based Grid. kzbin.info/www/bejne/rXqZhHt9hp50isk Video description also has link to download sample App. Make sure you do not use combo boxes as they cause issues in grids.

[@ankushkhosla]

This is really helpful and making an excel like experience available within PowerApps. Have a quick question - can we update the Add Steps function to allow Saving the existing data in the Collection and add a new row. It appears, if I update Steps and add more steps, the gallery gets refreshed from SharePoint list and removes all the data from the gallery. Thanks in advance.

[@RezaDorrani]

Yes. On add step, you can add that to the collection as well. That ways the only way to save data is by clicking on the save button. I recently did an updated video on the grid gallery view, check kzbin.info/www/bejne/rIPRaJWoZ7SUrqc

[@sahilsinghal9472]

This is gold

[@RezaDorrani]

👍

[@SushilPandey-dq7p]

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.

[@RezaDorrani]

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.

[@nilesh2874]

Really great video and help to save bulk records in data source(SharePoint). I downloaded the sample application which you provided along with this video and made modification as per my requirement(for example added multiple text input control). One issue observed in this sample app is when I enter something in text input in gallery and use tab key to move to next control then focus jump back to first control and not able to enter the value in next control. When I explicitly click on next control using mouse then only it allow to enter the value in next control. If I remove the patch code from onselect event in gallery then it work perfectly. Can you help me to resolve this issue by keeping patch code in onselect event along with using tab key

[@RezaDorrani]

Since the gallery items property and the patch function are on the same source, the gallery will refresh. I have done multiple grid videos. Here is another version of it - kzbin.info/www/bejne/rXqZhHt9hp50isk

[@jjayceeb]

Waiting. Hopefully more easier than smartsheet.😁

[@RezaDorrani]

Lol. Not so easy but hopefully I have explained it in a simple manner.

[@itamarconceicao6708]

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

[@RezaDorrani]

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

[@Tiago22049316]

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

[@RezaDorrani]

Check my playlist on grids - kzbin.info/aero/PLTyFh-qDKAiHeIy4xwTFpz_03poNzPuQU

[@andrewz61]

Great wideo.

[@RezaDorrani]

Thank You

[@satpathyshubham]

Very well explained. In my case it's loading the excel in other tab of browser rather than download.

[@RezaDorrani]

The video does not show downloading an excel file.

[@satpathyshubham]

@@RezaDorrani opps right comment on wrong video

[@arifismayilli6936]

Perfect

[@RezaDorrani]

Thanks

[@digdemozturk5485]

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?

[@RezaDorrani]

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

[@shashankpawitwar4355]

Hi Reza, 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?

[@RezaDorrani]

When user selects delete, you will have to handle 2 cases. 1 - user added item which is in collection, so just delete it from collection. 2 - item is a part of the data source, in this case you would first need to push all pending changes to the data source and then delete that item from data source. Would be best to show delete feature after all edits are saved to data source.

[@jhormangomez2268]

Awesome

[@RezaDorrani]

Thank you!

[@murthyc858]

Nice one always , Q) Any feasibility to import some data with same column names over excel to grid and add some additional columns in grid to do sum of column b & total no of orders(columns) etc..?

[@RezaDorrani]

You cannot directly copy paste into the grid from excel. You could use flow to read data and populate the grid. Sum and calculations is possible.

[@andres777video]

Great video, Thanks so much... I'm trying to follow it to update a simple SQL Server Table with a primary column Id, but as soon as I finish entering the Patch code for the OnChange, I get an error on both my Text columns...(only updating 2 Text columns) : Name isn't valid. The identifier isn't recognized... could this be one of the PowerApp glitches that forces you to get out and start again ? Solved: Removed and added All field's Default values again...

[@RezaDorrani]

Looks like you got it to work. Great 👍

[@madihasalman1]

Hi Reza Great videos, I have one question if you have textcolumn in dataverse , and in PowerApp one checkbox. I want to store Yes or No in table if checkbox is clicked or not . How to do this

[@RezaDorrani]

When storing info for the text column in dataverse use the follwing - If(Checkbox1.Value,"yes","no")

[@tejaskshirsagar933]

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 ?

[@RezaDorrani]

Thanks. I have done multiple grid videos. I think I did cover validation in one of them. Check the playlist kzbin.info/aero/PLTyFh-qDKAiHeIy4xwTFpz_03poNzPuQU

[@melodiehecht9489]

Hi Reza - Love, love, love the video! Great job! I'm working through this scenario and am having trouble with the date picker field. In my scenario, I want the date in SQL to display in the form AND be editable by the end user. I can pull the date in just fine, but when I change it to a Input > Date picker, it won't resolve the ThisItem sytax. Can you show me the error of my ways?

[@RezaDorrani]

Thanks for liking the video :) I would have to see your App in action to know more about your issue and provide guidance. I would recommend to post your issue with screenshots on the forums at powerusers.microsoft.com

[@melodiehecht9489]

@@RezaDorrani Will do! Thanks!!!

[@carmelocabanilla3433]

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?

[@RezaDorrani]

Check kzbin.info/www/bejne/rXqZhHt9hp50isk link and also its comments.

[@carmelocabanilla3433]

@@RezaDorrani Will do, thank you for your support! :)