Solved

SharePoint 2013 Custom Workflow Attendee and Email Issue

Posted on 2014-10-21
4
627 Views
Last Modified: 2014-11-20
Kind of new to attempting any custom development in SharePoint.  Working with 2013 and have the 2013 Workflow Farm setup/working.  I am trying to have a calendar that users can register to appointments via custom list.  I have the list that pulls the title into its  own "Event" field as a lookup.  Also have a workflow on the calendar that adds the current user as an attendee and made that field "not required".  I'm trying to accomplish this:
1) Have the Custom List update the Calendar list attendee field with the username. Currently it wipes out what is there and replaces with the "Created By" name. Tried to set a variable that would put the current attendees in a string and just add the current user, then use that variable to update the attendee field.  No luck.  Ultimately if I can understand this enough and get fancy enough, I'd setup a workflow  that can have someone delete their own registration item in the custom list and remove only their own name from Attendees...
2)  Have a workflow kick off an email that sends the registrant the calendar details. Have tried to pipe in variables to get the ICS file (some variation of : this )  If I put the List ID in brackets I get an error about having that and variables in the same code for an email workflow.  In any event I can't really get the email workflow to give any kind of nice piped in values the best looked like this and had the wrong date: You registered for  {"results":[{"Id":22,"Value":"Test Event 8"}]} on 1/1/0001 12:00:00 AM
0
Comment
Question by:mcburn13
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 1

Accepted Solution

by:
mcburn13 earned 0 total points
ID: 40426311
As usual either it doesn't get resolved or I figure it out myself.  In this case I was able to get the workflows working correctly by using "Login Name, Semicolon Delimited" - this fixed the ability to create a variable and pipe existing attendees + current one by adding Workflow Context: Initiator to the end. Looked something like this:
[%Current Item:Attendees%];[Workflow Context:Initiator%]

Ended up doing this right in the calendar list- the only problem that remains is being able to hide the Edit button for registrants. They need Edit Access in able to update that Attendee Field in the workflow (even with the Workflow set to run as an app with elevated privileges in App Step). So created a copy of Contribute and removed "Add New Items and Delete"

So if someone was able to give me instructions on how to hide this Edit button for non-admin users on THIS list only please let me know. I've looked at a bunch of articles with JavaScript and CSS solutions that don't seem to work or apply to SharePoint 2013 Ent.
0
 
LVL 1

Author Closing Comment

by:mcburn13
ID: 40455134
Additionally, adding target audience functionality allowed restricting the "Edit" button on the EditForm.aspx for calendar
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A procedure for exporting installed hotfix details of remote computers using powershell
When using a search centre, I'm going to show you how to configure Sharepoint's search to only return results from the current site collection. Very useful when using Office 365 with multiple site collections.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…

690 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question