InfoPath Dev

I guess what I would do is on the submit rules run a query to get back all the rows that match on date, and then use the count function to determine if this should be allowed to submit. If you have trouble with the date format for the query put the query and data fields on the form with a button to run the query, for test purposes, and try a ...

Put the lookup fields on the form so you can see the values in them, if you haven't already - I often just drag the entire data source onto the form so I can see the actual values. It may be that the data is returned as ID;#Title or something and you need to use a substring formula to get the right value to set your query field in your second ...

Hi Hilary, Thanks for responding to this request. Unfortunately, I will not be able to attach the form here due to the data privacy policy of my company. Is there any other way to do it? I have applied rules to the PIN No. dropdown and can retrieve details which are in"Single Line of Text" but can't retrieve details for ...

Sure, because numbers don't have preceding 0s. :) See the attached sample for one way to do this - I only included a few months in my dropdown, but there is a mix of single & double digits. Save the file locally, right click and select design, then preview and pick a month.

I'm more used to seeing a 5566, but if the error in the logs is a 401, unauthorized, direct your admin to the KB I linked to - there are options other than disabling loopback outlined there.

The Log ID is 5567, does that help? I've attached a screenshot.

If the error message you are getting includes "5566", your SharePoint admin can take the first approach outlined in this KB as well to specify host names: https://support.microsoft.com/en-us/help/896861/you-receive-error-401-1-when-you-browse-a-web-site-that-uses-integrate

Our Admin says that it is not best practice to disable the loopback check .. could I send you the log information to look at? It's in an excel file. Maybe there is a different issue showing in the log. I've spent a lot of hours/days on this and at this point it would help to know if I am the one doing something wrong or if the server is ...

Yuck. You might try setting postback to always on the list control - right click the control and under browser set the radio to always, see if that makes a difference? Any XPath reference will talk about preceding-sibling - I like this one: http://zvon.org/xxl/XPathTutorial/Output/examples.html

They likely need to disable loopback check. You should get them the correlation ID and time of the error, so they can review the logs.