Answered

Insert Row into SQL Database

(0) Share

Report

Posted on by IPC_ahaas

1,387 Moderator

I am beginning the process of replacing our SharePoint Lists with SQL Databases. I have a Form where employees submit vacation requests that I want to start logging in SQL. I have a connection setup to our on-premises SQL Server already. Here is the structure of the database:

I see that Execute a SQL query (V2) is not supported by on-premises, so I was using Insert row (V2) which seems to be supported. The problem, is the Insert row (V2) is not showing any of the columns that are within the database.

What am I missing?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

lbendlin 8,479 Super User 2025 Season 2 on at

Like (0)

Report

If you have made structural changes to the table after you created the connection then you need to refresh the connection.

Was this reply helpful? Yes No
IPC_ahaas 1,387 Moderator on at

Like (0)

Report

How do you refresh the connection? I'm not seeing a way to do that.

Was this reply helpful? Yes No
IPC_ahaas 1,387 Moderator on at

Like (1)

Report

I did it by re-entering the username/password from the account I used to created the connection:

Was this reply helpful? Yes No