Data Connections

Is GetUserProfileByName via SOAP connection deprecated?

Rich33 — Mon, 06 Oct 2025 12:35:35 GMT

Does anyone know if Is GetUserProfileByName via SOAP connection is fully deprecated? Last year at this time I was able to create a new form and make a data (receive) connection with GetUserProfileByName, but this year I get the popup "InfoPath cannot find or cannot access the specified Web service description." I know Infopath will be fully retired on July 14, 2026, but was hoping to eke out one last form collection.

Word Print for InfoPath Form Connected to Access Database

slendertech — Mon, 20 Jan 2025 16:05:06 GMT

I'm creating a form in InfoPath 2007 (yes, I know it's veeery old) for my dad's business that needs to utilize the Word print view functionality so I can print form responses to a very specific custom layout. I've been able to get a hold of the InfoPath 2003 SDK so I can use the InfoPath to Word Wizard to create an XSL file from a word document with my form template's XML schema attached.

Here's where things get tricky. I created my form based on an Access database to allow for form responses to be submitted to the database (so he has a record of every customer he has worked with). Therefore, all the fields in the form correspond with fields in the database and are bound to them. The problem is that it seems InfoPath makes every field a Field (attribute) instead of a Field (element) when basing the form template off of a database. I also cannot seem to change this. Therefore, when I try to lay out where I want the information from filled forms when printed to appear within my word document, there is only one element titled "Order_Database" (the name of the table in the Access database that stores the order history) for me to position on the page that has many attributes (e.g. customer_name, order_date, address, phone, items).

How am I supposed to lay out the document for printing when the form fields are attributes of "Order_Database" (I cannot position attributes all over a page)?

Get List Data using owssvr.dll connection

SeanPRyan — Wed, 07 Aug 2024 21:31:05 GMT

I have traditionally been able to interact with list data for an InfoPath form by taking advantage of the owssvr.dll by selecting XML and using this path (similar): https://myServer/sites/SE/_vti_bin/owssvr.dll?Cmd=Display&List={22222222-FFFF-3333-9999-222222222222}&XMLDATA=TRUE&noredirect=true. I use this to filter and sort, or simply choose a specific view since a direct list connection orders by ID. Recently this appeared to have changed. I have existing connections working fine in SharePoint 2016. I am attempting the same thing publishing the form to SharePoint Subscription Edition with no luck. Now, if I convert this to a Connection File and authenticate using Secure Store credentials, it works. My basic question is if anyone has experienced this and if this is now required much the same as the GetUserProfileByName which needs to be converted to work. Thanks as always.

GetUserProfileByName Validation Error for two employees with the same name

SeanPRyan — Thu, 08 Feb 2024 16:37:34 GMT

I have a way to solve what I need for now, so this is a curiosity with this connection. I have two users with the same name in my organization. Let's say Jane Doe. Both have unique user ids. I first get the logged in user domain\LoginId. Then, I Set the Account Name, Run the Query and Set Employee Fields. The fields even set correctly for the Department and a few others. But, when the user hits submit, it fails with a validation on the name that shows in the Employee people picker field. It works for everyone else except Jane Doe. For now, I've simply changed the rules to everyone except Jane, run the rules. Has anyone bumped into this before? If so, what did you do to solve? Thank you!

How to link a Query for Data rule with field

cardinaltalos — Tue, 26 Jan 2016 12:35:46 GMT

I'm trying a solution read elsewhere on this forum that describes how you can avoid waiting for a very slow receiving secondary data connection and use Query fields to filter out the data. I'm having trouble with the second step "Create a Query for data rule" which brings the matched data into the Query field, then supposedly a third rule I would need to create which would populate the field I'm trying to populate!

I have a simple field which a user has to type a number into. This field currently has a rule:

When field changes:

Set Department field where match to a Secondary Data source is valid
Set Job Title field where match to a Secondary Data source is valid etc...

This all works but is extremely slow and quite often times out with InfoPath errors. I think the solution is use Query fields above but as I said I'm struggling to understand the steps provided by another user on this forum. There is no explanation on how to use the Query for Data rule alongside the other rules.

Hilary? Or anyone?

Any help? :)

Subtract Approved Form Value from Secondary Data Source SharePoint List Column

LaceM — Thu, 01 Feb 2024 18:18:25 GMT

