Webpart SPFX Issue: Items$expand=Categorie vs column Categorie

%3CLINGO-SUB%20id%3D%22lingo-sub-2135969%22%20slang%3D%22en-US%22%3EWebpart%20SPFX%20Issue%3A%20Items%24expand%3DCategorie%20vs%20column%20Categorie%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2135969%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3CBR%20%2F%3EI%20have%20a%20trouble%20in%20lookup%20field%2C%20my%20Code%20list%20has%20a%20field%20named%20Categorie%20and%20this%20code%3A%3CBR%20%2F%3EItems%24expand%3DCategorie%26amp%3B%24select%3DTitle%2CColumn_x002d_1%2CColumn_x002d_2%2CColumn_x002d_3%2CColumn_x002d_4%2CColumn_x002d_5%2CDate%2CPolice_1%2CPolice_2%2CCategorie%2FTitle%22%3C%2FP%3E%3CP%3Eit%20seems%20like%20he%20mixed%20between%20Categorie%20for%20lookup%20field%20and%20my%20own%20field%20Categorie.%20How%20can%20I%20separate%20or%20solve%20this.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2142942%22%20slang%3D%22en-US%22%3ERe%3A%20Webpart%20SPFX%20Issue%3A%20Items%24expand%3DCategorie%20vs%20column%20Categorie%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2142942%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F966952%22%20target%3D%22_blank%22%3E%40Musto93%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhatever%20you%20had%20mentioned%20is%20not%20clear.%20Based%20on%20my%20understanding%2C%20you%20cannot%20have%202%20fields%20with%20the%20same%20name.%20The%20name%20should%20be%20different%2C%20try%20to%20check%20the%20internal%20name%20from%20the%20list%20settings%20and%20use%20the%20internal%20name%20in%20the%20query.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%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
Frequent Visitor

Hi,
I have a trouble in lookup field, my Code list has a field named Categorie and this code:
Items$expand=Categorie&$select=Title,Column_x002d_1,Column_x002d_2,Column_x002d_3,Column_x002d_4,Column_x002d_5,Date,Police_1,Police_2,Categorie/Title"

it seems like he mixed between Categorie for lookup field and my own field Categorie. How can I separate or solve this. 

1 Reply

@Musto93 

Whatever you had mentioned is not clear. Based on my understanding, you cannot have 2 fields with the same name. The name should be different, try to check the internal name from the list settings and use the internal name in the query.

 

Hope it helps, please like it or mark it as a solution if it resolves your clarification or issue
-Sudharsan K...