Using List in Power apps

(0) Share

Report

Posted on by ProtoSup

Hi, Who I can Request my list to have the Status when i juste have "Titre ?

My Formula : LookUp(Credentials, Titre = UserLabel.Text).Status

Thanks 🙌

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (2)

narayan225 2,547 Moderator on at

Like (1)

Report
Copy link

Link copied!

@ProtoSup

Can you explain what you are trying to do with the formula? It is confusing.

The formula that you have mentioned returns the status column of the first record that is returned by the lookup.

If you are trying to search status based on the supplied title, try textinput control.

Cheers!

Was this reply helpful? Yes No
ProtoSup on at

Like (0)

Report
Copy link

Link copied!

@narayan225 Thank you for your help

I have a login page, after login I can retrieve the "UserLabel" text field, which is also the "Title" column in the list.

In my case, I'd like to retrieve "Admin" when "Title" = Paul.

understand?

Thanks ...

Was this reply helpful? Yes No
Verified answer

narayan225 2,547 Moderator on at

Like (1)

Report
Copy link

Link copied!
@ProtoSup
Try this:
LookUp(Credentials, Titre = UserLabel.Text).Status.value
Because status is a choice column, you will need to suffix .value to get the actual value of the record.
Cheers!

Was this reply helpful? Yes No
ProtoSup on at

Like (0)

Report
Copy link

Link copied!

@narayan225 !
Thank you very much for your precious help, I realized my mistake, but now I have this error...

Will you be able to fix it?

Best regards

Was this reply helpful? Yes No
Verified answer

ProtoSup on at

Like (1)

Report
Copy link

Link copied!

@narayan225 Ok sir !

I just modify the point for a semicolon and it works great ! Thank you again again !

LookUp(Credentials ; Titre = UserLabel.Text).Status.Value

Was this reply helpful? Yes No