Skip to main content

Hi all,


 


What I am trying to achieve is to set a variable "Weekday to simulate" with the weekday (1-7) of a date.


As Nintex Workflow is unable to do it, I want mitigate this with a Sharepoint list called "Helper Retrieve Wordkday" (sorry for the typo... :-))


 


So what the workflow does: Create an entry into this helper list with the date. A formula then populates the calculated column called weekday.


9315i40D0FF59587EEAFF.png


 


 


Then, I query the helper list. But somehow the variable I chose to be filled with the weekday does not get saved (tried both Integer or String), it keeps empty (or the default value). 


9316i752B871BA52EA6D1.png


 


If I hit "Run" in Nintex Workflow however, the thing seems to work. Any idea?


9317i5A0A558EF4699118.png


 


 

Hi,

I tested this functionality and it was behaving as expected.
When I created the Calculated Column in SharePoint I set the data type returned as Number. I then used a Number variable in the Query List action and it returned correctly. I also directly set the variable using a set variable action and that also worked.

Reply