Skip to main content
Nintex Community Menu Bar

Update Item based on \people or group\"

  • Mar 27, 2017 2:29 PM UTC
  • 13 replies
  • 40 views
  • Translate All

Forum|alt.badge.img+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

Forum|alt.badge.img+16

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

Translate

Forum|alt.badge.img+6
  • Author
  • Mar 27, 2017 2:41 PM UTC

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

Translate

Forum|alt.badge.img+6
  • Author
  • Mar 27, 2017 2:45 PM UTC

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

Translate

Forum|alt.badge.img+16

OK how is the variable populated?

Translate

Forum|alt.badge.img+6
  • Author
  • Mar 27, 2017 3:05 PM UTC

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.

Translate

Forum|alt.badge.img+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

Translate

Forum|alt.badge.img+6
  • Author
  • Mar 28, 2017 8:18 AM UTC

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

Translate

Forum|alt.badge.img+8

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

Translate

Forum|alt.badge.img+6
  • Author
  • Mar 28, 2017 10:31 AM UTC

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).

Translate

Forum|alt.badge.img+6
  • Author
  • Mar 28, 2017 1:42 PM UTC

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. 

Translate

Forum|alt.badge.img+8

Did this work?

Translate

Forum|alt.badge.img+6
  • Author
  • Apr 5, 2017 1:24 PM UTC

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

Translate

Forum|alt.badge.img+14
  • Scholar
  • Apr 5, 2017 11:15 PM UTC

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.

Translate