InfoPath

Sharepoint Online - Infopath Web Part Page Views

RidwanSassman — Tue, 27 Oct 2020 08:34:31 GMT

One of our project teams has done some investigation on legacy InfoPath forms and found that the forms view does not show correctly on the SharePoint InfoPath web part page based on the view selected in the web part properties. For example the selected view is set to Admin, however the User view seems to be the only view the SharePoint page is selecting when viewing the page. Is there something that we are missing when editing the forms.

Infopath compatible with O365?

Cindy Wang — Thu, 29 Oct 2020 15:01:53 GMT

Hello, Is InfoPath Designer 2013 compatible with O365? Can we publish InfoPath forms to O365 and what are the criteria's needed? What is the alternative app to publish form with O365 if InfoPath not compatible, PowerApps? Thank you Cindy

display Hyperlink for each record in repeating table

NathanWynn — Mon, 29 Apr 2019 14:57:39 GMT

Secondary Data Connection: SourceData

Fields:

ID
RecordName

Added SourceData to view as Repeating table, inserted a column, add a Hyperlink field 'URL'.

I would like the URL to display dynamically the URL to each of the record in SourceData

URL default: concat("https://someurl.sharepoint.com/sites/somesite/Lists/SourceData/EditForm.aspx?ID=", xdXDocument:GetDOM("SourceData")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:ID)

Problem: The d:ID value is static. Every URL on the repeating URL is the same.

Solution: Please advice!

Thank you!

'Submit' Buttons that can actually toggle between 3 different views.

Travis_H — Mon, 06 Apr 2020 19:13:26 GMT

Hey, I have a SharePoint Custom list that uses Infopath Forms for annotating. Out of 5 different views (forms)... After the first 2 views that have 'submit' buttons with rules based on criteria behind them, work fine. My question is, between the last three views, I would like to have buttons that can go back and forth between the 3 without any. criteria. Is that possible?

All formatting rules stopped working as of 9-25-2019

Ruenells — Fri, 27 Sep 2019 16:27:27 GMT

I am building a form with multiple sections and rules based on Yes/No answers to display a comment rich text box. All of my rules have stopped. I do not have any nested sections but have multiple sections on the form. Any idea whats going on? Dorinda

Getting Repeating Table Info to Populate in SharePoint Library

Alton — Tue, 20 Aug 2019 21:37:26 GMT

Hi Everyone, I’m a newbie to Infopath and am just getting acquainted with it, but I’m working on developing a web-browser form that I’d like to feature a repeating table. The issue I’m having is getting the repeating section to populate to my SharePoint library. The information entered into the default fields of the repeating table is correctly captured, but if I opt to enter additional information (by selecting “Add another item, click here”) in my repeating section, that information isn’t submitted to the SharePoint library. Is there a way that I can capture that additional information entered into my repeating section, into my SharePoint library? Thanks, Alton

1 Infopath Form to submit to Various Form Libraries

Stuart Shutts — Mon, 12 Aug 2019 19:27:12 GMT

I am looking at a solution to have 1 form, but based on choices made on that form, a submit button that sends it to a specific form library. My question is, do i need to create a form library for each 'destination' and update the form libraries everytime a change is made, or just update the 'source' library? The 'source library' won't actually get a form submitted to it.

Red Asterisks/Validation Circles Not Displaying for All Users

sw022968 — Fri, 09 Mar 2018 21:34:24 GMT

Hello, I have a SharePoint Online list that is using InfoPath. I have some questions which must be answered before closing a form. Some users can see the red squares around radio buttons and red asterisks in other fields. Others can not. It seems to be random. Many of the users are on the same network, have the same device, and use the same browser. I've attached what users should be seeing. In many cases, the red-dashed squares are missing despite the validation rules being in place. Thank you.

Increment text box value based on different item selected in a drop-down list box

Nnaemeka Nebechi — Fri, 28 Jun 2019 09:27:24 GMT

I created a list on SharePoint Online which I customized on InfoPath for users to input information and it has one level approval workflow. The form has a drop-down list box control labeled Class with values such as Credit, Financials, People and Technology. Also there is a text box control named Risk Number.

