Skip to main content

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

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:

 


@Deon  Thank you so much! 


Reply