Creating SQL table for use in Flow and PowerApps
Published in
2 min readSep 8, 2017
How do I know the result of clicking a button in PowerApps which is connected to a flow — part of a series of articles
Add a new table to an existing SQL database
Assume you already have access to the database -create a without automatical setting the value of the primary key
See scripts last in this page
Q&A
Why is the id not automatically set
Check this for background — The logic in Flow is lacking the understanding of how SQL server handles identity columns. Flow only support single column identities, and you cannot update records if the id column is set to auto.