Hello! :)
I have previously just been reading this forum, and not posted anything. So, here comes my first message. I am not fluent with Nintex yet, and I am not a developer.
Problem:
I have a Sharepoint list that looks like this (but has much much more columns and rows):
List A
|
xx
|
987
|
345
|
678
|
234
|
567
|
543
|
|
8000
|
1
|
1
|
1
|
1
|
2
|
2
|
|
6790
|
2
|
5
|
4
|
4
|
4
|
3
|
|
2134
|
3
|
1
|
6
|
5
|
4
|
3
|
|
6789
|
6
|
3
|
1
|
2
|
3
|
7
|
It's kind of a matrix type of table, exported from Excel spreadsheet to Sharepoint.
Then I also have another Sharepoint list that looks like this:
List B
|
Name
|
Category
|
Type
|
Team
|
|
test1
|
8000
|
987
|
|
|
test2
|
6790
|
345
|
|
|
test3
|
6789
|
234
|
|
|
test4
|
2134
|
567
|
|
---
OK, so my problem is that I need to get the values for the Team column in list B, based on the Category and Type column values. I need to look up those values from list B, and update the Team column accordingly.
Question is: How can I do it?
I have tried adding a Switch action so that it looks at the Type field. I selected the workflow variable (Type) that I wanted to compare the value of. I then added conditions: 987, 234, 567... etc. etc.
But the problem is, there will be approximately a hundread "branches", which makes the workflow appear very very wide. Can that be a problem somehow, or is Nintex able to handle that? It kind of looks ugly..
For each "branch" I then tried to add the Query List action, to look up the value for Team from the list A...
I just don't know how to configure the Query List actions. :-(
How do I get the values..? What would be the best way to do this?
So, in the end the values for the Team column would be updated according to the matrix:
|
Name
|
Category
|
Type
|
Team
|
|
test1
|
8000
|
987
|
1
|
|
test2
|
6790
|
345
|
5
|
|
test3
|
6789
|
234
|
2
|
|
test4
|
2134
|
567
|
4
|
If anyone has any advice, please let me know. :-)
Thank you!