InfoPath

Microsoft InfoPath is a software application for designing, distributing, filling and submitting electronic forms containing structured data. The product features a WYSIWYG form designer in which the various controls (e.g. textbox, radio button, checkbox) are bound to data, represented separately as a hierarchical tree view of folders and data fields. All the data stored in InfoPath forms are stored in an XML format. Secondary data sources can be built into the form or they can be accessed through an external data connection to SharePoint or a Web service.

Share tech news, updates, or what's on your mind.

Sign up to Post

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?
0
Take Control of Web Hosting For Your Clients
LVL 12
Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

Hello, I'm getting an error message from Sharepoint that states "Sorry, you don't have a license to use InfoPath Services".  We were under the impression that External users inherit the use rights of the SharePoint Online customer who is inviting them to collaborate.  Does anyone know why I would receive this message if the external user inherits rights?
0
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. Snipaste_2018-02-13_12-24-41.png
0
I am trying to have outside users be able to view, and fill out (edit) a form / list made in infopath, and submit / save to the site list columns.I am using Office 365 (SharePoint Online), and have an InfoPath browser enabled form made from an edited custom SharePoint list on our site. When users 'outside of the organization' try to use it, they receive an error message: "Sorry, you do not have a License to use InfoPath form services, Please contact your help desk" - this is even logging in with Enterprise 3 accounts that have a license included. It seems only users within the organization are able to view it, even though my understanding is browser enabled forms should allow other invited users to fill out and submit. I have activated the SharePoint Server Enterprise Site Collection feature, and believe the permissions are set correctly.

Thanks for your time.
0
Hello!

When I am querying the soap service in infopath, I have a crash error. Can someone explain what is happening?

 System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 10.1.10.70:8080     at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)     at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Exception& exception)     --- End of inner exception stack trace ---     at System.Net.HttpWebRequest.GetRequestStream(TransportContext& context)     at System.Net.HttpWebRequest.GetRequestStream()     at Micr...
...osoft.Office.InfoPath.Server.SolutionLifetime.WebServiceHelper.CreateSoapRequestSyncInternal(XmlDocument soapRequestXml, String soapRequestString, Uri serviceUrl, String soapActionOriginalString, Int64 timeOutMillisec, DataAdapterCredentials credentials)     at Microsoft.Office.InfoPath.Server.SolutionLifetime.WebServiceHelper.CreateSoapRequestSync(XmlDocument soapRequest, Uri serviceUrl, Uri soapAction, Int64 timeOutMillisec, DataAdapterCredentials credentials)     at …
0
I have 3 custom lists and 1 custom form.
 - Country
 - Country , State
 - State, City

On the custom form I'm having trouble connecting the lists correctly.  I have three DDL fields on the custom form.  
Country - New data source from Country list (Value: Title, Display: Title, no filter)
State - New data source from from State list (Value: Tile, Display: Title, filter where Country DS - Title equals State DS Country)
City - New data source from City list (Value: Title, Display: Title, filter where State DS - Title equals City DS State)

What am I doing wrong here?  I get all three dd's with all the values.  They are not cascading based on the prior choice.
0
In SharePoint How to I automate a workflow to save an InfoPath document into 2 separate document libraries on 2 separate child sites?
0
Using InfoPath 2013 with SharePoint Office 360, I want to create an item in a SharePoint list just ahead of creating an item in the SharePoint list for the form being displayed.  I am trying to create a Web services submit connection in InfoPath to do this.  I am uncertain of the url to use in the connection. Here are a few details:

1.  Main data connection is for List 1 in site A.
2.  The form displayed is for data in List A.
3.  When the submit button is pressed, I want to create a new item in List B, then create the item in List A.
4,  When I attempt to set up a submit data connection, I am using https://<tenant>.sharepoint.com/<site>/_vti_bin/<service>.asmx?WSDL.  That works when <service> is lists or webs, but then I don't see add item or anything similar.  And even if it did, how would it know which list to add the item to?

I can't readily locate services for Web services, and am still puzzled by not using a list name.  Is this kind of item creation even possible in InfoPath 2013?  (converting to PowerApps but need something right away).
0
hi , could you help please ?

i have a multiple choice list and i want to add a "select all" check box or button how can i do just with rules , i am not able to add code ?
0
When i am trying to edit the InfoPath form i am getting the error "To use this feature ,you must have an XML editor compatible with Microsoft SharePoint Foundation such as Microsoft Infopath, and you must have Microsoft Internet Exploreer 7.0 or greater"

