Update Item based on \people or group\"


Badge +6

Hi All,

I have a Site WF with an update item action and I want to update a field where the "people and group" column equals a variable that contains also a "people and group" type value. The problem is the WF always run to an error at this point as it cant match the 2 values even if they are the same data type. 

 I have logged the 2 value to the wf history and it seems to be the same so the system should match them.

Example:

OHR=     i:0#.w|ad123040387

KJOHR= i:0#.w|ad123040387

Any idea?


13 replies

Badge +16

try using a single line of text for your variable and update your person field with that

Badge +6

Originally it was a single line of text type variable with the same error so I converted it to a people or group type.

Badge +6

ui: I dont want to update the people and group field, I use it only to match the correct line in the list.

Badge +16

OK how is the variable populated?

Badge +6

I have set variable action where I assign to KJOHR (people and group type) a single line of text variable value varOHR.

Sorry we use Hungarian translation of Nintexhappy.png 

201159_pastedImage_1.png

Next step use KJOHR at Update Item action as "where" Résztvevő OHR = KJOHR set column value to "Mentve"

201160_pastedImage_5.png

The WF stops at this point so I guess it cant match the two values. As you can see in my first post they are identical for value and type as well.

Badge +8

Can you set the property of the People field to Name/email etc. using the below highlighted button and try?

201201_pastedImage_1.png

Badge +6

I tried a lot of option from there, but none of them works.

I fill like I am an expert in findig Nintex limitations and "bugs". happy.png

Badge +8

How is the value assigned to OHR? Hope there is no whitespace?

Badge +6

It is coming from a collection variable that is processed and every OHR saved as single line of thext (varOHR). First I thought the problem is that it have different type of data thats why it cannot match, but then I assigned it to a person or group variable (KJOHR) with the same result (error).

Badge +6

I was told by a developer that the database my add some more information to the people and group field in the list which I cant see and Nintex not showing. This way it cant match my variable, even if its the same people and group type value.

In my list I need to add one more column where I copy the IDnumber of the users in a single line of text field, than it will match. 

Badge +8

Did this work?

Badge +6

I didn't have time working on this since, but it will work for sure.

Userlevel 5
Badge +14

I don't think it's a matter of adding and hiding anything.

if you make a query to sharepoint list and want to filter by people and group field you have to do so by Sharepoint's user ID.

here is some example, even though not directly nintex one, but I believe it might give you a good hint Using CAML to compare SharePoint "Person or Group" fields - Stack Overflow 

so within nintex workflow, get SP's user ID (eg.) ith with set variable action and respective return type and then configure update item action to filter by that user ID.

Reply