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

[papolley]

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:

And I get the following error:

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

Thank you!

[Expiscornovus · Accepted solution]

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.

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.

Below is another example of that.

[papolley]

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:

where engagement number is a variable from a previous block.