I have an InfoPath form connected to a SQL database.  I have two fields in the Query window for the user to choose from in retrieving records.  Previously I had three fields, but it was decided that the user did not ever query on the third field.  When I try and query with the new form on just the two fields, I get an error stating that there are no records.  I know that there is a record based on those 2 fields.  When I go back and use an older version of the InfoPath form and enter just the two fields, the record is returned.

What have I not done properly in modifying the form to only have the two fields to query on?

Any and all help would be greatly appreciated.

I have a multi view InfoPath form associated with a SharePoint custom list.  The form basically has four tabs at the top where clicking each one switches the form view.  The first tab is set as the default view in InfoPath.  The problem comes when you're on let's say the forth tab and click on the SharePoint Edit icon the page refreshes to put you in edit mode but the InfoPath form defaults back to the first view.  I have to click back on the tab I was on to make the change.  

Is there a way to have the InfoPath form not lose its current view when going into Edit mode?

Thanks for the help!

Need to pull a user environment variable from the system the form is opened on, specifically username and use it as a value for a field.
It's a stand alone form opened with InfoPath on the local machine, no SharePoint or other solutions involved.

So far all my searches have come up empty.
I'm thinking I may need to add some VB code?

I know InfoPath has a username function however I need to stop using domain level authentication on the form.
And from what I've discovered that only works with domain level authentication

How to configure Infopath on SP 2016. I used a guide for SP 2013 but it guides me to do the following:

To activate the SharePoint Server Enterprise Site Collection feature, go to Site Setting --> under Site Collection Administration, select Site Collection Feature --> Active SharePoint Server Enterprise Site Collection features  (DONE)
Then,
Make sure States Service is started.  Go to Central Administration --> click Application Management --> under Service Application section --> click Manage Service Application  and If you don’t see State Service in the list, go to Central Admin --> click Configuration Wizard --> click Launch the Farm Configuration Wizard--> click Start the Wizard --> Select State Service and click OK
But this SP has not such a thing as Central Administration.

We've been tasked with a project. The idea is to create some forms, ideally web based, where users can input data that is then stored in our sql server and the form sent on to someone else for approval. (In simple terms).

My idea is to use sql server, SharePoint and InfoPath. Does that seem like a viable solution and does anyone have any prior experience or good material they could share?

I had this question after viewing Extracting text from a lookup field in a SharePoint 2013 workflow.

My issue is that I have three lookups.  They are creating a cascading drop down.  The problem is, to make the Cascading Drop Down work, I have to add the ID of the first list.  So even though the Display on my form does show the Titles the value that is passed is an integer.  Any thoughts on how to capture the text values rather than the underlying ID values?  I am also using an InfoPath form for my form.

-- No responses so I will clarify for simplicity.  
  - Lookup 1 (ID and Title)
  - Lookup 2 (ID, Title, Title from Lookup 1)
  - Lookup 3 (ID, Title and Title from Lookup 2)

This works find for three drop downs on my form.  The issue is when the record is saved, the value (ID Integer) of each lookup is saved rather than the DisplayName.  I'm trying to capture the DisplayName so I can pass it to another list.  I know how to pass the field values, but again, I'm not looking for the ID value, I want to DisplayName value.  I have seen it done with standard forms in SharePoint Designer using Javascript, but I am using Infopath Custom forms. You will see from the image that where EIS Part is the selector.  The field I want to fill is EIS Part A.  Instead of getting the longer text in EIS Part to display in EIS Part A, it shows the ID which is 2.

Hi,
I have some tools created using Infopath forms and SharePoint Designer workflows in SharePoint 2010 which I need to migrate to SharePoint Online. I want to know if my tools will retain the full functionality of both the forms and SharePoint Designer workflows after the migration.

Microsoft will not create a new version of Infopath Forms past office 2013.  Even though sharepoing will continue to allows this it near future office 2013 will not be allowed.  What is the best alternative to using Infopath on Sharepoint 2016/

I have 2 forms for 1 workflow. When I run form A, the workflow runs successfully. But when I run form B, the workflow seems to stuck in In-Progress. Please could someone help and tell me why this happens and what I can do for future occurrence? Thanks Augustine

I have an InfoPath form with a section with repeating tables and it works up to a point.  But some of the columns share the same values when I change them on a row.

Here is the design view:

Here is at runtime:

Please advise/point me to some useful samples/tutorials on this.

I have a "Start Date" column that is a single line of text and displays a value from an InfoPath date control .
In a workflow, I need to compare that value with "now" and if it is greater than or equal to "now" initiate a task.

The Now workflow variable gets it's value at the start of the WF as follows:
Set "CurrentTime" to Current Item:Modified and has the value in the format m/d/yyyy hh:mm A.
The "Start Date" column show the date string as yyyy-mm-dd

As a result of these differences, they never compare equal.

So,  I tried to build a Year variable, a Month variable and a Day variable from the Current Item:Modified column as follows:

1. Copy from Current Item:Modified, starting at 1 for 4 characters (Output to Variable:CurrentYear)
2. Copy from Current Item:Modified, starting at 6 for 2 characters (Output to Variable:CurrentMonth)
3. Copy from Current Item:Modified, starting at 9 for 2 characters (Output to Variable:CurrentDay)

Thinking I can build a string in the format yyyy-mm-dd and then use that for compares.  I don't find a way to build this string nor am I sure if my approach will work.

Any advise on this would be appreciated.

I have been looking hi and low to auto populate user name and department in InfoPath browser form from several sources available
I tried User Profile Service but since Microsoft made it difficult in 2013 version and I am not an admin on the host I can't use this.
 I also tried User Information list. It worked perfectly in InfoPath preview but came up empty when I published the form.

So I tried to use JQuery and SP services. I captured all info in alarms correctly but cant figure out how actually place it in form controls. I use text boxes for all.
<script src="/sites/MySite/SiteCollectionDocuments/jQuery/jquery-1.8.2.min.js" type="text/javascript"></script><script src="/sites/MySite/SiteCollectionDocuments/jQuery/jquery.SPServices-2014.01.min.js" type="text/javascript">
</script><script type="text/javascript">

$(function() {        
     var thisUsersValues = $().SPServices.SPGetCurrentUser({
      fieldNames: ["Title", "EMail", "Office", "WorkPhone"],
      debug: false
});
alert(thisUsersValues.EMail);


alert(thisUsersValues.Title);
alert(thisUsersValues.Office);

alert(thisUsersValues.WorkPhone);

$('textarea[title="WorkPhone"]').thisUsersValues.WorkPhone;
$('input[title="WorkPhone"]').thisUsersValues.WorkPhone;
});
</script>

I created an InfoPath 2013 Form and it is located in a SharePoint 2013 Document Library. This is an HR form for employee change request. The idea is to have the employee go to the doc library and select new document, then complete the form, but instead of submitting the form to the same library, which is the way it is setup right now, rather I need to configure this form to submit to a different document library. The other library will be secure, so that an employee cannot view sensitive data. I looked at other knowledge based articles but could not find a solution for particular for this issue, unless I missed something.

The first document library is open to all employees, but the submit to document library is secure, only for HR use. Is it possible to accomplish this type of configuration in either InfoPath or Sharepoint?

FYI - I'm a beginner with InfoPath and SharePoint.