Retreive a value of a column after comparing two sharepoint lists

[audemj23]

Hi to all.

I have the following scenario

-One sharepoint list named "rol" with a column "On call" of type:Person

-One sharepoint list named "directory" with a column "name" of type:Person and a column "Phone" of type:number

-One powerapp with a gallery showing the results of "roll" list

-Both lists are added as data connectors.

I want to compare "on call" and "name", if they are equals then show the value of "Phone" for that particular match in a filed inside the same gallery.

Is this possible?

Thanks in advance

[AJ_Z · Accepted solution]

So I think I understand what you are looking to do. Let's say you have a gallery for the datasource rol and you want to add a label inside it with the phone number from directory. You would put on the text property of the label in the gallery:

LookUp(directory,name.Email = ThisItem.'On call'.Email).Phone


this would show the phone number of the person matching the same in directory as emails should be unique.

let me know if this is helpful

[audemj23]

Worked perfectly.
I learned in the hard way that powerapps is case sensitive!

thanks a lot

[AJ_Z]

Glad I was able to help 🙂