Can't get ItemInternalId from OData using Power Automate

(0) Share

Report

Posted on by agneum

150

I'm trying to use a flow that reads data (OData) from Dyanmics 365 FO . I can read all the fields that are returned from the OData output and insert them into my SQL table, except the one called ItemInternalId.
When I preview the OData contents, every field is there .

items('Apply to each')['CountryRegionCode'] Works fine, items('Apply to each')['ItemInternalId'] doesn't work. It's just spits out nulls.

I know this might be better suited for the Flows forum, but maybe someone has had a similar experience and can explain what is going on.

I have the same question (0)

All responses (2)

Answers (0)

Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report

Which data entity are you talking about?

The name suggests that the field is internal for internal use and maybe its access mode is set to Internal, therefore it's not available from outside D365FO.
André Arnaud de Cal... 301,109 Super User 2025 Season 2 on at

Like (0)

Report

Hi agneum,

Can you provide some more details? What entity are you using? Can you share a screenshot where all values are visible for all fields? What is the exact data type of this field?