InfoPath Dev

So - I'm sorry that I'm having so much trouble understanding what you want here. The data connection for the list you are using in your dropdown has to have a field that would have the same values as can be selected from ResponsibleDepartment - does that make sense? Maybe that's title? In which case, the filter would look like: d:Title ...

So - in the fields in the list connection you are using for the Backup dropdown, what field would match the selected Sub Area from the form? I see you are already filtering the dropdown on "ProductGroup" = "Backup" so I'm guessing it is not ProductGroup....

Any chance I can see a copy of your form?

Oh, I forgot about the rich text bug. You may have to leave the edit ribbon and just deselect the stuff you don't want the user to be able to access under "Show the following commands" - you could deselect Submit, etc.

So you know, what you are talking about is not a query - it is an XPath filter. The data source has already been queried, and you are applying an XPath filter to the returned data. I'm still a bit confused, however. Will the data for the dropdown come from a different list if the subarea is Graphic Designer? Or does the data always come from ...

In InfoPath Designer, under the File Menu > Info Category > Form Options, under the Web Browser category, deselect the checkbox for displaying the ribbon.

Hopefully things won’t have to be configured in your forms too much differently for the migration. There is not a list of issues for moving from FormsViewer on prem to FormsViewer online - because, in general, if your form works with FormsViewer on-prem, it will with FormsViewer online. Your data connections will change in the forms – you could ...

Hi - this is surprisingly hard to do with InfoPath out of the box. However - you can find complex mathematical formulas for this online. Here is one blog post on this - I've not tried this specific one, but give it a shot. I would recommend trying it exactly as written in a test form prior to adding to your actual form: ...

I think so - not enough detail to be 100% sure tho. I would say you need a rule on field A and one one field B. On both fields, determine what to set the query fields in your list connection to and execute the query to get a correct list for your dropdown.

Yes, I'll do that this morning.