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:
- Find the user's name in List B (a row)
- Find the appropriate column date (that matches what the user selected in List A)
- 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?