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?
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
)
It's in the original post: "The function LookUp has some invalid arguements"
Hi @ngreen
Filter using Combo box
With(
{
sData: Filter(
DataSource,
IsBlank(ComboBox1.SelectedItems.Value) || IsEmpty(ComboBox1.SelectedItems) || ChoiceColumnName.Value = ComboBox1.Selected.Value
)
},
sData
)