Skip to main content
Nintex Community Menu Bar

Cannot save result of Calculated Column into a Variable

  • October 23, 2020
  • 1 reply
  • 22 views

Forum|alt.badge.img+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

Simon Muntz
Nintex Partner
Forum|alt.badge.img+23
  • Nintex Partner
  • October 26, 2020
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.