InfoPath Dev

Hey!!
I am trying to populate a dropdown list, to use in a webbrowser, with only a selection, part of a list. The list is supposed to show the projects on which the logged-on user have permissions to view.

So i have a project List on sharepoint, and on every project item zero, one, or more users have permission to view it.

When a user opens a form, I want him to only see the projects he has permissions on in the dropdown list. Is that possible?

I really hope someone can help me asap :)

thank u!!!

if you have implemented item level permissions on the sharepoint list, then it is ok, the dataconnection will fetch only the records for which the user has access. So just create a secondary data connection to that list and fetch the column(s) and bind it to the dropdownlist..

Qazi Anis:

if you have implemented item level permissions on the sharepoint list, then it is ok, the dataconnection will fetch only the records for which the user has access. So just create a secondary data connection to that list and fetch the column(s) and bind it to the dropdownlist..

If it is data from a Form Library is it also possible to implement item level permissions? Is that by advanced settings of that library?

 With a secondary dataconnection u mean a receive connection for populating the list right? and i dont have to do anything special there?

Thank u so much for ur reply!

it is possible to give item level permissions in sharepoint, to do so just right click on the individual record and click manage permissions... yes, with a secondary data connection i mean a recieve data connection. after you have created the secondary data connection, right click on your dropdown list -> properties -> List box entries select Look up values from an external data source and from the Data source select the appropriate data connection .. also in the value and display value select the required columns..

Qazi Anis:

it is possible to give item level permissions in sharepoint, to do so just right click on the individual record and click manage permissions... yes, with a secondary data connection i mean a recieve data connection. after you have created the secondary data connection, right click on your dropdown list -> properties -> List box entries select Look up values from an external data source and from the Data source select the appropriate data connection .. also in the value and display value select the required columns..

ok, so if i give permission through a workflow, because manualy giving permissions to every record wud be endless ;), thts the same type of permissions u were talking about right?
So if lets say i get permissions on 3 projects of the library then when i open the library ill only see these projects? AND if i populate a dropdown based on this Project form library in an other form, ill only see the projects that i have permissions on in the list?

Please correct me if im wrong!!!

you are exactly right. you will only be able to retrieve those records on which you have atleast read permission.

awesome thank you so much!!

If i have further problems can i contact u through this thread?