Banging Head against the wall.... I have an InfoPath 2013 Form that customers request supplies from that saves to a SharePoint list. The form has a repeating table that is linked to a secondary data source (SharePoint List) that contains an inventory of supplies The customer selects a "Nomenclature" from a dropdown list (secondary data source) their selection inputs a default value of 3 repeating table fields (items ID #),(Cost), (UOM). The customer then inputs the quantity they are requesting of that item. When they submit the form it is sent for approval - once approved I would like to subtract the quantity requested of each Items ID# from the secondary data sources quantity on hand field. Is this a rule I can add to the "Approved Button" if so a little guidance would be greatly appreciated, been working with so many formulas and rules that Im feeling stumped. Thank you

Display Submit Success

phil8228 — Wed, 02 Feb 2022 16:19:58 GMT

Trying to find a way to show users a message when they click submit and its successful. The form is basic information, few required fields, won’t allow to submit without them filled in. The submit button has condition, that the user needs to check an acknowledgement box. Then the only rules for the submit box currently are submit data via email, for my testing. Production form submits to SharePoint library. Then on both forms (test,prod) the form closes. Using InfoPath designer 2013, 15.0.4805.1000, 64b. In the submit options, I have the ‘show the submit button’ checked. In submit, advanced, I have ‘show success’ and ‘show fail’, options checked. Then after submit, close form. ----------- When I preview the form (in infopath) I am able to see the submit button, upper left and the button created on the form. Both submit the form. When I use the submit in the upper left of the form, I do get the form submitted successfully. It’s when I use the one on the form that I don’t see the message. ----------- I thought of just removing the submit option on the form but there are two issues. 1. Users/Testing can’t see the submit button in the upper left corner. a. Think this is the bigger issue 2. The acknowledgement required check box. I would rather use the submit button that is on the form.

create multiple files by submitting form

mahoii — Thu, 29 Jun 2023 18:43:47 GMT

hi We have a form that contains a multiple-selection-listbox control box. (Personnel names) I am trying to create unique files that contain selected personnel names from the mentioned control box. I've tried eval,double eval, variable from workflow 2010 but no chance. Is this possible to create multiple file with dedicated workflow for selected names in control box? For example, when I select Eli, Paul and john from the list, after submitting the form 3 files that start with names be created automatically. Regards

Filter not working between two DataConnections

FranzS — Wed, 22 Jun 2022 09:57:43 GMT

Hello Forum ... thanks to be a new Member! I follow your forum since many Years and got real helpfull Information - Thanks for that and great work :) Maybe you can help me in this particular Problem ... i have two DataConnections in Listbound Infopath Form ... 1. Task Templates (eg. Task1, Task2, Task3, Task4, Task5) 2. Active Tasks (eg. Task3, Task4) Bind DataConnection 1 to Drop Down List Box Data Source and the result should be: Task1, Task2 and Task 5! And this is my Problem, which i tried to solve in many Ways ... The Filter is "working", if i choose "equal to" - i get only Task3 and Task4 but if i choose (my requirment) "not equal to" - i get all Items from DataConnection1!? Also tried the Filter with "all occurance of Title" or "Any occurance of Title" (on the left side of Query, cause the Option is only available on the "left" Side - which should be on the "right" Side of Query in my understanding, but not possible). Tried Expressions with not() and != and many other combinations, tried "not contains" and so on - No success. Hope someone can help me with that after days of failures. Thanks. regards Franz

SharePoint 2010 published InfoPath form encounters data connection error to SQL2016

ocsnew — Tue, 30 Nov 2021 01:55:47 GMT

I have an InfoPath form published in SharePoint 2010. The form contains a data connection to a SQL Server 2016 database using a .udcx connection (uploaded in SharePoint).

The problem is that when attempting to connect using the data connection, it throws the following error: "A database that contains data required for this form to function correctly cannot be found"

Upon checking the database server logs, the following is the error: "Login failed for user 'username'. Reason: Password did not match that for the login provided. [CLIENT: clientname]"

However, please note that using the SAME credentials and connection file, it is able to successfully connect in the following cases:
- Connecting via SQL Server Management Studio (same credentials)
- Accessing Data Connection in InfoPath Edit Mode
- Accessing Data Connection in InfoPath Preview Mode

It is only throwing out the error once the form is published.

Can you please help or suggest ideas why the error occurs only for that specific situation?

Auto populate contact info from another SP list

markikav — Fri, 08 Oct 2021 10:52:08 GMT

Hi Hilay

I'm trying to auto populate a "review" list with 3-4 fields of contacts info that are already stored in another contacts list.

The contacts list is quite large, about 2K records at the moment so I put in a button to query data from that list.
Do I simply put the function on each of the contact fields (Name, Email, Phone) to the contact list (secondary list) and then filter where my customer reference numbers match, or is there another step needed as it's not populating after button click

Or is there a simpler way to do this?!
I'm also getting the amount of data returned by data connection has exceeded the limit, so I need to get onto the admins about increasing I guess, or do I if there is a more efficient way to complete the same goal?

Thanks as always

Rest call in infopath 2013 An error occurred querying a data source.

sb_infodev — Wed, 13 Oct 2021 07:40:48 GMT

