Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Canvas App Editable Grid > How to add a new record?

Hello All,


I'm working on building the editable grid from the SharePoint list and I followed this link - How to Create a Responsive Editable Grid in Canvas App (


I've below questions regarding adding a new record. 

Question 1 : How do I make this editable grid as insert ONLY grid for the Bulk insert purpose? I don't want to bind the existing dataset records in it as shown in below image. Shall I remove the dataset from the DataSource property?  




Question 2 : I've a '+' icon button on top of the screen and OnSelect, I want to add new blank row record at the bottom for inserting a new record. How do I achieve this? I tried this formula OnSelect, but it doesn't seem to be working. Patch(Contacts,Defaults(Contacts),{'First Name':"",'Last Name':""})


Thank you.


Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,470)