I have a SQL table: ActionsDB
It has 12 columns. One of which is called ID and is set to (PK, int, not null)
My app has a collection called Actions. Where the user submits information pertaining to the columns e.g. Action Description.
Once they are complete I'd like them to be able to submit this to the table. Potentially more than one row at a time as there could be multiple actions.
I'm having zero luck getting around the ID column. It autogenerates within the SQL Table which is required to edit the data in PowerApps.
What am I missing? If I open a new form I can edit straight in but this isn't the desired effect I would like for the app or user.
None of the formulas show an error once completely written out, columns all match.
So what you are seeing is the patch does not actually insert a table into the DB? There are couple of things you can try, first, turn on the PowerApps monitor, this will allow you to see all calls to the DB with what is sent and what comes back.
I typically use the Patch command when writing to SQL or passing JSON for multiple records to a Flow that calls a stored procedure and let the stored proc do all the work.
Hope this help.
This is my formula:
All I get is "ID: Field 'ID' is Required"
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.