Skip to main content
Nintex Community Menu Bar
Solved

How to get SharePoint list columns in variable in NAC when dropdown item is selected

  • August 5, 2024
  • 2 replies
  • 33 views
  • Translate

Forum|alt.badge.img+1

Hi 

I am new to NAC. Currently we are working on a form, where a dropdown list is populated from SharePoint list. Activity category is connected to SharePoint connection CoCurricularActivity Categories.

I want to get Cocurricular Activity list-Final Authoriser column value and save into a variable, so that i can use in my workflow.


Please advise me how to achieve that.

Regards

Syeda

Best answer by Deon

Hello @shapna74 ,

One way would be to use the Title from the SP List as the Option Label and use the Item ID as the Option Value.

The Option Value is what gets passed to the workflow.

Then you can use the SharePoint Get Item Action to get details from any of the other columns.

I would also recommend that you use the new Choice single control as opposed to the older Data lookup control:

Step 1: Add a Data Source Variable to your form:

 

Step 2: Add a Choice Single Control and bind the Options to the DSV created above:

Step 3: Create an Integer Form Variable (The Drop-down is a text variable):

 

Step 4: Get the SP Item Details in the Workflow:

 

View original
Did this topic help you find an answer to your question?

2 replies

Deon
Forum|alt.badge.img+10
  • Rookie
  • 125 replies
  • Answer
  • August 5, 2024

Hello @shapna74 ,

One way would be to use the Title from the SP List as the Option Label and use the Item ID as the Option Value.

The Option Value is what gets passed to the workflow.

Then you can use the SharePoint Get Item Action to get details from any of the other columns.

I would also recommend that you use the new Choice single control as opposed to the older Data lookup control:

Step 1: Add a Data Source Variable to your form:

 

Step 2: Add a Choice Single Control and bind the Options to the DSV created above:

Step 3: Create an Integer Form Variable (The Drop-down is a text variable):

 

Step 4: Get the SP Item Details in the Workflow:

 

Translate

Forum|alt.badge.img+1
  • Author
  • Novice
  • 2 replies
  • August 5, 2024

@Deon  Thank you so much! 

Translate

Reply


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