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.
Check out new user group experience and if you are a leader please create your group
We are excited to announce that Demo Extravaganza for 2021 has started!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Don't miss the call this month on June 16th - 8a PDT