Creating SQL table for use in Flow and PowerApps

Niels G. Johansen
hexatown//blog
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.

SQL Script used

--

--