Skip to main content

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

198926_pastedImage_3.png

 

Query List

198910_pastedImage_2.png

Set Field In Current Item

198927_pastedImage_4.png

Thank you for any insight to my problem

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


That fixed my issue. Thank you very much for the quick response


Reply