Hi All, I have a sharepoint list with around 2000 records( lets say list A), I have to check whether the data entered in the new item for LIST A already exists in the same list (List A). the normal data connection to the list takes a lot of time to load. So I wrote a simple REST call just to get the specific item. https://(Site name here )/_api/web/lists/GetByTitle('LISTA')/Items?$select=ID&$filter=hidden_bAi eq '02-12' This query works in the browser, even in the infopath form I am modifying this rest call to update the query and the querying it . I am also printing it in a variable tp check if the REST call is correct and it is, it works in browser. But when I publish the fomr, it doesnt work. An error occurred querying a data source. Can someone please help me. Thanks.

Submitting subset of form fields to email

markikav — Tue, 24 Aug 2021 07:20:42 GMT

Hi Hilary!
I have an infopath form with sharepoint list connection for a service desk process which I want to just extract the customer reply into an email.
I'm triggering the email by using a particular status field, so if status = "Send Mail" then action is to submit to email.
This form has multiple views and I only want to send the customer reply fields, nothing else, so have created a specific view for this.
I'm finding that the trigger field must be on the view where I save the form or else it won't work, is this normal?

So I have created a specific view where they should click Save that only contains the customer reply text fields AND the progress status field, but I want to hide the progress status field so eventually they could just fire the reply directly to the customer from SharePoint, at the moment I'm sending the mail to their helpdesk mailbox first so they can QA it and then send on to the customer..

sudden issue when querying Sharepoint REST

dan508 — Mon, 05 Jul 2021 12:38:35 GMT

Good day all. Infopath has been working fine for us for the last couple of years now with no issues. However over the last week, all forms have suddenly ceased to work with Sharepoint's REST API with an error message of 'The file is not a valid XML file. Not enough memory resources are available to process this command' I've confirmed that this issue is specific to the infopath client- Using the 'Fiddler' program, I can see that sharepoint is sending the results in xml without a problem fine from the server yet Infopath still fails to process it. This started occuring on all users' devices at the same time. The server has had no updates. I have uninstalled all updates installed around the time that this issue first occured on my PC but the issue persists. As mentioned, this is an issue related to infopath, guaranteed. I can see the results being returned from the Sharepoint server. In addition, Nothing is logged on Sharepoint's ULS and Fiddler shows that the xml response is being returned correctly to my pc- the issue seems to be Infopath not translating correctly

GetUserProfileByName fires on second change to dropdown

SeanPRyan — Thu, 10 Jun 2021 19:36:12 GMT

I have a connection file on my client's site. The InfoPath 2013 form should set the current user 3 nodes when the dropdown changes. I compare this with a hidden counter field which is blank on new entries prior to submit. When I choose an entry from the dropdown, hidden sections show. The people picker is within the section. The rules don't fill the field on the first try. Now, when I change the dropdown to another value, it fills as I'd like. In the Form load, I set the logged in user to a hidden field. I set the AccountName to this value and Run the Query. On the dropdown, I set the 3 nodes. Why does it work on the second try but not the first? I've tried changing the postback settings to always and this still occurs. I also created a new basic form on the same site where this does not occur. Thanks in advance.

Data Connection Maximum limit error

lucky4anshh — Tue, 13 Aug 2019 15:44:16 GMT

Hi All, I have created this form which has around 250 fields and the secondary data automatically populates data on the basis of a field. There are around 24 fields where the secondary data is stored automatically. I have stored the secondary data in a drop down list. I get the below error now. I uncheck couple of fields in the secondary data connection and then it works fine. Then again it happens after couple of days. The error message is below: The amount of data that was returned by a data connection has exceeded the maximum limit that was configured by the server administrator. Click OK to resume filling out the form. You may want to check your form data for errors. Note: I do not have access to the developer options in the form and also to the Central Administration.

attach a document from infopath form to a document library

lionheart2308 — Sun, 14 Feb 2021 05:12:24 GMT

hi,

so basically i have a infopath form with few fields. what am looking for is the user needs to upload a document from (by pressing a button or a link) within the form to a document library.

its like attaching a document but once he submit , the document should be placed into a document library.

can i create a button or a link in the form to upload the document?

thank you

Data Connection-Email-High Importance

mdc86 — Sat, 30 Jan 2021 12:09:31 GMT

Hi, Does anyone know of a way to make emails sent from a data connection to be flagged for the receiver as “High Importance” ? I’m pretty new to working with InfoPath so appreciate your help.

Date and Time filtering based on condition querying SharePoint lists

Wanzer316 — Fri, 08 Jan 2021 17:27:20 GMT

