Create item(s) from one SharePoint List to another that have Lookup field(s)

%3CLINGO-SUB%20id%3D%22lingo-sub-2141365%22%20slang%3D%22en-US%22%3ECreate%20item(s)%20from%20one%20SharePoint%20List%20to%20another%20that%20have%20Lookup%20field(s)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2141365%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20two%20SharePoint%20lists%20in%20two%20different%20SharePoint%20sites%20that%20are%20set-up%20exactly%20the%20same.%20One%20of%20the%20site's%20list%20is%20the%20main%20list%20that%20gets%20updated%2C%20and%20I%20am%20trying%20to%20update%20the%20secondary%20list%20with%20the%20add%2Fupdated%20list%20items.%20I%20was%20able%20to%20get%20my%20flow%20to%20work%20however%2C%20the%20data%20in%20the%20lookup%20column%20is%20not%20populating.%20In%20my%20Create%20Item%2C%20and%20Update%20Item%20action's%20my%20lookup%20column%20is%20not%20present%20to%20map%20fields%20from%20the%20trigger.%3C%2FP%3E%3CP%3EIs%20there%20something%20with%20lookup%20columns%20that%20doesn't%20allow%20you%20to%20create%20that%20data%20from%20another%20list%3F%20Or%20am%20I%20just%20missing%20something%20here%3F%20Here%20is%20my%20entire%20flow.%20Thanks!%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22FlowUpdateListScreenshot.jpg%22%20style%3D%22width%3A%20788px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F255420i4FCA94EAD8779084%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22FlowUpdateListScreenshot.jpg%22%20alt%3D%22FlowUpdateListScreenshot.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2141365%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Esharepoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2142930%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20item(s)%20from%20one%20SharePoint%20List%20to%20another%20that%20have%20Lookup%20field(s)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2142930%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F968915%22%20target%3D%22_blank%22%3E%40Chrissieg%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20it%20is%20a%20lookup%20field%2C%20the%20query%20should%20be%20something%20like%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3ELookupfieldname%2FActualfieldname%20eq%20'value'%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3EHave%20you%20verified%20the%26nbsp%3B%3CSTRONG%3EAdvanced%20Option%3C%2FSTRONG%3E%20and%20make%20sure%20you%20have%20the%20fields%20in%20the%20list%20correctly%20mapped%20to%20the%20default%20content%20type%20and%20make%20sure%20you%20have%20not%20more%20than%20one%20content%20type.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3BHope%20it%20helps%2C%20please%20like%20it%20or%20mark%20it%20as%20a%20solution%20if%20it%20resolves%20your%20clarification%20or%20issue%3CBR%20%2F%3E-Sudharsan%20K...%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have two SharePoint lists in two different SharePoint sites that are set-up exactly the same. One of the site's list is the main list that gets updated, and I am trying to update the secondary list with the add/updated list items. I was able to get my flow to work however, the data in the lookup column is not populating. In my Create Item, and Update Item action's my lookup column is not present to map fields from the trigger.

Is there something with lookup columns that doesn't allow you to create that data from another list? Or am I just missing something here? Here is my entire flow. Thanks!

FlowUpdateListScreenshot.jpg

 

 

2 Replies

@Chrissieg 

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?

LimitColumnsbyViewMessage.jpg