Hi All,
I would really appreciate help with this-- I have a flow that is supposed to make sure work order products are taken from the correct warehouse, in the case that the source warehouse should change at any point. This is done by tying the work order product's warehouse field to the warehouse field on the work order's assigned resource. So, if any product's source warehouse does not match the warehouse of the resource using the product, it should bring down the resource's warehouse.
However, I cannot get the flow to compare these two values because the flow refuses to locate any field on a related record that would give me access to that data. I want to use the Booking (lookup) field to retrieve the booking's Resource field value, then compare the warehouse value of the resource to the one on the current work order product. However, the flow cannot find the "resource" property, nor can it find "new_resource" if I try to access the same data via the Work Order Product's related Work Order as opposed to it's related Booking.
However, my understanding of Power Automate makes me believe that either of these methods should work, and I absolutely cannot figure out why it would say a property does not exist when I know it does and is spelled exactly correctly. I have attached screenshots of my $filter and $expand queries to show how I want to access this data. I have experienced this issue in other flows in the past so I do not think it would be related to the configuration of this flow specifically.
Does anyone know why a property might not be found on an entity that it 100% exists on and is being referenced correctly? Thank you all for any insight on this! This is definitely causing us a lot of issues at the moment.
