I'm doing a simply Query List to look up a value from List A, storing a value as a variable and then Set Field in Current Item to List B and I'm getting the following in my Change Request Field.
I just want to see 14-0001 in the Change Request Number field. I would like to know why I'm getting the variable information
Query List
Set Field In Current Item
Thank you for any insight to my problem
Best answer by TomaszPoszytek
Hi!
This is because you have chosen to output all values as a single output thus you had to use which stores information in a format you see.
To change into a text variable you must mark "separate output per column" and then store your value as a text.
Just one thing - do you have a "Filter Options" set in your query list action, so that only one row is returned?
Regards,
Tomasz
+17Hi!
This is because you have chosen to output all values as a single output thus you had to use which stores information in a format you see.
To change into a text variable you must mark "separate output per column" and then store your value as a text.
Just one thing - do you have a "Filter Options" set in your query list action, so that only one row is returned?
Regards,
Tomasz
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.