Infopath Forms need to change the form's approval status in bulk (Multiple forms, on Sharepoint 2010 site.

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

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.

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.

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.

hi all,

I hope someone can help  / show me where to look.
We have a list (let's say a To-Do list for example), and when someone clicks "New" a form pops up and people enter details, hit save and it gets added to the log.
The person who made the form is away at the moment and we want to modify the form. I'm not sure if it was built on InfoPath, Excel (is that possible), etc.

My question is: how can I find where this form resides and edit it? We need to add some more fields but I've looked around the site (even doing a search for .xsn extensions) and googled away but no luck. I've looked in each document and list library but can't find it. There has to be a way? The drop downs in the form I can modify / add things as they're just in the list, but the form itself - I'm at a loss. I hope someone can point me in the right direction.

Thank you in advance.

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.

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 …

In SharePoint How to I automate a workflow to save an InfoPath document into 2 separate document libraries on 2 separate child sites?

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

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.

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?