Cannot save result of Calculated Column into a Variable

  • 23 October 2020
  • 1 reply
  • 14 views

Badge +1

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

 

 


1 reply

Userlevel 6
Badge +22
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