Hi, I am new to the forum and have a question about date and time filtering querying SharePoint lists. I am putting together a room management application where the user submits a form that captures the meeting room details, date/time and locations. The details I am having an issue with is the date and time which can be a day or range. I am trying to figure out how I can query the SharePoint list for dates where meetings have already been approved so that the locations that have availability will be shown for the user to select from. This is so I do not get double bookings. I have several rooms they can choose from so what I have tried so far is to use conditions on the sections for each location that would show the location available if the date ranges do not match for an approved meeting already. I have tested using the "calendar name" which is the name of the field in the calendar which specifies the meeting room location. I have successfully tested this works but when I add date meetingstartdate greater than or equal to startdate and meetingenddate is less than or enddate I see the section disappear once the startdate is selected that meets a date that I have in my list but the range between startdate and enddate is not working to set the range as if I select a day out side of the startdate or enddate the location in the section that should be hidden as a selection appears. This then gives me as a user the opportunity to schedule a meeting one day before the startdate and one day after the enddate for the same meeting location. Any way to fix this?

Filter secondary data connection with specific string value on form load

Ghoztrider — Wed, 18 Nov 2020 15:59:51 GMT

I have a drop down field in my main form that grabs the title field data from a secondary data connection. I'm now getting the "Exceeding data limit error". I need to now query the secondary data connection to bring back the title field data based on specific statuses(In Progress and On Hold) in the status field from the secondary data connection. Is this possible? I know how to map and query using fields from secondary and main data connections, just not using specific string instances.

Query people column from Sharepoint list

Dekstar — Wed, 11 Sep 2013 10:50:03 GMT

Hello everyone, I am currently trying to filter my list datasource. It works great but when it comes to a people-column (author) there is a strange behaviour. First of all the author-column is a simple text-field in queryFields. When I try to filter this field with userName() there is no return (but actually the list is full of items with current author). What can I do to filter for a specific user? Next, when I look at the dataFields, I see what I also expected in queryFields: (pc:Person with DisplayName, AccountId, AccountType). When I output DisplayName it shows up like this: Surname,, GivenName. Why two commata? Hope you can help me out. Infopath 2010, Sharepoint 2010 Std.

Sending an automated email from an InfoPath form that is not a copy of the filled-in form

mklauss — Fri, 14 Aug 2020 17:31:58 GMT

Hi, I've done some research and have not seen the question asked so far. I'm trying to come up with a way to automate an email that includes specific wording as a template but also adds information from 1 field in the existing form. It seems the only way to send a email is to include a copy of the form and normally that works but not in this instance. Any ideas? I don't have Designer myself but wanted to see if anyone has done this or has an idea. Thanks.

Latest Value of Data connection date field

lucky4anshh — Wed, 29 Jul 2020 05:42:22 GMT

Hi All,

I am stuck at this part of the form where I need help. Please see the below points what I am trying to achieve:

1) It is a desk booking form and the user has to book their office desks before reaching office.

2) The desks once booked cannot be assigned to other person on the same day.

3) I have linked my current form with the secondary data connection with the Date and workstation number as a reference field to block desks.

4) When I apply these rules, the form takes the latest date or an old date to match the data with the booking date.

5) eg. I have generated a booking for 30 july and 5th aug. The desks are now booked. When I proceed further to book same desk for 31st july it says desk not available. When I try to book for the same dates eg 30th and 5th it shows the desks are not available and that is fine. But why not show availability for 31st july and future dates?

My aim is that the form should check that specific desk availablity on that date and return the result

Am I missing something?

Regards,

Anshul

Count rows of Data with certain parameters

deryozzy — Wed, 27 May 2020 11:15:07 GMT

Hi, I am really struggling with this and I'm hoping someone will be able to help! I have two lists List A (Area) and List B (Units). List B has a Lookup field (called Area) to List A (Column "Title"). List B has a status field which can one of two Status - "In service" and "Out of service". I have two fields in List A called "In service" and "Out of service"so beside each Area item I want to show a count in the field "In service" where all the items in List B Area field is equal to List A Title Field AND Status is equal to "In service" I have tried a few ways to do this and cant find anything that works . Thanks in advance to anyone that may have any insight!!! Dee

Filtered Sums

Froman — Tue, 10 Mar 2020 18:06:27 GMT

Hi, I found a way in this forum to filter a column sum, but I don't understand the formula, can someone explain how I can use this formula please?

RaYvA:
Hi, Yes you can do this from a list form.

You can use these formulas in rules to update fields in your schema or you can use them in Calculated Values. Easier to use the 'Edit Formula' (Fx) button to help you. You coulds then also filter the return based on other selected fields in on your form or explicit filters:

Example, after querying the 'Costs' data connection this formula returns the sum of the costs ONLY for the 'Commercial Owner' who's values is 'RaYvA':
sum(xdXDocument:GetDOM("Costs")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Amount[../d:Commercial_x0020_Owner = "RaYvA"])

Cheers

sum(xdXDocument:GetDOM("callup-DC")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:total_x0020_value)

this is what I've got so far, and it gives me the column sum, but I don't understand how @RaYvA filtered it. does anyone understand this? I would like to filter it based on field in this list, but if there is a way to filter based on another list that would also be massively useful Thanks