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 (powerobjects.com)
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.

Report
All responses (
Answers (