Share
Report
2I am trying to display multiple lines of an Excel table (hosted on OneDrive and connected as data source) using the filter function, in a label.
My Excel table, named AnimalData, is as follows:
| Animal | Age | Breed | Name |
| dog | 1 | lab | Annie |
| dog | 2 | lab | Beth |
| cat | 4 | bengal | Carla |
| cat | 4 | persian | Duke |
| dog | 1 | lab | Ellie |
If I wish to get all animals aged 1, I was trying the following code inside of the label box:
Filter(AnimalData,Age="1")
However, I get the error "the property on this control expects Text values. The rule produces Table values which are incompatible.... How to Fix: Change the rule to produce a {0} value".
Categories:
All responses (
Answers (
