web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Using List in Power apps
Power Apps
Answered

Using List in Power apps

(0) ShareShare
ReportReport
Posted on by

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

ProtoSup_0-1689235749475.png

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

Thanks 🙌

Categories:
I have the same question (0)
  • narayan225 Profile Picture
    2,547 Super User 2025 Season 2 on at

    @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!

  • ProtoSup Profile Picture
    on at

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

  • Verified answer
    narayan225 Profile Picture
    2,547 Super User 2025 Season 2 on at

    @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!

  • ProtoSup Profile Picture
    on at

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

     

    ProtoSup_0-1689246789583.png


    Will you be able to fix it?

    Best regards

  • Verified answer
    ProtoSup Profile Picture
    on at

    @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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 386 Most Valuable Professional

#2
Kalathiya Profile Picture

Kalathiya 361

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 339 Super User 2025 Season 2

Last 30 days Overall leaderboard