Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Look Up and Filter to Return Choice Column Data

(0) ShareShare
ReportReport
Posted on by 359

Hello,

 

I am trying to use a LookUp to return a record's choice column data. When using the LookUp, I have the function working; however, I want to insert a Filter function to use a delegated function in case the list ever gets much larger that way the function continues to work. The function should LookUp a record from the list of Filtered records (there should only be one record) and return the Item Status. It will check a text column and return a choice column data. Here's the LookUp:

 

LookUp('Device Inventory List','Serial Number'=DataCardValue17.Text,'Item status'.Value)

 

Now I have done LookUp and Filter with success before, but if I copy the function format that I have used before, it's giving an error "The function LookUp has some invalid arguements". Here is the function:

 

LookUp(Filter('Device Inventory List','Serial Number'=DataCardValue17.Text),'Item status'.Value)

 

What am I missing that this function isn't working here but my other times using something similar do work?

  • Re: Look Up and Filter to Return Choice Column Data

    Hi @ngreen 

    Sample

    StalinPonnusamy_0-1628100708037.png

     

  • Verified answer
    Re: Look Up and Filter to Return Choice Column Data

    Hi @ngreen 

     

    If you know only one then we can use First without Delegation

     

    With(
     {
     theList: Filter(
     'Issue tracker',
     Title="Test"
     )
     },
     First(theList).Priority.Value
    )

     

     

  • Thor_PPC Profile Picture
    Thor_PPC 359 on at
    Re: Look Up and Filter to Return Choice Column Data

    It's in the original post: "The function LookUp has some invalid arguements"

  • Re: Look Up and Filter to Return Choice Column Data

    Hi @ngreen 

    Filter using Combo box

     

    With(
     {
     sData: Filter(
     DataSource,
     IsBlank(ComboBox1.SelectedItems.Value) || IsEmpty(ComboBox1.SelectedItems) || ChoiceColumnName.Value = ComboBox1.Selected.Value
     )
     }, 
     sData
    )

     

     

  • PriyankaGeethik Profile Picture
    PriyankaGeethik 3,297 on at
    Re: Look Up and Filter to Return Choice Column Data

    @ngreen 

     

    What is the error message you're getting ?

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard