Solved

Sharepoint 2013 Workflow using SPD

Posted on 2013-05-15
1
676 Views
Last Modified: 2013-05-16
Hi,

I have a Sharepoint List that contains seed calendar entries as follows:

Course Name
Date and Time
Lecturer
Room
Adult Participant Count
Child Participant Count

I was hoping the use the above seed calendar entries to populate a perpetual diary of weekly courses through an SPD Workflow, but only up to four weeks in advance.

So far, I have an SPD workflow running in a perpetual loop, and I thought I would be able to use the following approach to achieve my aims, but I cannot see a way of using the Weekday function to wrap around the [Today] value.

Pseudo-code a follows:

IF WEEKDAY(Course Date0 = WEEKDAY([Today])
 - Add 28 days to today's date and create a new list item
END
PAUSE for 1 DAY

The adding to a list bit is simple enough and so is the pause, but I cannot seem to be able to get the IF bit working. Any ideas?

Surely SPD can't be as basic as not allow simple functions to be used in loop conditions. I am new to SPD to perhaps I am missing some obvious user-interface bit.

A couple of colleagues have suggested calculated columns but they don't like the [Today] function as they need to store static as opposed to dynamic values.
0
Comment
Question by:e-matters
1 Comment
 

Accepted Solution

by:
e-matters earned 0 total points
ID: 39170590
UPDATE: I've got a workaround for the issue above as follows:

Find days between Course Date and Today
Calculate mvDaysBetween mod 7 to myTempInt
If mvTempInt < 1
 - do stuff

It works but surely there is a better way.

I would also have expected the number of days to be returned as an integer but that's probably asking too much!
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

When installing SharePoint 2010 RTM I came across a strange error, I was getting timeouts during the installation. I searched the web and found the best solution to be found here (http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010genera…
Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

743 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

15 Experts available now in Live!

Get 1:1 Help Now