InfoPath Dev

See attached zip file for images! Hello! I’ve been working helping build an Infopath list, and it’s grown into something that’s beyond my skills - and I’m reaching out to see if I can get some support. My Situation: I have 3 lists: List 1 – Location (1 column, title) List 2 – Names (2 columns, name + a lookup to the location (can select multiple locations). List 3 – Infopath List What I want: When they pick a location in the infopath form, I want the names to automatically appear (e.g. when they pick location 2, individuals with that location are shown). What I’ve done so far: 1) I’ve added the data connections. 2) I added a Rule on the locations list to query the data connections List My coding skills are VERY basic and I don’t know xPath, so I tried building something with lots of hidden columns and workflows, but I couldn’t get name with multiple location lookups (e.g. Judy) to appear). I know Lookups are stored as ID’s, but not sure how to best make this work. If you have any guidance, that would be MUCH appreciated. Best, Spencer

I think that you will need to query the Names list when the form loads, instead of when the selected locations change if you allow them to select multiple locations. I think you need to just use conditional formatting on the section that displays name to hide it if the location is not equal to any of the selected locations.... I'm going to guess that the Location in the Names list is actually the ID for the location, since it's a lookup. Any chance I can see a copy of your form? It would be easier for me to give you a hand.

See attached file! Thank you so very much.

OMG, I just realized my error...it's sitting right in front of me. On the filter, it says "Value." When I changed it to "All occurrences of Value" it worked!!!! Thank you! really appreciate the support. Infopath is pretty cool...

Great job figuring it out :)