Hi hoping someone can help me here. I am trying to add a form to allow users to create a new record in and SQL table hosted on Azure.
The strange thing is, I can add edit forms when using some tables in the database, but not others.
For on specific table it will only allow me to view not edit or add.
I have tried adding a button control with NewForm(MyForm) but this does nothing.
Is there something I am missing here. All the tables were created in the same way at the same time
Solved! Go to Solution.
For EditForm, two things that you need to take a check:
1. DefaultMode property,
It has three value type, Edit, View, New
If you would like to Create New record, then please make sure the Defaultmode is set to FormMode.New.
For more information about how to work with form control in PowerApps, see:
Thanks for your response. I have tried changing the default property to no avail. Interestingly this problem only exists for certain data sources. I have 4 tables in an SQL server and I can easily add a form with default.new as the property for three out of the four tables. It's just one table giving me the problem. I will try deleting the table from the SQL server and recreating it. That might help.
Read the announcement for more information!
Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.
Features releasing from October 2019 through March 2020
Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications