[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x

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

Hi experts,

My first question in a very long time.  It's good to be back - hope you can help me out.

I'm building forms and workflows using SharePoint 2013 and Infopath 2013.   The problem we have is creating repeating sections on Infopath.

Scenario:
•      We record Budget requests so we have a SharePoint list for these requests.
•      The list captures fields like request title, estimated expenditure, scope etc.  For example:  Title = “Furniture Upgrade”, Expenditure = “$120k”, Scope = “Head Office Block A”.
•      Our Infopath form for these basic fields work.
•      But the form also needs a repeating section for multiple Suppliers related to this budget request, for example:  Supplier Name, Item Desc, Quantity, Cost.


Problem:
•      We can’t find the usual option to insert a repeatable section.



I understand that this might work if a forms library is used but for reporting reasons, we can't go the forms library route.  


Been over this and re-created multiple times but just can't seem to get the option that was always there.

Advice will be appreciated.

Thanks a million
0
Rowby Goren Makes an Impact on Screen and Online
LVL 12
Rowby Goren Makes an Impact on Screen and Online

Learn about longtime user Rowby Goren and his great contributions to the site. We explore his method for posing questions that are likely to yield a solution, and take a look at how his career transformed from a Hollywood writer to a website entrepreneur.

SharePoint column, type=calculation, formula to assign values based on a column with check boxes.
While in the formula box, I do not see the column name to be inserted.  Is that because the column has checkboxes?  So I can add the column name manually, but how do I add the column name & checkbox name.
All I am trying to do is get a sum based on how many checkboxes are checked.  one of the check boxes is worth 9 points, the others are worth 3 points.  The column name is Risk.  I was trying to have it max out at 9 points.  so the first if was going to sum just the first checkbox if true, or sum the other 3 for a total of 0-9.

=if(checkbox1=true,9,sum(if(checkbox2=true,3,0),if(checkbox3=true,3,0),if(checkbox4=true,3,0)))
or 
=if([checkbox1],9,if([checkbox2,3,if(checkbox3,3,0)),0)
or
=sumif([checkbox1],9,sumif([checkbox2],3,....

Open in new window


Using info-path with a SharePoint list.  It does not allow you to set a name to each checkbox.  Looks like it defaults to "value"?
So i tried using the title of the check box, and tried using checkbox1 ....
Here is what the question looks like
Thanks in advance,
Jim
0
Hi,

How can I automatically retrieve the Manager email address in an text field in InfoPath 2013?

I tried to return the Manager properties in my InfoPath list form using the UserProfileService.
I get an i:0#.f|membership|.........@iteenv.com in the Manager email address text field.
I only want to display the email address. How can I fix this?
0
I created a form in InfoPath which has a status dropdown field. The dropdown options are: Cancelled, Draft, Submitted, Pending. The default value for this field is Draft. I wanted to create a rule so that when a user clicks on the submit button, the status is updated from "Draft" to "Submitted". Is this possible?
0
Hi,

Can you please assist me.

I have designed a Leave Request form in InfoPath 2013.
I want to disable dates (holiday dates) in the Datepicker control.
I also have 2 time fields (Start and End time).
How can I calculate the time difference between these 2 fields?
0
InfoPath 2010 form submission is not saving to sharepoint 2010 site, and end user has no errors upon submission.  The .xml file does not get saved to sharepoint, how do you troubleshoot this?  I figured it was something like incorrect permissions to a site/library for the end user to save their files.  But I check an Identical user permission with someone that is able to submit and view their documents.  The user that does not work has identical permissions.  Its very strange, and there are no reported errors from the user...
0
I have an InfoPath form that I need to validate that when they enter authorize amount in two different text boxes a dropdown will change base on the criteria sample dropwow = Level1 Authorization amount < or = USD 25MM or Authorization box 2 < or = USD 15MM
                    Level 2 Authorization amount < or = USD 100MM or Authorization box 2 < or = USD 50MM
                     Level 3 Authorization Amount < or = USD 200MM or Authorization box 2 < or = USD 100MM

Can someone help me
0
Hello I am in search of a solution in SharePoint 2013 using javascript or a 2010 workflow,

 that calculates total time to resolve a help desk ticket during business hours 9 - 5, minus weekends and holidays and minus anytime clock was stopped, for example time that would not be counted against a technician because customer was unreachable.

Additional details:  If a technician places a ticket in hold status, time should not be counted against time to resolve.

thanks,

Dee
0
I originally built an InfoPath form with repeating tables for Employee Expenses, which works great, but this doesn't work on mobile. (We want to be able to use on mobile and take pictures of receipts). So I started over and I've built a Powerapp for employee expenses, and the data goes back to two SharePoint lists. One list is Expenses, which is the employee name, dates, status, etc. The other list is LineItems, which is each expense detail, which is then a Related Items web part on the default display form for the Expenses list.

I have searched everywhere for a solution that will allow me to have a field in the Parent list (Expenses) that will show a grand total of all of the related expense items (Line Items list). I need this to be a field to trigger an email (using Microsoft Flow) in the event the Expense total is more than $1,000.
0
Hi All,

I am trying to add  Javascript or JQuery in my Infopath form. I am looking for a workaround without any custom code. How can we refer a javascript file to an Infopath form.

I want to extend the tool tip duration in my form and I tried doing with XML as a secondary data source but it doesn't read my script or css file.

Any suggestions would be appreciable. Hoping for a reply soon.
0
Learn Ruby Fundamentals
LVL 12
Learn Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

We have a form set up with Sharepoint 2013 and InfoPath 2010.  We also have Oracle 12..
What is the best way to automatically get the information into an Oracle table on a periodic basis (nightly) or to have the ability of Oracle to link to it?

The catch is we are in a corporate environment and do not have access to the Sharepoint server, SHarepoint Designer or Internet Information Services.


Jerry
0
I have an InfoPath form implemented on a SharePoint List in SHarePoint Online. How do I print out the InfoPath form.
0
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 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
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
Exploring ASP.NET Core: Fundamentals
LVL 12
Exploring ASP.NET Core: Fundamentals

Learn to build web apps and services, IoT apps, and mobile backends by covering the fundamentals of ASP.NET Core and  exploring the core foundations for app libraries.

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
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
>