Forum Discussion
Create item(s) from one SharePoint List to another that have Lookup field(s)
If it is a lookup field, the query should be something like
Lookupfieldname/Actualfieldname eq 'value'Have you verified the Advanced Option and make sure you have the fields in the list correctly mapped to the default content type and make sure you have not more than one content type.
Hope it helps, please like it or mark it as a solution if it resolves your clarification or issue
-Sudharsan K...
Sudharsan K My lists are set up to not allow management of Content Types.
I updated my Get Items filter query as you mentioned and there appears to be no difference. Both queries still return "Successful" runs, though my lookup column Parent Option is still not present in my Create Item and Update Item columns, and therefore does not include the Parent Option value for an item in my destination list.
One thing I did forget to mention my connection is through the On-Premises Data Gateway. Does this have anything to do with it? What determines what columns are available in Create and Update actions?