-
The rule type is set a fields value. You set the field, then you run the query. See attached, on the SelectedAccount field I've added rules for you. I also put the secondary data source on the form for you to help you see the values.
-
You have a rule under FormLoad that runs the query without setting the query field. If the query field isn't set, the GetUserProfileByName connection returns info for the current user. You have a default value for JobTitle that sets the field to AccountID for some reason. As I've suggested in the past, it would be better to use rules for ...
-
This is because you are opening it in IP, not in design mode. Save the file locally. Right click the saved file and select Design to open in design mode. :)
-
-
https://sharepointisland.wordpress.com/tag/getuserprofilebyname/ is just one sample. You don't do this in the data connection wizard - but in rules on the form.
-
You have to set the query field in your GetUserProfileByName data connection and execute the query. Are you doing that? I encourage you to put the query & data fields for that data connection on your form, temporarily, and add a button that queries it so you can try setting the query field manually and seeing the results.
-
XPath is case sensitive - that's why the expression stopped working. field3 is not the same as Field3. Why don't you get these tables moved where you want them in the schema, and rename stuff so it isn't group3, field3 & has meaningful names, and then I'll help you again w/ the validation. :)
-
Hey, Scott - I should be able to take a look sometime today. :)
-
Looks like you just entered the formula directly instead of clicking the fx button to enter the formula.
-
So - you open the library you submitted the filled out form to in a web browser, try to open the filled out form, and get that error?