?
Solved

SharePoint 2013 Custom Workflow Attendee and Email Issue

Posted on 2014-10-21
4
Medium Priority
?
648 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

This article explains how to install and use the NTBackup utility that comes with Windows Server.
In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
Via a live example, show how to shrink a transaction log file down to a reasonable size.
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. Theā€¦

777 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