Solved

Sharepoint + Infopath + search list

Posted on 2013-06-25
4
685 Views
Last Modified: 2013-06-26
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
Comment
Question by:dkilby
  • 2
  • 2
4 Comments
 
LVL 28

Expert Comment

by:clayfox
ID: 39275069
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
 

Author Comment

by:dkilby
ID: 39275234
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
 
LVL 28

Accepted Solution

by:
clayfox earned 500 total points
ID: 39275647
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
 

Author Closing Comment

by:dkilby
ID: 39277506
Thanks for the help
0

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

When installing SharePoint 2010 RTM I came across a strange error, I was getting timeouts during the installation. I searched the web and found the best solution to be found here (http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010genera…
In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question