Link to home
Start Free TrialLog in
Avatar of dkilby
dkilbyFlag for Canada

asked on

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.
Avatar of Clay Fox
Clay Fox
Flag of United States of America image

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.
Avatar of dkilby

ASKER

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
ASKER CERTIFIED SOLUTION
Avatar of Clay Fox
Clay Fox
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of dkilby

ASKER

Thanks for the help