cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate II
Advocate II

Vlookup PowerApps

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 lookup 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.

 

vlookup1.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."

 

vlookup2.png

Is it possible that the result will appear here ?

In excel, the formula works well. 

vlookup power.png

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Thank you very much, thanks to your help I managed to find the right syntax. It works now

 

LookUp('Lamine table 2';Classe=ThisItem.Classe).'AME TC'

 

Capture d’écran 2020-09-27 211645.png

View solution in original post

2 REPLIES 2
Highlighted
Resolver III
Resolver III

hi there try

lookup(lamine table 2,Classe = thisitem.Classe,"AME TC")

Highlighted

Thank you very much, thanks to your help I managed to find the right syntax. It works now

 

LookUp('Lamine table 2';Classe=ThisItem.Classe).'AME TC'

 

Capture d’écran 2020-09-27 211645.png

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (12,136)