Use the SharePoint '[Me]' Filter with a Promoted Property

re: Use the SharePoint '[Me]' Filter with a Promoted Property

handaman — Wed, 17 Mar 2010 17:28:55 GMT

I've attempted your steps using MOSS and IP2k7 and am not able to get the [Me] filter to work. The Assigned to Id field is a ##, when i add the [Me] filter i get "Filter value is not a valid text string. What step am i missing?

Thanks

Blog of an overweight SharePoint addict » Infopath forms with User ID’s

Blog of an overweight SharePoint addict » Infopath forms with User ID’s — Wed, 30 Sep 2009 21:00:43 GMT

Pingback from Blog of an overweight SharePoint addict » Infopath forms with User ID’s

re: Use the SharePoint '[Me]' Filter with a Promoted Property

johnb — Mon, 02 Mar 2009 00:36:26 GMT

I added this to a form I'm creating for my team and it seems to work, but it promoted an ID number in the Assigned To ID field and not the user names; thus I can't use the [Me] filter...for the life of me I can't figure out where I went wrong...any advice is greatly appreciated

re: Use the SharePoint '[Me]' Filter with a Promoted Property

briwagner — Thu, 13 Nov 2008 20:59:54 GMT

Nevermind I found where the SharePoint User Info List was being limited to 100 items.

Brian Wagner

re: Use the SharePoint '[Me]' Filter with a Promoted Property

briwagner — Thu, 13 Nov 2008 19:25:56 GMT

I have duplicated your steps in InfoPath 2007 with WSS 3.0 and I get some usrs listed in the dropdown list but not all, it cuts off after 100.

Is this supposed to happen or am I missing a setting in WSS somewhere?

I did add the data as a repeting table to verify it was not a control liitation and the table stops at 100 as well.

Thank you,

Brian Wagner

re: Use the SharePoint '[Me]' Filter with a Promoted Property

JeniEck — Thu, 24 Jul 2008 08:42:15 GMT

Hi Greg,

Please can you help with this? Your code works perfectly in preview from Infopath but when I publish it to my moss 2007 forms library I get the message shown in my previous post.

I can click continue and fill out the form but I do not get the drop down list of sharepoint users?

Any ideas?

Thanks

Jeni

re: Use the SharePoint '[Me]' Filter with a Promoted Property

JeniEck — Wed, 23 Jul 2008 10:52:14 GMT

This works fine for me in preview on my machine. However when I publish it to my forms library I get the following error. Have I missed something?

-------

Warning

There has been an error while processing the form.

Click Continue to resume filling out the form. You may want to check your form data for errors.

Click Start Over to load a new copy of the form.

Show error details

An error occurred accessing a data source.

An entry has been added to the Windows event log of the server.

Log ID:5566

-----

Thanks

Jeni

re: Use the SharePoint '[Me]' Filter with a Promoted Property

Yurnero_ — Thu, 12 Jun 2008 12:38:11 GMT

What if we want to make a filter on lets say a manager. For example if managers have to validate forms, how to filter and show to the mangar only the forms from his team member. I tried with SP ID Name or Account extracted and then promoted but this dont work...

re: Use the SharePoint '[Me]' Filter with a Promoted Property

Craig Schaefer — Wed, 05 Dec 2007 18:11:18 GMT

Is there a way to have the list of Users sorted? Right now they come back ordered by their ID.

re: Use the SharePoint '[Me]' Filter with a Promoted Property

zullu — Wed, 11 Jul 2007 19:04:04 GMT

Hi Greg,

I would like to know something about the "PROMOTED COLUMNS".

Is it true that I can't update a promoted column from my VS2005 code?

It shouldn't be, else this would be a real handicap to a developer.

I have a InfoPath 2003 Form. I have published the form to sharepoint 2007 Form Library.

While publishing, I have promoted few columns to appear as the library columns. (for instance, "varApproveRejectStatus")

Now I am trying to update that column from a web part using C# from VS2005.

Code snippet:

.........

........

myItems = master.GetItems(query);

foreach (SPListItem item in myItems)

{

item["varApproveRejectStatus"] = "COMM_PUBLISHED";

item.Update();

}

.............

Here is the problem.

The promoted column "varApproveRejectStatus" is not updated even after the execution of the item.Update();

If I use the "Title" column of the Form Library to update (which is not the promoted column), the update works superbly.

Is this a known bug in MOSS or really updates to promoted columns are not allowed.

I would be crossed to know that MOSS doesn't support this kind of updates.

I very badly need to update this as this would trigger my workflow to move ahead.

Any help!!!

Thanks in advance.

zullu

re: Use the SharePoint '[Me]' Filter with a Promoted Property

jeagly — Tue, 10 Jul 2007 20:45:44 GMT

Hi Greg,

Is there a way to set it up where only the Assigned To receives an email when selected?

re: Use the SharePoint '[Me]' Filter with a Promoted Property

jeagly — Tue, 10 Jul 2007 20:37:28 GMT

Never mind I got it. I was not selecting the Form library. sorry!

re: Use the SharePoint '[Me]' Filter with a Promoted Property

jeagly — Tue, 10 Jul 2007 20:27:20 GMT

Hi Greg,

My form works but when I tried to publish it to the SharePoint site, I got the following error.

InfoPath has encountered an error. The operation failed. Access is denied.

I have been able to upload other forms to this site before. Why can't I upload this form and what is the fix for that?

Thanks

re: Use the SharePoint '[Me]' Filter with a Promoted Property

solo42 — Tue, 26 Jun 2007 08:17:18 GMT

Great article, only that I still get  when trying to filter with [Me]. I have managed to get the user from SharePoint into my dropdown, and the AssignedTo column value in SharePoint is "Doe, John" just as I would like it. However, the ModifiedBy column for example also has the value "Doe, John", but here it is a clickable link whereas in the AssignedTo column it just seems to be text.

Also, it is possible to select only users from a certain group?

Regards, Helena

re: Use the SharePoint '[Me]' Filter with a Promoted Property

sirwally — Thu, 14 Jun 2007 00:20:41 GMT

Martin,

I have found that a good solution to this problem is to create a Filter Web Part. I recently created one that returns the NT username of the current user. MOSS actually provides this out of the box, but WSS does not. Once the the web part is installed, you can add it to a page and then connect it to other web parts on the page that you wish the filter. One caveat to this method is that the filter is always active.

I'd share my code if I could (it was developed for a client), but it was really easy to develop. See the following links to step-by-step instructions:

Writing a Filter Provider Web Part for Windows SharePoint Services 3.0

http://msdn2.microsoft.com/en-us/library/bb457205.aspx

Deploying and Optimizing a SharePoint Web Part That Calls Excel Web Services

http://msdn2.microsoft.com/en-us/library/aa973805.aspx

Hope that helps,

Simon.