SOLVED

Is it possible to use vlookup in spo ?

%3CLINGO-SUB%20id%3D%22lingo-sub-1710690%22%20slang%3D%22en-US%22%3EIs%20it%20possible%20to%20use%20vlookup%20in%20spo%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1710690%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20morning%3CBR%20%2F%3EI%20have%202%20SPO%20lists%20in%20the%20same%20site.%3C%2FP%3E%3CP%3EThe%20first%20list%20is%20called%3CSTRONG%3E%20lamine%3C%2FSTRONG%3E%2C%20which%20contains%20several%20columns.%20I%20would%20like%20the%20%3CSTRONG%3EAME%20TC%3C%2FSTRONG%3E%20column%20to%20feed%20on%20the%20values%20contained%20in%20the%20%3CSTRONG%3EClass%3C%2FSTRONG%3E%20column.%20The%3CSTRONG%3E%20Class%20colum%20is%20my%20lookup%20Value.%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EIn%20this%20exemple%20i'm%20looking%20for%20the%20value%2002%20in%20the%20classe%20colum.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22lamine.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F221927i4FD21715CDBE9058%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22lamine.png%22%20alt%3D%22lamine.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20another%20list%20called%26nbsp%3B%3CSTRONG%3Elamine%20table%202%26nbsp%3B%3C%2FSTRONG%3Ewhich%20contains%20column.It'%20s%20my%20table%20array.%3C%2FP%3E%3CP%3EThe%20dataset%20are%20the%20colmuns%26nbsp%3B%3CSTRONG%3EClasse%20and%20AME%20TC.%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22lamine2.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F221933i71ED6597812661C3%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22lamine2.png%22%20alt%3D%22lamine2.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EAnd%20the%20value%20I%20want%20to%20display%20in%20the%20lamine%20table%20is%20AME%20TC%20lamine%20table%202%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20vlookup%20syntax%20works%20very%20well%20in%20excel.%3C%2FP%3E%3CP%3Ehow%20do%20I%20do%20this%20in%20spo%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1710690%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1711727%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20it%20possible%20to%20use%20vlookup%20in%20spo%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1711727%22%20slang%3D%22en-US%22%3EIf%20I'm%20not%20mistaken%2C%20you%20cannot%20do%20this%20with%20SPO%20Columns%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Good morning
I have 2 SPO lists in the same site.

The first list is called lamine, which contains several columns. I would like the AME TC column to feed on the values contained in the Class column. The Class colum is my lookup Value.

In this exemple i'm looking for the value 02 in the classe colum.

 

lamine.png

 

I have another list called lamine table 2 which contains column.It' s my table array.

The dataset are the colmuns Classe and AME TC.

 

lamine2.png

And the value I want to display in the lamine table is AME TC lamine table 2

 

The vlookup syntax works very well in excel.

how do I do this in spo ?

 

Cheers

 

2 Replies
Highlighted
Best Response confirmed by anthonyleduc (Occasional Contributor)
Solution
If I'm not mistaken, you cannot do this with SPO Columns
Highlighted
I was afraid of that answer.
I'll see with the Poweruser community if I can do that with Powerapps.

Thank you so much