cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
papolley
Microsoft
Microsoft

Help with 'Missing expand option on navigation property' error within powerapps flow

Hello!

 

I am currently trying to figure out how to get parameters from a connected object within powerapps flow for an update I'm working on. I have the following block of code currently erroring:

papolley_2-1634158069980.png

 

And I get the following error:

papolley_0-1634157952242.png

papolley_1-1634157999754.png

 

I'm extremely confused by the error message above. Does anyone know how I might proceed from here?

 

Thank you!

1 ACCEPTED SOLUTION

Accepted Solutions
Expiscornovus
Super User
Super User

Hi @papolley,

 

Are you using a lookup field for the connected object? If so, you could use the approach. 

 

In this example I am also selecting the engagementnumber in the expand query.

 

Lookupfield.png

 

Alternatively, you could also create a Fetch XML query:

https://docs.microsoft.com/en-us/powerapps/developer/data-platform/use-fetchxml-construct-query

 

You can create and download that xml via the advanced find editor.

advancedfindquery_fetchxml.png

 

 

 

Below is another example of that.

advancedfind_queryexample.png



Happy to help out! 🙂

Interested in more #PowerAutomate #SharePointOnline or #PowerVirtualAgents content?
Visit my blog, Subscribe to my YouTube channel or Follow me on Twitter


View solution in original post

2 REPLIES 2
Expiscornovus
Super User
Super User

Hi @papolley,

 

Are you using a lookup field for the connected object? If so, you could use the approach. 

 

In this example I am also selecting the engagementnumber in the expand query.

 

Lookupfield.png

 

Alternatively, you could also create a Fetch XML query:

https://docs.microsoft.com/en-us/powerapps/developer/data-platform/use-fetchxml-construct-query

 

You can create and download that xml via the advanced find editor.

advancedfindquery_fetchxml.png

 

 

 

Below is another example of that.

advancedfind_queryexample.png



Happy to help out! 🙂

Interested in more #PowerAutomate #SharePointOnline or #PowerVirtualAgents content?
Visit my blog, Subscribe to my YouTube channel or Follow me on Twitter


papolley
Microsoft
Microsoft

Thank you so much for the help! That was it! I was indeed trying to use a lookup field within that connected object.

 

I added in the needed fields to the expand query function as per your suggestion and it worked! Rows are being returned now 😄

 

For posterity in case anyone else stumbles across this, here's the screenshots of the working code block:

papolley_1-1634236750598.png

where engagement number is a variable from a previous block.

papolley_0-1634236713189.png

 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,389)