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?