In data population, the custodian of the SharePoint list will enter 5 records by selecting Credit from the Class field and enter CR 1, CR 2, CR 3, CR 4, CR 5 in the Risk Number field making it 5 records.

3 records will be entered by selecting Financials from the Class field and entering FN 1, FN 2, FN 3 in the Risk Number field too.

4 records will be populated by selecting People from the Class field and entering PP 1, PP 2, PP 3, PP 4 in the Risk Number field.

4 records will also be entered by selecting Technology from the Class field and entering TG 1, TG 2, TG 3, TG 4 in the Risk Number field.

Please, see the attached Excel file for the data.

After these data has been populated, users that have access to the list will periodically log a request. For each user that selects any Class, the Risk Number should check the last number that has been populated and increment it.

I need help to implement this. Thank you.

How to deal with IP linked image (Excel REST WS) limit 255 chars URL

NathanWynn — Sun, 12 May 2019 01:02:46 GMT

Hi,

I was very excited on the prospect of displaying Charts on an InfoPath after seeing this video

https://channel9.msdn.com/Blogs/donovanf/InfoPath-2010-and-Creating-a-Form-that-Consumes-a-REST-enabled-WCF-Service

I jumped up & down when I got my first chart on the form. That party came crashing when I realized the URL length limits at 255 chars.

I use an Excel chart model and passing values from another data source to graph.

I looked all over to find out the way to bypass, but doesn't look like I could. So now I have to ration the naming and ranges.

I created SD folder in lieu of Shared%20Documents

EC.xlsx for ExcelCharts.xlsx

CB for ChartBudget etc

My QUESTION: is there way to cut down the repeating of 'ranges'?

For example:

https://server/_vti_bin/excelrest.aspx/SD/EC.xlsx//model/Charts('CB')?Ranges('A1')=2018&Ranges('A3')=2019....

I would like to combine to something similar to this: Ranges('A1|A3|A5')=2018,2019,2020

Is it POSSIBLE? Please show me a miracle :)

Preceding 0 is not showing for month calculation

kwizzo — Wed, 03 Apr 2019 17:31:23 GMT

I am attempting to add months to a date that the User selects for a calibration record. I have the breakdown of Month/Date/Year into individual text boxes. To complete the calculation, I need to change the month from a text box to a number, and I have done that with a "Number" formula in the rules for the month text box. When I get the result, if it is under 10 months, it drops the preceding 0 and only shows the number of the month. When converting this back to a date format, it will not accept the single digit month. I am wondering how I can add a preceding 0 to the month (after converted to a number) so that I can convert it back to a proper date for "Next Calibration Date".

How to add a stopwatch to SharePoint Online Task list

Angor — Mon, 25 Mar 2019 16:26:28 GMT

How can I capture current time spend on the task in SharePoint Task list? I want to have 2 buttons, Start and Finish, to get total time spent on a task.

How do i populate a text box using checkbox text fields and also dropdown menu and also date picker

m7bho — Tue, 09 Oct 2018 17:54:34 GMT

Im in the process of trying to make a process when each time i tick a checkbox, type in a text box, select from a drop down menu and also a date picker, where it populates and gets removed depending what's selected or typed in each field in a separate textbox I.e Check 1 Check 2 Textbox1 Textbox2 Dropdownmenu1 Datepicker1 Textbox3 (populated by the fields above also separated by commas)

Having an issue populating an field when INFOPATH Loads.

drcoz — Fri, 31 Aug 2018 21:18:32 GMT

I found this article very useful and was exactly what I was looking for.

https://social.technet.microsoft.com/wiki/contents/articles/32515.restrict-infopath-section-visibility-based-on-user.aspx

but, I've tried to expand on this without success.

I have an access list, based on the above link, that has two columns in it:

AdminUser
AccessType

NOTE: The above link only had the AdminUser, I added the AccessType which would have data like AccessLevel1; AccessLevel2, etc.

Again following the instructions in the above article I got this all to work, but when I tried to have the AdminUser AccessType added to a field in the MAIN data field, it won't copy it for the current user.

I can do a AccessType = AccessType, but that brings back the first records fom the access list, AccessType not the current users.

On form load I did try to added an additional Run these actions "Set a Fields value: Field: AccessType Value: AccessType[ID=AccessType]" but does not work either.

