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.

All responses (2)

Answers (0)

André Arnaud de Cal... 294,120 Super User 2025 Season 1 on at

Like (0)

Report

RE: Can't get ItemInternalId from OData using Power Automate

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?
Martin Dráb 232,871 Most Valuable Professional on at

Like (0)

Report

RE: Can't get ItemInternalId from OData using Power Automate

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.