A: Select the List_Courses here

B: Select Inform Date (it’s the field you want to extract)

C: Coursename

D: Value/waarde

E: Course (use the button with the green arrow to the right of the box, you can put in a reference there, you can reference the Course field on the own item under item properties)

Bob,

Thank you for your reply, I really appreciate it!

After using your proposed settings I tested the list workflow. Somehow the Pause is not working. After the pause for duration I made a workflow notification. It should be send after the Inform_date is reached but it’s send within 10 minutes after the student signed up for a course.

​@BobR, do you have an idea what could this situation that the Pause for duration is skipped and that the notification is send within 10 minutes? The Inform_date from the test was on 10th of december 2024. 

I can’t judge that from this side, you’ll need to do some bugfixing on your side. The workflow history should always detail until when it is pausing when encountering a pause action. Check the workflow history and see what parameter the action returns as the time to pause until.

Hi ​@Mr_Blue_81 
Has this question been resolved or do you need more assistance? 

It is not resolved yet. I am having trouble to find the workflow history. Somehow it isn’t visible/available in the enviroment that we use in our company or I am looking at the wrong place. :-)

​@BobR could you please try and assist?

You can find the workflow history by rightclicking the item in the list and selecting it from the item menu. You can also right-click the item to open it and then select workflow history from the top ribbon bar.

This topic can be closed. I made another approach which gave the result I was looking for.

I made a site workflow instead of a list workflow. It runs once each day.

In the site workflow all the e-mail adresses of students who are not informed yet (yes/no column in list) are selected through a query and saved in a collection variable. After that I made a ¨for each" repeating action.

For each e-mail address there is a query which selects the other information including the start date of the course. Then a date is calculated to do start_date_course minus 14 days. This new date is saved in a variable.

Follow by a ¨Run if" action. When the start_date_minus 14 days is less then the current date, the student will be informed about the start of the course and status of being informed changes to "Yes"

Summary:

1. Query list action (e-mail addresses stored collection variable)
2. For each action (to repeat the following steps to each of the gathered email addresses)
3. Query list action (gather other item information of the selected email adress)
4. Calculated date action (startdate -14 days stored in variable)
5. Run if action (if current date is bigger then saved caculated date in variable)
6. Message action (inform student)
7. Change item action (state of being informed changes to Yes)