Answered

Problem With LookUp on SP List

(0) Share

Report

Posted on by Slowpoke

157

Hi everyone,

I have a SP List called 'Cat Man' with 3 columns: "Titre","Pilote","Mail".

I'm trying to create a Patch Fonction using a Lookup Fonction that get the value from a combobox selected item. But I have issues with it. The function that I use:

LookUp('Cat Man'; ComboBox4.Selected.'Nom du groupe mis a jour'='Cat Man'.Title; 'Cat Man'.Mail)

But it doesn't show anything.

And this function:

LookUp('Cat Man'.Mail; ComboBox4.Selected.'Nom du groupe mis a jour'='Cat Man'.Title)

I get an error saying that I can't compare a Text and Table.

Does anyone as an idea to make it work.

Thanks by advance.

Categories:

Building Power Apps

All responses (8)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@Slowpoke

Yes, you are asking the Lookup to compare a table to a text string - 'Cat Man'.Title is a table!

This will not be valid.

Please consider changing your Formula to the following:

LookUp('Cat Man'.Mail; Title = ComboBox4.Selected.'Nom du groupe mis a jour' )

This will return the first record that matches the criteria.

I hope this is helpful for you.
Slowpoke 157 on at

Like
a
(0)

Report
Copy link

Link copied!

Ok, I tried this, but then I get the error: you can't compare those types: Control and Text.

I tried other things but none of them seems, to work. I'm starting to think that what I'm trying to do is not possible.
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@Slowpoke

What is the exact formula you have now that has the error?
Slowpoke 157 on at

Like
a
(0)

Report
Copy link

Link copied!
The same one as you wrote above

So this one:

LookUp('Cat Man'.Mail; Title=ComboBox4.Selected.'Nom du groupe mis a jour')
Slowpoke 157 on at

Like
a
(0)

Report
Copy link

Link copied!
@RandyHayes

And also, when I create a Label with this formula:

Label3.Text = Text(Combobox4.Selected.'Nom du groupe mis a jour')

And I try to use this label in the Lookup, so with this formula:

LookUp('Cat Man'.Mail; Title=Label3)

I get the error: you can't compare control and control, but only with this symbol (and not the red cross):
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@Slowpoke

The last formula with the error is correct (that you have an error) Label3 is a control...not a value! You can't compare that.

What is the Items property of your Combobox4 control?

And what kind of column is 'Nom du groupe mis a jour' in your list?
Slowpoke 157 on at

Like
a
(0)

Report
Copy link

Link copied!
The items property of my combobox is:

PNL.'Nom du groupe mis a jour'

And 'Nom du groupe mis a jour' comes from another list called PNL, and it's a single string column with categories that look like this : "AA0000 - CATEGORIE NAME".
Verified answer

Slowpoke 157 on at

Like
a
(0)

Report
Copy link

Link copied!
Ok I managed to make it work:

LookUp('Cat Man'; Title=ComboBox4.Selected.'Nom du groupe mis a jour').Mail