GetItems doesn't retrieve all lookup field in OData

[Knguyen94]

Hi, 

I set a view "Recensement"  of 7 columns which contains 3 lookup up fields based on 2 other lists. 

-  ["Unite"] from  List 'A'

-  ["Situation"], ["Situation:title"] from List 'B'

I set my GetItems to limit the field to "Recensement" view

http://prntscr.com/rjnap7 

However, I'm able to retrieve ["Unite"] but not the 2 other columns in my Odata

http://prntscr.com/rjndck 

I tried to create another list with same view and it works. 

http://prntscr.com/rjnkg5

Do you have an idea why ? 

[abm]

Hi @Knguyen94 

Are there any custom security for List A and B?

Thanks

[Knguyen94 · Accepted solution]

Hi,

I found the solution

Fields which are not populated, are not retrieved in the "Get Items" actions. 

So I have to check first with this condition if(not(empty(item()?['Situation']))) to see if the field is in the Odata.

Thanks.