I am opening this form in IE 11.1 and I have Infopath 2013 installed in my machine.
0
[Webinar] Improve your customer journey
LVL 12
[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

I have an Infopath form submitting data to a SharePoint Online list. everything works as I want it to except one little thing.

When I select the three drop-down items, I have a rule (Screenshot attached) that puts the data into a text field below.

This works fine for one lot of three selections, however, I want to be able to add multiple selections to the textbox without deleting the previous entries.

Does anyone have any ideas how I can do this?
Infopath.mp4
2018-01-19_16-10-56.jpg
0
Edited:
I solved this by using string-length: concat(substring("Yes", 1, (string-length(myFields/LookupColA) > 0) * string-length("Yes")), substring("No", 1, (string-length(myFields/LookupColA) = 0) * string-length("No")))

Original:
I have an InfoPath form on a SharePoint list.  One of the cols in the list is a lookup col. I want to display "Yes" if the list's item is connected to the other list and "No" if it is not.

I used: concat(substring("Yes", 1, (myFields/LookupColA != 0) * string-length("Yes")), substring("No", 1, (myFields/LookupColA = 0) * string-length("No"))). The result is Yes even if no lookup was set for the item. I displayed the value and it is a number if the lookup was set and what appears to be null if not.

What should my formula be to work?
0
Hi Expert

I need your help to create a workflow and a form (using Infopath and SharePoint List )  for Leave request approval.

I need to apply a workflow/List/Infopath form that process like below:

1. After the user fill-out and save the Leave application form, it will automatically start the workflow.

2. Send a notification email to the APPROVER (e.g. Manager), then APPROVER will Approve or Reject the request.

IF Approved, it will automatically send a notification email to HR Department regarding the request.

IF Rejected, the requester will received an email of rejection.

Using SharePoint Designer 2013 to create a Worlflow.

Thanks in advance
0
unable to edit an infopath form and publish the same in sharepoint 2007
0
In  repeating table in infopath 2013, I have a Drop Down list field named "Hours_Type" that has two selections "Telcom" or "Electrical". I then have another field name "Hours".What I would like to do is sum up the "Hours" field based on the "Hours_Type" field selection. So if the user creates a bunch of rows with "Telcom" in the "Hours_type field I will get a sum of of the "Hours" in a different field. If the users selects "Electical" in the "Hours_type" field I will get a sum of those hours in another field. Basicly trying to get the hours for each type in a mixed table. Not sure if I should use rules or formula in the field. Thanks
0
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.
0
0
I have a invoice adjustment form in ERP system and I am manually entering data from invoice adjustment form into Excel for tracking purpose.  If invoice adjustment form is adjusted with QTY, price, customer or other data fields, I get another invoice adjustment form and I have to update my excel.  This can happen multiple times (repeats steps).

1) I want to eliminate manual excel entering/updating process (get rid of excel).  
2)  Extract and auto load invoice adjustment form data into SharePoint.

There is no integration between ERP and SharePoint at the moment.  
What would be technical solution?  

What I need to do in order to map all invoice adjustment fields to sharepoint?
How to handle multiple adjustments on same Order (which means QTY is changed or other fields have changes  on the same Invoice form?

I am not a sharepoint developer or a programmer but I have used sharepoint where created pages, auto acknowledgement email, created a form using InfoPath, etc.,
How sharepoint will manage multiple changes on the same order .

Thank you so much.  Please assist.
0
Greetings,

I am fairly new to Infopath and I am using it to create forms to replace manual office document forms. They will then be published to Sharepoint online.

My current project is a Manager communication form that will require multiple people on it.  
I am using the people picker control to have those fields populated.

Each line in question has a people picker field, Title field, Department Field and a Division field.  (And a spot to initial)

I have the "User Information List" added as a data source. I would like to auto populate the fields after the people picker once the people picker populates.  

I do have Visual Studio installed and set for VB.

Thanks for any help.
0
Free Tool: ZipGrep
LVL 12
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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/
0
I need to build a set of 1 or more InfoPath documents based upon some business criteria going against a related list of recipients of the document.

I have it working using the following function.  Part of the process of building the function is to copy a base (template) XML file down from the document library, turn it into a string with one or more parameters that I insert into that string, and then write the string to content object, upload to the library and then the XML file is available and loads in InfoPath within a browser.

The form has a repeating table which if I populate the form with, the function fails after I take that XML file and use it as the template in my function.

Code follows with abbreviated XML variable as it is too long:
	 function createFile(pParam1, pParam2) {
		var clientContext;
		var oWebsite;
		var oList;
		var fileCreateInfo;
		var fileContent;
		
		var sfileName = "FileNamePrefix_" + pParam1 + "_.xml";
						
		try{
			clientContext = new SP.ClientContext.get_current();
			oWebsite = clientContext.get_web();
			oList = oWebsite.get_lists().getByTitle("RecType SubType");   
			
			var FoundFile = CheckForDoc(sfileName, false);
			var newTemplate = 
			'\n<?xml version="1.0" encoding="utf-8"?><?mso-infoPathSolution name="urn:schemas-microsoft-com:office:infopath:RecType-Audits:-myXSD-2017-07-01T00-23-25" solutionVersion="1.0.0.502" productVersion="16.0.0.0" PIVersion="1.0.0.0" 

Open in new window

0
Hi,
I am currently using Infopath 2013 which is connected into a SQL server Db, My Infopath Form has three fields:

Start_Time - DateTime
Stop_Time - DateTime
Duration - Integer

I am having trouble referencing these fields in visual studio using VB as it doesn't seem to recognise these as actual fields within the Infopath Form as the Duration field just stays blank with no errors?

Basically i'm looking to do this as an After Change event set on Stop_Time:

Duration = DateDiff("s", Start_Time, Stop_Time)

Open in new window


Very very basic VB knowledge here so any help you can give me will be much appreciated.
0
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
0
I have an InfoPath form with a repeating table which has a dropdown.  I can add rows and set different values per row dropdown and save and reload the xml document and the rows and values are there.

I need to be able to do three things with the repeating table:
Read the rows and specifically the value of the dropdown
Add rows and set the value of the dropdown
Modify a row and set its value of the dropdown

I need to do all this within a Nintex Workflow.

Please advise.
0
The title pretty much says it all.  I have an InfoPath document library and I need to set a column within the the InfoPath/XML file to a particular value.  The column is simple text.

Any ideas/links on this would be greatly appreciated.
0

InfoPath

Microsoft InfoPath is a software application for designing, distributing, filling and submitting electronic forms containing structured data. The product features a WYSIWYG form designer in which the various controls (e.g. textbox, radio button, checkbox) are bound to data, represented separately as a hierarchical tree view of folders and data fields. All the data stored in InfoPath forms are stored in an XML format. Secondary data sources can be built into the form or they can be accessed through an external data connection to SharePoint or a Web service.

Top Experts In
InfoPath
<
Monthly
>