Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [workflow-lookup]

Question related to Workflow Lookups

0
votes
0answers
23 views

Workflow If/Then: When Child (Count Related) List lookup field equals zero in Parent List Workflow. Error

I've got two lists; List 1 = Parent & List 2 = Child. The relationship between the two is one (Parent) to many (Child). The Child list has a lookup field to the Parent ID and the Parent list has ...
0
votes
0answers
91 views

Filtering view and workflows for lookup columns

I have 2 lists with the following columns: List A - "Status" (choice column)/"Name"(Single line)/"ReqNr(Number)" List B - "StatusNameReq"(Lookupcolumn based on the columns in List A) Now, I want to ...
1
vote
1answer
30 views

Workflow with sending email based on lookup

I have created a list with two lookup columns. Those columns are filled with an email address. Besides I have created a workflow to make an email sent if the list is saved, however now email is sent. ...
1
vote
2answers
122 views

how to lookup multiple items from one list to another and the connect results into a string

I have list "A" in which i store name, email and product. I have a list "B" which should trigger an email based on some values. One of these values is product. If I chose "car", the workflow should ...
0
votes
1answer
146 views

HELP with workflow error: Coercion Failed: Unable to transform the input lookup data into the requested type

From reading other posts I know this error is related to null or blank values in the lookup but I don't have that problem. I have a list of about 10 items in a list called "Service Types" with an "...
2
votes
1answer
32 views

Workflow Lookup

I have a custom list which contains the following columns1. Name2. Team3. Active Directory Account (This is a person/group lookup)I am now creating another list which will contain a workflow that will ...
0
votes
1answer
149 views

SharePoint Designer Workflow Field Lookup Not Displaying

I have a SharePoint list called Item Orders. The "Item Name" field is a lookup from a field of the same name on the list Item Definitions. The field "Item Type" from Item Definitions is also displayed ...
0
votes
1answer
305 views

SharePoint designer - User lookup from another list with multiple conditions

Background I have two lists: Approval list: There is three column with approver 1, 2 and 3 and the country User list: A list with the title of the user (Approver x), his email and his country. For ...
1
vote
0answers
84 views

Sharepoint Designer Email Lookup Semicolon Delimited not available

I have following situation: I have a Custom List with Attendees with two columns: User (which gets automatically filled with a user) and MeetingID (also autofilled) Now I have a Discussion board ...
1
vote
1answer
152 views

SharePoint Designer: Email Workflow based on names in lookup columns

I am trying to create a workflow in SharePoint Designer where in List A it will email the people in Columns: OCR PM, BSC, Pri DBA, Sec DBA, and Tech Mgr only if someone updates/appends changes in the ...
0
votes
1answer
22 views

How can i compare two different columns from different document libraries?

I got two list called List A , List B. List A has got columns called "Number" And "Title".. List B will reach the "Number" and compare , if it is the same number will show List A 's "Title". List A ...
2
votes
1answer
54 views

Workflow - Lookup of Task Name returns a Single Value

I have a Task List with columns Task Name and Due Date. I have created a workflow that if due date=today then send an email. The email is sent every morning to remind people of the tasks due. What ...
1
vote
1answer
57 views

warning while defining lookup to get single value from a list in workflow

While assigning value from another list to workflow variable with filter I get an error saying "The lookup that you defined is not guaranteed to return a single value. If more than one value is ...
0
votes
1answer
46 views

Email custom column field person

I created a custom field in my documents folder, which is a person. I have names this new column authors. I want to create a workflow that emails the person I have imported into this field. When I do ...
0
votes
1answer
33 views

Problem with less than symbol and set variable lookup

Can some one confirm this is an issue? Take a list and put a record in it with 2 records the data: A< A<B Create a workflow that: Uses Set Variable action. Set a string variable to the ...
2
votes
1answer
651 views

Can i have a reusable workflow to look up information from a top site level list, and use that workflow across subsites

Hi and thanks for reading. I have an imported list at the top site level, "Staff Info". I'm having trouble creating a reusable workflow that I can use in subsites, (Document Center & Team sites) ...
0
votes
0answers
18 views

Workflow job of pasting a URL in a hyperlink field, how to have the name/description appear instead of long url? [duplicate]

Follow up to my previous Workflow thread that now works. When the workflow 'updates the item in current item' and pastes the url correctly (long, complete url) I would like to have the 'description' ...
3
votes
1answer
102 views

6;# appended to the front of values via lookup fields

I have a list with a name, email field, and position field. The odd thing is when I call the value of the lookup in a workflow email, a 6;# is appended to the front of all three fields. There are no ...
1
vote
0answers
22 views

Is that posible to select spefic wiki page from wiki library through a workflow

I am trying to select a specific wiki page from wiki library through a workflow. Then by the condition on its approval status want to update another specific item in another list. For Example, There ...
1
vote
0answers
1k views

Retrieve Person Field's Email Address in Workflow

I am having trouble getting a Person's email address from a Person or Group column (named SharePointUser). The Person's email address is visible to me in the list itself, however, in the workflow all ...
0
votes
0answers
250 views

Workflow - Copy lookup field to another field without getting the lookup id infront

I've got a workflow that I want to combine a lookup field and a regular field into another field. This because both list can contain the same company and I want to group the list based on company name....
2
votes
0answers
239 views

SharePoint Designer Workflow create new item with lookup to current item

I have two lists, "customers" and "expense Sheets". The list "expense sheets" has a lookup column "related customer" to the "title" field of the "customer" list. I am trying to create a workflow for ...
0
votes
1answer
142 views

Two layer approval workflow

I come from a development background and have only been using SharePoint for a year, and i am need of some help, I have been dealing with a customer using SharePoint 2013 who have a specific ...
1
vote
2answers
2k views

Get latest ItemID from list with workflow

how can I get the latest ItemID from a list with a Sharepoint workflow? Like these SQL Statement: SELECT MAX(id) FROM list WHERE title = "example1" Is there any solution? Thanks!
2
votes
1answer
2k views

If [LookUp] equals [String] doesn't always work. Sometimes I have to use [1;#String] instead, why?

I am using SharePoint Designer 2010. I created a workflow in which I needed to test the value of a lookup column. I (perhaps naively) simply tested if the lookup column equals the literal string I ...
4
votes
1answer
780 views

How to query person column based on a person column from another list in Workflow?

I have issues retrieving a person stored in one column based on the value (person) in another by workflow (SPD2010) The real scenario looks like this: In the first list we store name of the team ...
0
votes
2answers
600 views

How to append to Event Attendee list using workflow

On a Sharepoint 2010 workflow, on List B, I want to look up the Attendees on a particular event in List A, append that list of users with the user who Created the list item in List B (CurrentItem:...
2
votes
1answer
2k views

Workflow error: The value 'Value' cannot be read as type 'Int32'

I've a list named APE - Opções with this values: Título | Nota Nunca | 1 Algumas vezes | 2 Frequente | 3 Sempre | 4 N/A | 0 And a list ...
0
votes
1answer
36 views

Send value of a field created in a workflow as an email

I have a workflow which collects user input in regard to a hyperlink field. A second workflow then takes the value in this hyperlink field and copies it into the original list. Is it possible to send ...
2
votes
0answers
140 views

Multiple Criteria Lookup in Parent List

I have a list of projects (Project List) and another list of periodic status updates (Status Update List) related to each project (one-to-many). I need a lookup column in the Project List that ...
1
vote
1answer
48 views

How to recognize which button was pressed in workflow task outcome

I am creating a workflow, and I have a modified task outcome with custom buttons. It looks like this: When the user presses "Extension Approved" I want the loop in my workflow to continue running, ...