Fusion supports reading and updating Lookup columns.

Updating Lookup columns
The Item Label value can be assigned to the column directly. I will trigger a lookup in the linked List to retrieve the physical ID that in turn is applied to the column.
A report is stored in the Job log if one or more values does not exist in the linked List.
The physical ID can also be assigned directly.

Multiple values are separated by ;# or ;

Reading data from a Lookup column and associated display columns
The lookup column and all display columns from the linked list can be selected.

The output format for the lookup column is specified to include Item ID and/or value.

Need more help with this?
Don’t hesitate to contact us here.

Thanks for your feedback.