InfoPath Drop-down list with choices of the same values

There was a scenario that I came across while developing an application.There was some issue that I was facing in InfoPath drop down that contained items with same values

Repeating table’s column promotion/concatenation when data is from secondary source

My Learnings

When a repeating table has data from the Main data source, you can concatenate and promote the columns as I have already discussed in my previous blog here.

And I was with the mindset that it would work with secondary data source as well, but that was my misconception.

When a repeating table is bound using a secondary data source, then the formula to concatenate the columns of the table changes.

If we use the same old formula, the output won’t be as expected.

View original post 91 more words

How to set current user details in an Info Path form

My Learnings

userName() method of Info Path form returns the user id/ account id. To get other details such as display name, email id, manager, phone number, etc., we can use the web service “UserProfileService.asmx”

Lets say we want to get the display name, email and accound id for the currently logged in user.

View original post 308 more words

Clubbing InfoPath Form & Nintex Approval Form

My Learnings

Whenever an Info Path form published to a form library has to undergo approval using Nintex, the default approval form will have options to approve/reject and provide the comments. However, not all details of the form can be seen on the same page (until it is a list item’s approval page). Only the fields promoted from the Info Path form to the library can be seen in the approval page. So here’s the reason why I’m posting this article. In my case, the customer came back to me saying why can’t they have a single form that displays the details of the library item i.e. the Info Path form along with an option to approve / reject at the bottom of the same form. So, a bit of research helped here and here’s the solution.

View original post 523 more words

Redirection to a page on InfoPath form closure inside an InfoPath Form Web Part

My Learnings

Info Path Form Services is a wonderful component of Microsoft Office that allows the development of simple forms with moderate complexity. The service allows Info Path forms to be hosted in a SharePoint web site and served using a browser-based interface. With only rules and no code (most of the time) and a browser enabled form, the Info Path Form works for machines even though the Info Path client is not installed. In a nutshell, the Info Path form solves much of your problems without writing any code and even without the client – quite useful to me most of the times.

Problem Statement
However, every time I create a rule to close the Info Path form after submit or cancel event, I end up with a message “Form has been closed”. My users were definitely not happy with it. They wanted to be redirected to some page after they…

View original post 598 more words

Repeating table’s column promotion & extracting individual data

My Learnings

Repeating tables in Info Path is no doubt a wonderful control that gives the users the suppleness to enter information in a table. But when it comes to use the individual rows/columns of this very table in SharePoint, all doubts and fears surface.

Same was with me so I decided to write about it.

Problem statement – How to promote a column of a repeating table and how to extract the individual row of data.

View original post 319 more words