AnsweredAssumed Answered

How to Use a Column Name as Variable in a Workflow

Question asked by koolgeex on Nov 2, 2015
Latest reply on Nov 20, 2015 by waltont

I don't know if this is possible so please let me know. Here's what i'm trying to accomplish.

 

I have two lists within the same site - List A & List B.

 

List A contains three columns: Name, Week, Information.

List B contains four columns: Name, Week 11/5/15, Week 11/16/15, Received

 

A user will come into List A, give their name, select the week (ex. 11/5/15) from a pre-populated drop down menu, and save.

 

A workflow should then run that does the following:

  1. Find the user's name in List B (a row)
  2. Find the appropriate column date (that matches what the user selected in List A)
  3. Change the value for that row/column intersection to "Received"

 

Basically if someone submits something in List A, I want to mark them as being compliant in List B.

 

I understand how to use a collection variable to sort through IDs and assign variables to test BUT i'm wondering how i can get the workflow to recognize what column it should update.

 

If my users "Week" is stored in the variable weekOf, i need to be able to see which column name it matches.

 

Is this possible? Is there a way to dynamically pull the column titles of a list and use it in a workflow?

Outcomes