Hi Team,
Please help me. How to Configure/Develop a nintex workflow for birth date notifications in SharePoint list!.
Advance Thanks
Hi Team,
Please help me. How to Configure/Develop a nintex workflow for birth date notifications in SharePoint list!.
Advance Thanks
If you already have a list of people with birthdays, then you're ahead of the game! You can create a site workflow that sets a date variable for "todaysDate" and then query your list and get the items where birthday == todaysDate. From there, you can send the email to the person whose birthday it is or their manager or the company or whomever!
Hi Vargo,
Thanks for your reply and how this workflow will run automatically everyday.
Thanks in Advance
you will have to schedule it.
Are you in Office 365 or SharePoint 2013/2016? This will determine the best way for you to schedule it.
Hi Courtey Vargo,
i am using SharePoint 2013. please let me know schedule will works!
Thanks
Check out this link: Scheduling a workflow
Thank you very much
Configured the workflow as you said but I am not getting the value on today date. please find the screen shot
Please let me I am missing any thing
Thanks in Advance
when I click to run now not getting the values on today date items
Please let me I am missing any thing
Thanks in Advance
Hello srinivas sri, the "todayDate," is that a workflow variable or a list column? Your workflow should be:
Create Workflow Variable of type Date
Set that workflow Variable (we can call it todaysDateVar) to "date action was executed" (this will set it to right now today)
Make sure time isn't included!
Now, run your query and look for BirthDate == todaysDateVar
The field that you want to output is probably BirthDate and User (so you know whose birthday that is!)
Then use the ForEach loop to send an email to each person wishing them a happy birthday!
Hi Vargo,
I have developed workflow as follows but it first time showing error and second time its running the workflow.
please suggest if am missing something
Thanks & Regards,
Can you show me the actual action configurations? Also, what type of error(s) are you getting?
Thank for reply please find the configurations as follows
Query
foreach
condition in loop
Error is workflow error
this workflow is configured as site workflow as auto schedule but while running 1st time its showing error and 2nd time its running fine
I hope I have given clear details about the issue.
Thanks
And also please help me how to insert the background image for the notifications.
Thanks
and also in the Query how to get the list on MM/DD wise am not getting the result and please find the query
<Query>
<Lists>
<List ID="{000000}" />
</Lists>
<ViewFields>
<FieldRef Name="BirthDate" />
<FieldRef Name="EName" />
</ViewFields>
<Where>
<Eq>
<FieldRef Name="BirthDate" />
<Value Type="DateTime">
<Today/>
</Value>
</Eq>
</Where>
<OrderBy>
<FieldRef Name="BirthDate" Ascending="true" />
</OrderBy>
<ViewAttributes Scope="Recursive" />
</Query>
please help me
Hello Srinivas,
I typically use the GUI for the query construction, not the CAML editor. When using that editor I would query list "Birthday" and filter for where "BirthDate" == Today (in 365, I make a variable for todays date, you may not need to as I'm not familiar with On Premises). I normally output the ID of the matching items to the collection variable, then for each, send email to person in birthday list where ID == ID.
Check out this post: For some screenshots and further explanation
Hi Courtney Vargo , I am using GUI as follows but not getting the list MM/DD wise getting dynamic result only
can you post
- example how BirthDate field is populate in list
- exact error you get
- output of Run Now
- output of Run Now with CAML with no where expression
Hi Marian Hatala,
Thanks for your response, what I am doing is in the list 'Bday' column and creating variable 'today assigning today date
but while query on the list I need to get the data on month and day only but I am not getting the data.
Please let me know how to do it.
Thanks in advance
I'd still need more info on 'Bday' field.
Is it date column? Is it just date or date+time?
or is it some text column?
yes Bday is Date Field only
Thanks
CAML has no direct possibilities to query for dates based just on month and day.
I would suggest following approach
- create calculated list field that pick day and month from birthday date and presents them as a string value eg. like MMDD
- in workflow create a variable that do the same for today's date
- make a query against that calculated field by a value of workflow variable
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.