I have put the IsAdmin / CurrentUser / AccessType on the form so I can see what data is being carried over as well. IsAdmin is a field in the MAIN data that I add to add per the above article link.

I searched google and I just can't find a resolution, that I can do. I did find the following, but I don't have access to the http://<Your Web App>/_vti_bin/UserProfileService.asmx; so I can't make this work either.

https://spvee.wordpress.com/2013/04/10/auto-populate-user-information-in-infopath-with-claims-based-authentication-part-1-of-3/

Have deleted and recreated the rules several times trying to get this work as well.

I'm hoping someone has a simple answer.

Thanks for your time.

InfoPath Repeating Table

sriram — Wed, 09 May 2018 07:30:15 GMT

I am new to InfoPath. My requirement is one to many relationships. Step :1, Billing Information is single entry (customer name, Address, Phone) Step :2, Product information is multiple entry (Product Name, No. of Item, Cost). Product Information one or more than one entry. Product Information i have used Repeating Table. I try with SharePoint Document Library Everything is working fine. but Form not open with Browser, It will open InfoPath Form. How to do open with browser. I need to know, I'm going correct way or not. My Screenshot : https://social.msdn.microsoft.com/Forums/getfile/1268735 Please suggest me Thanks Sriram e

[Issue] IP form displaying on HTML page

The Noob — Mon, 07 May 2018 21:39:16 GMT

Hello,

I've had difficulties searching for a solution on this one. Not sure if anyone uses this setup here.

Here's what I have:
InfoPath form published in a SharePoint library saving the files as .xml
I have a JSON string in a text file within the library for that form
jQuery script that fetches the data from the XML
HTML page used as a dashboard which displays the data in the static fields

The condition:

Using IE or Chrome - the data displays fine when I save the file in design preview, but when I open an new document from SP, save back to the SP library it will not display the data. It will display the file name which means it is reading the JSON string in the text file.

If I go into IE under "Compatibility View Settings" and check "display intranet sites in Compatibility View" the HTML page will display the data.

I'm a loss really. anyone encounter this one?

Let me know if I need to provide anymore data to help. Thank you

Attachment resets checkbox and radio buttons

vmarr0y0 — Thu, 03 May 2018 15:05:25 GMT

I have an Infopath form that's being filled via webpart in Sharpoint Online. When the form is filled out, the last step is to attach a few documents. Once the first document is attached, it's almost like there's a refresh taking place on the form and all checkbox and radio selections disappear. Has anyone else come across this and find a solution? Thank you

InFopath form in SharePoint 365 and GPS coordintates

wapfunz — Wed, 25 Apr 2018 20:13:23 GMT

There is a column in the list which accepts GPS coordinates.

The InfoPath Form links to the list.

Hopefully this InfoPath form will be used as an app on a cellphone, connecting to the List, to create an audit form.

Can the InfoPath form be used to capture location and then on upload submit those coordinates to the column in the list?

I imagine a button on the form that says location, and GPS coordinates are established.

InfoPath File Attachment Size Limit

kmgosselin — Wed, 11 Apr 2018 15:04:02 GMT

We have an InfoPath form published to an On-Line SharePoint site. Our site allows files up to 250MB in size. However, when we try to attach a file larger than 5MB to our InfoPath form, we get the following error message: "This site says ... the selected file is to large and is causing the form to exceed the amount of allowable resources. Select another file." Our users are attaching CAD or STL files up to 50MB in size. Is there a way to increase the file size limits?

Restrict user to select same value from multi value check list having same lookup values

prashant99 — Tue, 27 Feb 2018 17:54:12 GMT

Hello, I have infopath2013 form having 2 multi value choice list. These choice list values coming from other list and having the same values. My requirement is that when user select any value from choice list 1, then the same option should be removed from choice 2 or disabled. The objective is to restrict user from selecting same value. If hide value not feasible then we can restrict user from submit.

user name display like i:0#.f|membership|username@domain.onmicrosoft.com

imughalzin — Thu, 02 Feb 2017 16:22:05 GMT

Hi, I am working on infopath form and on form load set text field as username() to show request initiator name on form. problem is that name show like i:0#.f|membership|username@domain.onmicrosoft.com. pls guide how to properly fixed that issue to show user display name properly. Thanks.

