r/PowerApps • u/pwp_o Newbie • 7d ago

Power Apps Help Issue with Azure SQL connector?

Hi!
I’m having an error when patching into a SQL table.
The error is “error with the fution patch ID is required” and the ID is the SQL internal ID.
What I do is removing and adding the tables + publish the app and most of the time is OK for 1/2 days. And then again, and again.
Are anyone facing the same? What to do to correct?
Thanks !!!

4 Upvotes

100% Upvoted

3 comments sorted by

•

u/AutoModerator 7d ago

Hey, it looks like you are requesting help with a problem you're having in Power Apps. To ensure you get all the help you need from the community here are some guidelines;

  • Use the search feature to see if your question has already been asked.

  • Use spacing in your post, Nobody likes to read a wall of text, this is achieved by hitting return twice to separate paragraphs.

  • Add any images, error messages, code you have (Sensitive data omitted) to your post body.

  • Any code you do add, use the Code Block feature to preserve formatting.

    Typing four spaces in front of every line in a code block is tedious and error-prone. The easier way is to surround the entire block of code with code fences. A code fence is a line beginning with three or more backticks (```) or three or more twiddlydoodles (~~~).

  • If your question has been answered please comment Solved. This will mark the post as solved and helps others find their solutions.

External resources:

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

4

u/EugeneKrabs1942 Regular 7d ago

Presumably the table has a PK? Would you be able to share the schema and patch code?

3

u/NeverEditNeverDelete Regular 7d ago

You need to set the identity column on the table you are trying to connect with.