Browser Forms

Re: Check if a drop-down list contains a specific value

Hilary Stoupa — Fri, 31 Mar 2017 14:37:17 GMT

Any chance you could attach your form or a sample showing your issue under the Options tab in a reply?

Re: Check if a drop-down list contains a specific value

MaroHamamjyan — Fri, 31 Mar 2017 07:23:19 GMT

A little appendant. I do not want to select any option in list box I just want the rule to work when the form is opened. My main problem is to check if my list contains the username, and as data connections are not working on textboxes I had to use choice type controls

Re: Check if a drop-down list contains a specific value

MaroHamamjyan — Fri, 31 Mar 2017 06:28:30 GMT

Hi there What if I need to check if the List Box in InfoPath, which is surely Choice type, contains the other control that gets the User Name? The expression is: contains(dfs:dataFields/my:SharePointListItem_RW/my:LineManagers, dfs:dataFields/my:SharePointListItem_RW/my:UserName) What should I change in this expression? P.S. List Box gets the values from data connection. Thanks in advance

Re: Check if a drop-down list contains a specific value

Patrick Halstead — Sun, 18 Aug 2013 23:37:06 GMT

Please go to Clay's SharePoint Madness blog site and post your comment there.

Re: Check if a drop-down list contains a specific value

lmelchor — Thu, 15 Aug 2013 18:39:22 GMT

Hi, Im having the same issue and tried to use your instructions but I had a question: Where do I enter the condition I am supposed to create?

Re: Check if a drop-down list contains a specific value

lanita — Sat, 15 Aug 2009 04:10:16 GMT

Thanks for your solution. I got it working now. In my case I needed "If Any Occurrences of drop down are equal to Current User then switch the view".

Re: Check if a drop-down list contains a specific value

warrtalon — Fri, 14 Aug 2009 00:21:33 GMT

this should be pretty simple. Check out my blog post on User Roles in browser forms (I have 2 separate ones, but the concept is the same for hiding sections) and pay close attention to Figure 8:

InfoPath - User Roles in Browser-Enabled Forms Using AD Groups

"If All Occurrences of UserID are not equal to DropDownSelection, then Hide Section"

Re: Check if a drop-down list contains a specific value

lanita — Tue, 11 Aug 2009 20:59:06 GMT

Here is how my data structure looks like:

-myFields

-queryFileds

-tns:GetUserCollectionFromGroup

-Users

-User (this is a repeating group)

:Notes

:Name

:IsSiteAdmin

:Sid

:ID

:LoginName

:Email

:IsDomainGroup

-dataFields

-tsn:GetUserCollectionFromGroupResponse

-GetUserCollectionFromGroupResult

-GetUserCollectionFromGroup

-Users

-User (this is a repeating group)

:Notes

:Name

:IsSiteAdmin

:Sid

:ID

:LoginName

:Email

:IsDomainGroup

Re: Check if a drop-down list contains a specific value

lanita — Tue, 11 Aug 2009 20:37:33 GMT

Yes. But I also tried to query directly the data source.

The rule is set under Tools-> Form Options -> Open and Save -> Rules.

And here is the codition for the rule:

xdXDocument:GetDOM("Documentum")/dfs:myFields/dfs:dataFields/tns:GetUserCollectionFromGroupResponse/tns:GetUserCollectionFromGroupResult/tns:GetUserCollectionFromGroup/tns:User/@LoginName[. = concat("CORP\", xdUser:get-UserName())]

There is no option to set a filter on a data source when you set a condition in the first drop down and choose Select field or Group, so I did it manually in the expression.

And the rule is "switch data source" .

Re: Check if a drop-down list contains a specific value

Hilary Stoupa — Tue, 11 Aug 2009 20:07:27 GMT

Hi:

So what you are doing is checking to see if a user is in a particular field from a secondary data source, and if so, changing a view? What does your rule look like and what is it set on?

Re: Check if a drop-down list contains a specific value

lanita — Tue, 11 Aug 2009 19:57:44 GMT

I'm doing a check to see if the current user is in the drop-down (from secondary data source) and switch to a different view if he is. So, instead of doing conditional formatting I'm adding a rule in the form options.

I followed the steps that you provided but it didn't work for me.

Any help would be apprecatied

Re: Check if a drop-down list contains a specific value

Hilary Stoupa — Thu, 26 Jun 2008 18:47:37 GMT

Beautiful! Glad you got it!

Re: Check if a drop-down list contains a specific value

patricktx21 — Thu, 26 Jun 2008 18:35:09 GMT

Hi Hilary

I may have solved the problem by querying the secondary data source directly and applying the conditional formatting based on the result. The query which appears to be working is

not(xdXDocument:GetDOM("ETL Deployment Approvers")/dfs:myFields/dfs:dataFields/dfs:ETL_Deployment_Approvers/@Net_Id[. = xdUser:get-UserName()])

Thanks for all your help.

Patrick

Re: Check if a drop-down list contains a specific value

patricktx21 — Thu, 26 Jun 2008 18:07:42 GMT

Hi,

Can you please tell me how to paste a screen shot into this forum? It doesn't seem obvious to me.

My options for the secondary data source come from an external source, a SharePoint list. As an alternative I have also been trying to query the secondary data source to see if it contains the user id of the current user and then apply conditional formatting on the result of that query.

Patrick

Re: Check if a drop-down list contains a specific value

Hilary Stoupa — Thu, 26 Jun 2008 16:25:22 GMT

Could you post screen shots for me of your data source task pane to show me your schema? I do understand what you are trying to do, and was successful in the test form I used prior to responding to your first post. For my form, there is a secondary data source providing the options in the drop down list -- are your options coming from your main data source? I think you may be able to do this with conditional formatting, but we need to make sure the filter on that condition is right...