[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Sharepoint 2013 Workflow using SPD

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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

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…
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…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
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…

649 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