Solved

SharePoint 2013 Custom Workflow Attendee and Email Issue

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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
A safe way to clean winsxs folder from your windows server 2008 R2 editions
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
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…

707 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now