Secondary Data Source(Sharepoint list) and People Picker Control - InfoPath Dev
in

InfoPath Dev

Secondary Data Source(Sharepoint list) and People Picker Control

Last post 07-06-2013 04:02 AM by Behrouz. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 07-05-2013 07:27 AM

    • Behrouz
    • Not Ranked
      Male
    • Joined on 07-05-2013
    • Isfahan - Iran
    • Posts 2

    Secondary Data Source(Sharepoint list) and People Picker Control

    Hi all

    I Searched Forum infopathdev and did not find any answer.I have one People Picker Control and 2 Text Box. i set Value's of First Box to

    eval(eval(Person, 'concat(" - ", pc:DisplayName)'), "..")

    and it works fine and also i created Sharepoint List with only 2 Column "Title, Phone Number" and Title is equal to Display name.Second Text box should get Value from Second Data Source and show all Value equal to display name.For Example in Sharepoint List :

    Title Phone Number
    Patrick 091325
    Behrouz 064685
    Shirin 024685
    David 055685
    Babak 065788

    If I Type All Username in People Picker control , Values in first text box would be :

    Patrick - Behrouz - Shirin - David - Babak

    and when it's done , Second Text box should get data From Sharepoint List then show all Values in Second Text box , Like this :

    091325 - 064685 - 024685 - 055685 - 065788

    i tired to Set

    eval(eval(PhoneNumber[DisplayName = Title], 'concat(" - ", xdXDocument:GetDOM("Phone Number")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Phone Number)'), "..")

    So any Idea ? Thanks.

    Sharepoint Administrator
    Work in Pars Niroo Bondad
  • 07-06-2013 04:02 AM In reply to

    • Behrouz
    • Not Ranked
      Male
    • Joined on 07-05-2013
    • Isfahan - Iran
    • Posts 2

    Re: Secondary Data Source(Sharepoint list) and People Picker Control

    I found solution , here :

    eval(eval(SharePointListItem_RW[DisplayName = Title], 'concat(" - ", d:Phone Number)'), "..")

    and this xpath did not Work :

    eval(eval(Phone Number[DisplayName = Title], 'concat(" - ", d:Phone Number)'), "..")

     Double Eval is Trick to get all Value from control.

    Sharepoint Administrator
    Work in Pars Niroo Bondad
Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.