Solved

SharePoint 2013 Custom Workflow Attendee and Email Issue

Posted on 2014-10-21
4
606 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…

749 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