Contents
Simply add at person group field and add Jane Doe to Accounting, add John Doe to HR and so forth. (If needed you can turn on content types to let the field be hidden for the users). In the workflow I’ll set a variable “EmailReceiver” to the receiver field in the department list.
How to use a lookup column in a workflow?
Workflow condition using a lookup column 1 1.User creates a new Item and in the dropdown (lookup column) for Department selects “accounting” 2 2.The workflow sees that “Department” is equal to “accounting” and it emails Jane Doe More
How to change email address in workflow SharePoint?
When the recipients for any workflow message change, all you have to do is change the addresses in the appropriate field in the Recipients list item for that workflow. Important: The columns in which you store addresses for workflow emails can be either Single line of text, Multiple lines of text, or Person or Group type columns.
What are the fields for email in SharePoint?
The available fields for an email are To, CC, Subject, and Body. These fields can contain both static text and text that is generated dynamically from workflow lookups.
How to set value in lookup field in workflow?
Then you can use SharePoint designer to apply that ID to a different column using a lookup, but the lookup has be ID based. The Lookup by ID can return the other fields you actually want! Thanks for contributing an answer to SharePoint Stack Exchange! Please be sure to answer the question. Provide details and share your research! But avoid …
I apply it when an item is added in SharePoint Designer. Then you can use SharePoint designer to apply that ID to a different column using a lookup, but the lookup has be ID based. The Lookup by ID can return the other fields you actually want! Thanks for contributing an answer to SharePoint Stack Exchange!
How to send email in a workflow in SharePoint?
More… Sending an email when a list item was added in some versions of SharePoint requires many steps, whose details follow. However, if you are using the most current version of SharePoint, you can add a flow directly from your list.
How to fix custom list form in SharePoint?
Open the DispForm.aspx in SharePoint Designer. Next, hide the default display web part. Next, go to Insert > SharePoint > Custom List Form and choose the same list and item display form type. The lookup field will get screwed up as described in the question and the lookup additional field will be missing and so on.
How to see project ID in task list?
In the Tasks list, I have created a lookup field titled ProjectID which targets ID filed from the Projects list. Also, I have set for this field to display an additional field ProjectID: Title. So, when I view the tasks I see the values for the particular project ID and Title.