Filtering SharePoint List Data using Infopath 2010

I could have just added the Account field to the Custom List data source (and I did that, from Tools > Data Connections) and used that instead of the Name field, but people usually don't know their managers' account names. I did a little digging and found an MSDN forum post that gave me a great way to let users pick friendly display names, which InfoPath would then use to populate a hidden form field with the corresponding account name

1. Add a Text Box field to the InfoPath form (Insert > Text Box).
2. Right-click the text box and choose Text Box Properties.
3. On the Data tab, click the Function (fx) button in the Default Value section.
4. Click the Insert Field or Group... button.
5. In the Data source drop-down list, select Your Custom List.
6. Expand the folders until you see the fields in the User Information List.
7. Click the :Account field (you did add it from Tools > Data Connections > Modify, right?), and then click Filter Data.
8. In the Filter Data box, click Add.
9. In the Specify Filter Conditions box, select Name in the first field, is equal to in the criteria field, and Select a field or group in the third field.
10. In the Select a Field or Group box, change the Data source to Main (this is your InfoPath form fields).
11. Click the field that contains the drop-down list of display names you created earlier, and then click OK.
12. Click OK in all the dialog boxes (shown below) to return to the Text Box Properties.

Hiding Form Controls

I wanted the field hidden, since users didn't need to see it, so back in my Text Box Properties:

1. In the Display tab, click Conditional Formatting.
2. In the Conditional Formatting box, click Add...
3. In the condition builder section, leave the field name selected in the first box, and then select is present in the criteria box.
4. Check the box Hide this control, and then click OK.
5. Click OK to return to the Text Box Properties, and then click OK to save

Click Preview one more time to make sure I can't see the field containing the account name anymore - success! Finally, I walked through the File > Publish wizard one last time, making sure to add my new hidden Text Box field to the list of fields to publish, and I was ready to go. Users could create their expense reports in a Forms Library;