I have tried this example. https://social.technet.microsoft.com/wiki/contents/articles/32961.sharepoint-filter-dropdown-values-on-list-infopath-form-based-on-current-user.aspx

But I came across with a problem. In Agency drop-down, it displays whatever mentioned fields when I create data connection. For example in my case I have mentioned Id and Agency. So in drop-down it displays Id and Agency together. Unfortunately Id cannot be un-ticked when we create data connection. Any idea how to solve this problem?

  • 1
    do you need to display two fields (both ID and Agency fields) in the drop down?
    – A.Saéed
    Mar 14 '18 at 14:51
  • No. Only Agency I need to display. But right now both are displayed. Mar 15 '18 at 3:19

Sivakumar , in the display name , select the field you want to display (Agency) in the drop down. try and let me know if you've issue.

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.