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

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / SQL Inserts nulls from...
Power Automate
Unanswered

SQL Inserts nulls from OData source

(0) ShareShare
ReportReport
Posted on by 204

This is a good example and the reason I don't use flows for anything. Please someone tell me what I'm doing wrong.


The goal is to pull data (using Odata) into a SQL database. Everything is working (I get all the fields) except the first column (ItemInternalId) is inserted as a null in the database. When I preview the output data from the flow it is clearly showing all the fields:

odata.png

So I tried below, doesn't work.

iteminternal.png

And this one doesn't work either:

d.png


So, why is this such a hassle? I mean, I used Microsofts own template for it....


Categories:
I have the same question (0)

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 237 Super User 2026 Season 1

#2
David_MA Profile Picture

David_MA 176 Super User 2026 Season 1

#3
Power Platform 1919 Profile Picture

Power Platform 1919 96 Super User 2026 Season 1

Last 30 days Overall leaderboard