InfoPath Dev

 I have a drop down field in my main form that grabs the title field data from a secondary data connection. I'm now getting the "Exceeding data limit error". I need to now query the secondary data connection to bring back the title field data based on specific statuses(In Progress and On Hold) in the status field from the secondary data connection. Is this possible? I know how to map and query using fields from secondary and main data connections, just not using specific string instances.

The issue you'll have is that it sounds like you need everything where Status = In Progress OR Status = On Hold. The built in query fields in a list data connection can't do that - you could filter for everything where Status = In Progress, for example, or for everything where it is On Hold, but not both. You can just set the query field to In Progress and then execute the query. I usually put the query and data fields on the form with a button to execute the query and then test that way.... Do you use SharePoint Online or on prem? I'm thinking you could add another column for "AvailableForDropdown" or something and use a Flow or a workflow to set that if the status is in progress or hold - then you'd have a single column to filter on. It can't be calculated, unfortunately - because those aren't available in query fields...