I am trying to show a single item in a label but it shows me the error: "Change the rule to produce a {0} value"
I am filtering by ID that is unique and I also tried converting it to text with no luck:
Filter('myTable',ID=varSelectedID).Name
or
Text(Filter('myTable',ID=varSelectedID).Name)
Solved! Go to Solution.
Filter returns multiple records so that's the reason for the error. If you want to display the first item that matches the condition, you would call the LookUp function.
Lookup('myTable',ID=varSelectedID).Name
Filter returns multiple records so that's the reason for the error. If you want to display the first item that matches the condition, you would call the LookUp function.
Lookup('myTable',ID=varSelectedID).Name
Thank you, that works.