cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

GetItems doesn't retrieve all lookup field in OData

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 ? 

 
 
 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Frequent Visitor

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.

View solution in original post

2 REPLIES 2
Super User III
Super User III

Hi @Knguyen94 

 

Are there any custom security for List A and B?

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials
Frequent Visitor

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.

View solution in original post

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (9,858)