{"id":70,"date":"2010-10-27T17:59:37","date_gmt":"2010-10-27T23:59:37","guid":{"rendered":"http:\/\/localhost\/todd_wp\/spd-2010-collect-data-from-user-activity-missing-column\/"},"modified":"2013-07-01T10:54:09","modified_gmt":"2013-07-01T16:54:09","slug":"spd-2010-collect-data-from-user-activity-missing-column","status":"publish","type":"post","link":"https:\/\/toddbaginski.com\/blog\/spd-2010-collect-data-from-user-activity-missing-column\/","title":{"rendered":"SPD 2010 – Collect Data From User Activity – Missing Column"},"content":{"rendered":"

When you use the Collect Data From User Activity in SharePoint Designer 2010 you can define a column to add to the Tasks list (or another list if you associate your workflow with a different list to hold workflow tasks).\u00a0 This column which you define is used to store the data from the user.\u00a0 <\/p>\n

This procedure isn\u2019t anything new, but this weird behavior I encountered today might be.\u00a0 After you define the new column to store the data you collect from a user you may find it does not appear in the SPD workflow designer when you try to look up the value later in your workflow.<\/strong><\/p>\n

Here\u2019s what I encountered.\u00a0 In this example I am using a Collect Data From User Activity to ask the user if an RFP Response has been completely filled out.\u00a0 I added a Collect Data From User Activity to my workflow and configured it to collect the following field of data from the user.<\/p>\n

\u00a0\"image\"<\/a><\/p>\n

I allow the user to select Yes, or No.<\/p>\n

\"image\"<\/a><\/p>\n

Then, I store the ID for the list item associated with the user\u2019s response in a workflow variable.<\/p>\n

\"image\"<\/a><\/p>\n

It looks like this in SPD after everything is configured.<\/p>\n

\"image\"<\/a><\/p>\n

Next, when I tried to set a workflow variable equal to the value the user entered, I did not see the RFP Response Complete Status column<\/strong> (the one I defined above) in the Field from source dropdown (highlighted below).<\/p>\n

\"image\"<\/a><\/p>\n

I double checked the list inside the web browser and saw SPD created the column when I published the workflow and I could not figure out why it would not show up in the dropdown list.\u00a0 Eventually, simply closing SPD, opening it, and editing the same workflow did the trick.\u00a0 The value appeared in the dropdown list and I was able to complete authoring my workflow.<\/p>\n

\"image\"<\/a><\/p>\n

As you can see, I logged the value to the workflow history list to take a peek at the variable value, and eventually used it in a Compare Data Source condition.<\/p>\n

\"image\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

When you use the Collect Data From User Activity in SharePoint Designer 2010 you can define a column to add to the Tasks list (or another [\u2026]<\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[98],"tags":[10,7,26,11,9],"class_list":["post-70","post","type-post","status-publish","format-standard","hentry","category-sharepoint-2010","tag-custom-development","tag-sharepoint","tag-sharepoint-2010","tag-sharepoint-designer","tag-workflow"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/toddbaginski.com\/blog\/wp-json\/wp\/v2\/posts\/70","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/toddbaginski.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/toddbaginski.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/toddbaginski.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/toddbaginski.com\/blog\/wp-json\/wp\/v2\/comments?post=70"}],"version-history":[{"count":1,"href":"https:\/\/toddbaginski.com\/blog\/wp-json\/wp\/v2\/posts\/70\/revisions"}],"predecessor-version":[{"id":800,"href":"https:\/\/toddbaginski.com\/blog\/wp-json\/wp\/v2\/posts\/70\/revisions\/800"}],"wp:attachment":[{"href":"https:\/\/toddbaginski.com\/blog\/wp-json\/wp\/v2\/media?parent=70"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/toddbaginski.com\/blog\/wp-json\/wp\/v2\/categories?post=70"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/toddbaginski.com\/blog\/wp-json\/wp\/v2\/tags?post=70"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}