web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Insert row (V2) does n...
Power Automate
Answered

Insert row (V2) does not show fields

(0) ShareShare
ReportReport
Posted on by 12
Hi,
 
Does anyone know why my Insert row (V2) action doesn't show a row or fields? The SQL it's connecting to is an on-prem SQL database, and I've created a gateway to connect to it.
 
Categories:
I have the same question (0)
  • Nived_Nambiar Profile Picture
    18,129 Super User 2025 Season 2 on at
    If tables, database, server name all shows up- then field details should show up as well.
     
    Could you delete the action and add it again and see then whether fields shows up ?
     
     

    Thanks & Regards,
    Nived N

    Stay connected:
    LinkedIn | YouTube | Blogs

    Was this answer helpful?
    If yes, please mark it as the solution by selecting the checkbox in the discussion thread.
    Your feedback motivates me to keep contributing. Thank you!

  • Verified answer
    jennym1976 Profile Picture
    12 on at
    Thank you for your response. I removed it and added it a few times to see if that would fix it, but unfortunately, I'm getting the same result.
     
    UPDATE: Embarrassed to say that the only column in the table was an ID column. That's why no fields pulled through. I thought I had already created the columns in design view, but I hadn't.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 501 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 323 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard