InfoPath 2010

Re: filter rows from two lists

infopathdev3232 — Wed, 17 Jul 2013 07:18:03 GMT

Any solution for my issue???

Re: filter rows from two lists

infopathdev3232 — Mon, 15 Jul 2013 02:45:21 GMT

am using infopath 2010. Yes i selected column(person/group) in data connection, but am not getting same field under query group. As person/group column accepts multiple users, am unable to filter with one user(current user). let me know if you need any other details.. thx..

Re: filter rows from two lists

Patrick Halstead — Sun, 14 Jul 2013 22:04:31 GMT

Did you add the column to the data connection? Are you using SharePoint 2010 or 2007?

Re: filter rows from two lists

infopathdev3232 — Wed, 10 Jul 2013 08:36:08 GMT

Thx for reply. I will make requirement little simple to understand.

List A

ID Name level 3(person or group datatype.. can select multiple users)

1 AB tom;sunny;someuser3;
2 CD someuser1;someuser2;someuser3;
3 EF someuser4;someuser5;

I want to bind Name(field) from LIST A to dropdown list by filtering level 3 field.
ex. if current user is someuser3 dropdown shud show two rows (1-AB,2-CD)
if current user is someuser5 dropdown shud show one row(3-EF)

as you suggested i added dataconnection to list A, and tried to set field value for 'level3' field, but there is no field for 'level3' under 'queryFields'under dataconnection. Here issue is i am unable to filter single user among group of users( as level 3 field can hold more than one user)

Re: filter rows from two lists

Patrick Halstead — Tue, 09 Jul 2013 23:52:32 GMT

Assuming you are using SharePoint 2010 lists and InfoPath ....

Create a list called UserPermissions and create a row for each list that a user can view

LIST, USER
2, mno
1, mno
1, xyz

Add a data connection to your InfoPath form to load the UserPermissions list when the form loads - make sure that you uncheck the box to automatically load the data connection on load. When the user opens the form, use a rule with an action to set the value of the query data field for USER to be userName() and then add an action to query the UserPermissions list. Now, in your dropdown, you will add a filter to show only values that occur in the UserPermissions LIST column.

Easy to do.

filter rows from two lists

infopathdev3232 — Tue, 09 Jul 2013 10:46:36 GMT

I want to implement below functionality.

LIST-A

Name       ID
A       1
B       2
C       3

LIST-B

Name(lookup(A))   usersA(multiple users)    usersB (multiple users)

A           abcd;xyz;lmn       pqr;mno;xyz
B           lmn;123           mno;567

I want to bind all names to dropdownlist from ListA depending on user(usersB column) from LISTB.
ex: suppose if user xyz logged in.. dropdownlist shoud contain only A
    suppose if user mno logged in .. dropdownlist shud conatin both A,B (as mno user exists in both rows)