?
Solved

Sharepoint 2013 Workflow using SPD

Posted on 2013-05-15
1
Medium Priority
?
719 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
[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
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

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

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

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…
Microsoft SharePoint Foundation 2010 and Microsoft SharePoint Server 2010 do not offer the option to configure the location of the SharePoint diagnostic trace log files during installation.  This can, however, be configured through Central Administr…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

801 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