Hi, I have been looking online for an answer to this with no avail. I have a secondary data connection which I want to query based on values stored in fields within my main data. I have done this using filters and the 'hide' function for a repeating table but wanted to figure out how to correctly do this with the 'filter' fields in the secondary data connection (so that I can see the amount of records returned etc.). When you set a 'filter' field value(s), is it only looking for exact matches i.e. 'equals' (my assumption is yes) and if so, how can you then look for 'greater than', 'less than', 'not equals' etc.? Do I have to use a REST connection with an in-built filter rather than SharePoint List connection? If yes then I know how to do that but was just checking before I go changing my form.
Thanks!