Skip to main content
Nintex Community Menu Bar

Cannot save result of Calculated Column into a Variable

  • 23 October 2020
  • 1 reply
  • 19 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

SimonMuntz
Nintex Employee
Forum|alt.badge.img+22
  • Nintex Employee
  • 2368 replies
  • 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.

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings