• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 752
  • Last Modified:

Sharepoint + Infopath + search list

I have a simple sharepoint list, and have created a form using infopath for the user to enter the information.

Is there anyway to have a button on the form, that the user can click and search a certain field to see if a value already exists in the list - so if a value already exists a message would show that it is a duplicate request.
0
dkilby
Asked:
dkilby
  • 2
  • 2
1 Solution
 
Clay FoxDirector of Business IntegrationCommented:
Yes.
create a data connection to the same SP list again
when they start a new entry, query the secondary connection, which will load all values
when they update the field you want to check add an action with condition field equals field in the list and is not blank.
then the action would be a message, make a hidden message field visible since it is web based, and reset the field to blank.
0
 
dkilbyAuthor Commented:
So i created a "search" button that pulls data back from the list using the action on button clicked.

The data pulled back do i put it into a hidden field to then validate against or some other way.

Thanks
0
 
Clay FoxDirector of Business IntegrationCommented:
When you query a secondary data source the information is the but "hidden" if you do not show it in the form view.

so ya you would do the check without showing the user or maybe hae a filtered list to show them the matching record so they could update.
0
 
dkilbyAuthor Commented:
Thanks for the help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now