5

I am trying to change the body of the email which is generated by a custom SP2010 workflow. I'm using SPD2013 and I am able to get as far as the String Builder which contains the body text of the email. I've tried using %CurrentItem:ID% as well as %CurrentList:ID%. They both return a number, but unfortunately this number does not match the item ID number in the actual list. Not sure where this number is coming from...all I can think is I'm not referencing the correct source and/or field.

Any help is much appreciated...I'm new to SPDspd

EDIT:

Alright, so I've set the dropdowns accordingly (see above), but I still get a different number. I've also added screenshots of that, so you can see. Thanks for your help!

Email: enter image description here

SharePoint List:enter image description here

EDIT 2: Found the list which is bringing in the wrong ID number. Now I just need to figure out how to reference the correct list...since the workflow's associated list is not the list I want to reference.

Improve this question

1 Answer 1

Reset to default
1

The screenshot you attached is essentially saying in pseudo-SQL for better understanding:

SELECT ListItemID from CurrentList where (ListItemID = CurrentItemID)

In other words, you are just getting the current Item's ID. If the source list is different, select it in the first drop-down menu, otherwise the last drop-down value is wrong "Current Item:ID", which means you are running this workflow from outside of the list that you want to retrieve items from.

If you are running the workflow against the same list that you want to change items in, all you need to do is just use the "Update Item" action in SPD to change the value of the current item to whatever you want the body to say.

Otherwise if it's another item in the same list, you need to find that item using the method that you attached. Will the listitem always be the same? If not, how is the workflow supposed to know which item to find? You need to have some way to tie the workflow back to the listitem that you are trying to find.

EDIT:

So you are saying retrieve:

ID from Master Data Change Request List

but the next section you have to fill out is the where clause so to speak. Leaving it like this in theory will retrieve every ID of every list item.

What you are looking for is:

Find the List Item:

Field: ID

Value: CurrentItem:ID

So essentially you are saying where ListItemID = CurrentItemID (ListItem of the Master Data Change Request List)

Does that make sense?

Improve this answer
6
  • Alright, thanks. I get most of that. The list item I'm trying get the ID from is being generated through an InfoPath form. So the user fills out the form, clicks submit, and the form is converted into a list item. When I'm looking at the list, I see a column with "ID" heading. That is what I'm trying to get to. I believe the CurrentItem is the correct data source, because as you can see in the String Builder dialog, it is being used there successfully. Commented Dec 11, 2014 at 19:37
  • Updated the screenshot. So after I pick the list "Master Data Change Request List", then I set the field to "ID". What would I fill in for the bottom "Field" and "Value"? I assume it will be "ID" but then not sure what to do with the Value field. Commented Dec 11, 2014 at 19:47
  • See my edit @gerrits Commented Dec 11, 2014 at 20:21
  • Got it thanks. See my edit. Hope I understood correctly Commented Dec 11, 2014 at 21:12
  • What list is the Workflow running under? Commented Dec 11, 2014 at 21:45

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.