Hi I am using SharePoint Online. I am trying to create a list item (list is called Tasks) in SPD workflow. I am trying to set a lookup column in the Tasks list using a calculated column (string value) from the current item. I understand that the lookup column in the Tasks list i am trying to create the item uses an ID and not the display string of the column but I am struggling to make this work.
I have created an Integer variable varName and set this to Current item:Name (the calculated string value column) As Integer.
I have set the field in Tasks List to Value = Variable: varName (As Integer)
I think i am missing some fundamental understanding on handling string & lookup columns in workflow.