Solved

Sharepoint 2013 Workflow using SPD

Posted on 2013-05-15
1
687 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Last week I faced a strange issue recently, i have deployed SharePoint 2003 servers for one project and one of the requirements was to open SharePoint site from same server. when i was trying to open site from the same server i was getting authentic…
For SharePoint sites, particularly public-facing ones, there are times when adding JavaScript, Meta Tags, CSS Styles or other content to the page <head> section is more practical than modifying master pages.  For instance, you could add the jQuery l…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

863 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

27 Experts available now in Live!

Get 1:1 Help Now