multiple and dynamic approval process

imughalzin — Tue, 31 Jan 2017 17:14:16 GMT

Hi, user has to submit document for its approval. user has option to dynamically selects multiple approval while submitting document. document should move from approval1 --> approval2 --> approval 3 and so on depends on approval given by user. Approval has also option to reject document. pls guide how can i build this workflow based on dynamic and no limit of approval person. how to design in workflow. Pls guide. Thx

Display Validation Error Summary in InfoPath 2013

earlgerald — Fri, 12 Jan 2018 16:52:53 GMT

I'm trying to use "Check for Errors" button with code behind to display validation errors in InfoPath 2013. This code below worked in the previous versions. Does anyone know how to apply this code to work in InfoPath 2013 or newer using C#? function CTRL348_5::OnClick(eventObj) { // Write your code here var error; error = XDocument.Errors.Count; if(error != 0) XDocument.UI.Alert("You have not filled in all of the required fields or have invalid data/incorrect format!\n\n\t\tNumber of fields with errors: " + XDocument.Errors.Count + "\n\n[ HINT: to jump to the field with errors, after clicking on OK, press CTRL+SHIFT+O ]"); if(error == 0) XDocument.DOM.selectSingleNode("/my:myFields/my:frmError").text = "enabled"; }

Create a hyperlink to open list attachments on a task approval form

ajaychowdary94@gmail.com — Tue, 09 Jan 2018 16:21:35 GMT

I had an assignment to create list where a link has to be populated in the same list page so that users can approve or reject from same page by clicking a link. I was able to do that using SharePoint Designer 2010 Workflow. How ever I am struct at an issue. The list items have file attachments and when a user opens task form, a hyperlink must be present that directs the user to the respective attachment for the list item. I tried adding the List as secondary data source and based on ascending or descending order of the ID the attachment is being called but not the respective attachment. i.e most recent or the initial attachment is being showed. If I add a repeating section, attachments present for all the items are being showed. I am not able to figure out how to filter out the repeating section so that the respective attachment for the list item is brought up. I am very new and beginner to InfoPath. Any help is appriciated. Thank you

Issue with Rules/Conditions for Multiple Email Submit Data Connections

KTerry — Wed, 06 Dec 2017 19:23:30 GMT

Hi Hilary - I'd like to obtain assistance to solve the following issue with Rules/Conditions for Multiple Email Submit Data Connections Desired Behavior: Behavior 1: The form should trigger an email to a set of users (User 1, User 2, User 3) that have been identified in the To: Email Field associated with the IIS Email Submit 2 Data Connection and cc: anyone added to the Smart Email Field manually if the following Rules, Conditions and Actions are met. Run this Rule when: IIS or IIS – Lite is selected from the GCDO Trial Type Field Behavior 2: The form should trigger an email to a different set of users (User 4, User 5, User 6) that have been identified in the To: Email Field associated with the Email Submit 3 Data Connection and cc: anyone added to the Smart Email Field manually if the following Rules, Conditions and Actions are met. Run this Rule when: CSC Required Field is equal to Yes Behavior 3: The form should trigger an email to a different set of users (User 4, User 5, User 6) that have been identified in the To: Email Field associated with the Email Submit 4 Data Connection and cc: anyone added to the Smart Email Field manually if the following Rules, Conditions and Actions are met. Run this Rule when: a) EMEA or AsiaPac –is selected from the Region Field b) GCDO Trial Type is MAInterventional or MANon-Interventional Behavior 4: The form should trigger an email to a different set of users (User 7, User 8, User 9) that have been identified in the To: Email Field associated with the Email Submit 5 Data Connection and cc: anyone added to the Smart Email Field manually if the following Rules, Conditions and Actions are met. Run this Rule when: a) Region is equal to North America or Latin America c) GCDO Trial Type is equal to MAInterventional d) GCDO Trial Type is equal to MANon-Interventional e) GCDO Trial Type is equal to Collaborative Lite f) GCDO Trial Type is equal to Collaborative Interventional g) GCDO Trial Type is equal to Named Patient Programs NPP h) GCDO Trial Type is equal to Extended Programs / Continuous Access Programs (CAP) Currently only Behavior 1 is working as intended all other rules are not behaving as intended.