First of all, thanks for very useful post.
It works very good, but I have just a little lack.
The structure of my secundary dataconnection is like that:
My formula is:
eval(eval(AdmDiagnosis[ClinicalPriorityDesc != "Secundario"]; 'concat(ns1:Code, "~", ns1:Description, "¬")'); "..")
xdMath:Eval(xdMath:Eval(xdXDocument:GetDOM("GetAdmittingDiagnosis")/dfs:myFields/dfs:dataFields/ns1:GetAdmittingDiagnosisResponse/ns1:GetAdmittingDiagnosisResult/ns1:AdmDiagnosis[ns1:ClinicalPriorityDesc != "Secundario"], 'concat(ns1:Code, "~", ns1:Description, "¬")'), "..")
This formual works perfect, but if I try the equal filter
[ClinicalPriorityDesc = "Secundario"]
This error raised:
Reference to undeclared namespace prefix: 'ns1'.
Error occurred during a call to property or method 'Eval'."
I workaround this issue using the not equal comparision instead the equal, but I'm curious if there is a way to fix that...
I am receiving the same issue with the formula: "../my:RepeatingTable/my:NomineesHidden/my:Person" does not point to a valid location path of a field or group.
I first tried the formula in the main body of the post. When that didn't work, I copied the formula that was given to someone else and adjusted the group names to fit my .xsn. Here is the XPath formula:
substring(xdMath:Eval(xdMath:Eval(../my:RepeatingTable/my:NomineesHidden/my:Person, 'concat(my:AccountID, ";")'), ".."), 1, string-length(xdMath:Eval(xdMath:Eval(../my:RepeatingTable/my:NomineesHidden/my:Person, 'concat(my:AccountID, ";")'), "..")) - 1)
My data structure is this:
NomineeTopGroup (non-repeating Group)
RepeatingTable (repeating table)
NomineeHidden (non-repeating Group)
pc:Person (repeating person group)
display name (string)
I have tried everything I can think of to fix the formula so that it recognizes the AccountID field, but I have failed.
I'd appreciate any help you could provide.
does not work with people picker sp 2010
Hi, thanks for this post, I managed to solve one of my problems :).
I was trying to get te same result from a multiple-selection listbox, but can't get it to work.
This is the datastructure :
I would like to see the checked item from field1 in field2, ';' seperated.
all help appreciatied :)
I have been looking for answer to send email to multiple people using InfoPath function ""Person/Group Picker" and data connection.
Finally, using this formula and adding some tricks I was able to do it.
My Data Source Looks like this:
Notification-send-to-group (Person/Group Picker)
Set default value for "Notification-send-to"
eval(eval(Person, 'concat(pc:AccountId, ";")'), "..")
Setup data connection for email and enter following formula to remove domain name in “To” using “fx”
translate(Notification-send-to, "DOMAIN NAME\", "")
first of all hi!.i have a forma and a people list.
pc:Person (repeating group)
i want so send emails to several DisplayName and cannot make it work :(
I am having a form with different sections and the momment the user hits the submit button I need each section in this form to be sent to different e-mails, I mean If I am having 3 sections in the form I need each of these 3 sections to be sent to 3 different e-mails. Any ideas how can I achieve this goal ?
Does anybody besides me thinks that InfoPath is not the great tool they promote?
Exactly what I needed. Thanks Bunch!!!
I really admire you for your good answer
tanx a lot
It worked for me. I used my secondary data source instead of "person" and I used "." (current field value) instead of "my:email". Thanks