[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 715
  • 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
 
clayfoxCommented:
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
 
clayfoxCommented:
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

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering 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