Solved

Connect a form variable to a column in "New Responsive" o365 designer

  • 31 January 2020
  • 1 reply
  • 130 views
ms7
Badge +4

In the New Responsive designer in o365 is it possible to connect a variable to a column? If not how can I write the output of a userProfileLookup, based on a people control on the form, to a column e.g.

 

The form has a control called:

 

[People Field 1]

 

User profile lookup gets the Department property of that people field:

 

userProfileLookup([Form].[People Field 1],"Department")

 

I want to write that value to a column and I can't appear to do that with a variable or a label.

 

icon

Best answer by ms7 31 January 2020, 18:52

View original

1 reply

ms7
Badge +4

Just seen Euan's video which deals with this. The short answer is I need to create a rule.


 



  • Create a variable called varUserDept as follows:


userProfileLookup([Form].[People Field 1],"Department")


  • I have a control on my form called UserDept

  • Then create a rule:


If [People Field 1] does not equal [blank]

Then [UserDept] value [varUserOffice]

Else [UserDept] value [blank]

 

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings