InfoPath Dev

Thank you for the additional information. At the Form Load rules, I have added 2 new rules. The first one queries the items from the Program Student Information1 data connection based on the field1 data. The issue I think is with the set value which should not be filtered. Please check this form instead.

I have added a debug section below to see if the queried data returns any value/s.

 In the newest posted form, the CougarnetID field never gets set to the field1 value.  I have been successful at using the Username() function to directly set the CougarnetID field directly, "field1" was a field I added for testing purposes, it doesn't exist in the list, just on the form.

In addition, the GradDegree field never gets set to the list value, but I suspect this is the result of the CougarnetID field not being set. 

 A 

The CougarnetID In the main data source will not get a value. At the Query Items rule on form load, The rule here is setting the CougarnetID for the Query Fields of the data connection (this filters the query based on the current user's ID). I'd like to ask if the debug section I added below contain any values?

The debug section does have some values, just not for the GradDegree field.   I see values for the First and Last Name fields, the PeopleSoftID, and the concatenated full name, in addition to some fields with default values set (Modified, Created, Program-Concentration, etc.)

A 

I've double checked the form and saw a rule under field1. Could you try to disable or delete that rule? It looks like it's the one causing the issue - setting the Admissions-GradDegree to a blank value.

I deleted that rule and also deleted one on the Admission-GradDegree field. Still, nothing in the GradDegree field on either the form or in the debug section.

A 

 Odd, I went back into the last form you sent me, deleted the rule under field 1, and now the form is populating, but field1 isn't and the form is populating with information other than mine.

A 

In addition, the debug section appears to be displaying the entire list.

A 

The logic for querying data and setting values is correct. However there is some issue with the query and/or the query filter and I am unable to determine the issue from my end. Here is a video regarding Secondary Data Connections and Filters, or we could look into it for you if you want to purchase a support pack.

Regards,

I'm not certain what did it, but I was able to get the form to work in Preview.  Thank you so much for your help!

 Andy