InfoPath: Any occurrence of…

Have you ever had to deal with the ‘Multiple-Selection List box’ in InfoPath? What a headache it can be if you are  not familiar with how to get the selected values.

I am using an infoPath 2013 form with SharePoint. I had a multiple selection list box called request with the following values “Software, Space (West Only), Workstation, Mobile Device (Region & Employees only)”. 

I created a rule on form submit with the following condition: 

Condition: Value = “Mobile Device (Region & Employees only)” 

Rule type: Action 

Run these actions:* Set a field’s value: Status = “Pending”

It basically reads, if the selected value of ‘Requesting'(shows as Value) is equal to “Mobile Device (Region & Employees only)” , set the ‘Status’ value, found in SharePoint, to “Pending”.  Well, that didn’t work and it took me a while to figure it out. Thanks to Data (That’s what I call google-Someone should create a search engine called ‘Data’ like the star trek dude), I was lead to infoPathDev site and got the help I need.

Here was the solution:

When you create your rule and are in the condition area, “Select a Field or Group” –> Choose your Multiple-Selection List field name (‘Requesting’ for me)–>”Show advanced view”–>Expand the folder and select ‘value’–>In the select drop down below, select ‘Any occurrence of Value’–>Click ‘Ok’ and ‘Ok’.

infoPathRules

It will now read, if any occurrence of ‘Requesting’ is equal to “Mobile Device (Region & Employees only)”, set the ‘Status’ in SharePoint.

Hope that helps someone.

InfoPath your way to the top. 🙂

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s