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

Announcements

News and Announcements icon
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 Moderator 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 Moderator 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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 542 Most Valuable Professional

#2
Haque Profile Picture

Haque 206

#3
Kalathiya Profile Picture

Kalathiya 201 Super User 2026 Season 1

Last 30 days Overall leaderboard