cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
zwfsoftwarecons
Nintex Newbie

“Nintex O365 update item permission” action not working with multi-value people picker

Jump to solution

I need to set the permission on an item, when a multi-value people picker field is filled. The people definied here should receive “Edit”-permission on the current item.

Regardless of which Format (Display name, Email, String,…) is choosen, the workflow always run into an error:

"Der angegebene Benutzer {"__metadata":{"type":"Collection(Edm.Int32)"} wurde nicht gefunden"

Any help would be appreciated.

Reply
10 Replies
rickbakker
Nintex Newbie

Re: “Nintex O365 update item permission” action not working with multi-value people picker

Jump to solution

Hi Benjamin,

What you want is possible imo but not that straight forward as using that 'People or Group' field directly in the action.

What you must do is get the id from the users from the field. This are the ID's shown at the end of the string: {"__metadata":{"type":"Collection(Edm.Int32)"}... (you left that part away).

When you have the ID's, you must use, per ID, the 'Call HTTP Web Service' action with the address the REST interface: [WebUrl}/_api/Web/GetUserById($ID). $ID must be replaced with the correct value.

The response content contains the user account (LoginName) which can be subtracted with a bit of XML magic

Below is a part of the response content returned to me:

Now you have the accounts to use in the action 'Office 365 update item permissions'

Cheers and good luck!

Rick

Please mark this reply as a correct answer if it is a solution for your problem.

0 Kudos
Reply
Warwick
Nintex Newbie

Re: “Nintex O365 update item permission” action not working with multi-value people picker

Jump to solution

Works fine, you need to create a collection from the multi-person field and then a loop through that collection and set permissions for each person

0 Kudos
Reply
rickbakker
Nintex Newbie

Re: “Nintex O365 update item permission” action not working with multi-value people picker

Jump to solution

Hi Warwick,

This works for on-premise yes, but not for Office 365. Could you please make a workflow for it in Office 365, export it and add it to your comment so I can use it to verify your remark. That sounds indeed much easier if it works. Thanks!

Cheers,

Rick

Reply
Warwick
Nintex Newbie

Re: “Nintex O365 update item permission” action not working with multi-value people picker

Jump to solution

hmmm.. looking into this I am now very confused.

The above images are of Office 365, I'm picking up a multi person field and added them to the SharePoint Group on a site - and it works

But looking into it I have no idea how, I tried to implement the same solution using the Update Item Permissions action and it didn't work. It looks like the look is actually doing nothing as it can't find any ; any ways.

0 Kudos
Reply
eiben
Nintex Newbie

Re: “Nintex O365 update item permission” action not working with multi-value people picker

Jump to solution

Hi Beni,

well, the multi-value field is being represented as a JSON disctionary in the workflow, which looks like this:

{"__metadata":{"type":"Collection(Edm.Int32)"},"results":[11,13]}

In order to assign each person permissions, you first have to extract the peoples and then loop over the list like Warwick Ward​ already showed. So my workflow looks like this:

At first I write the value of the multi-value-person-field into a dictionary called "varDictPersons".

Remember the JSON array above? So next we need the results, which is actually another array. So we want to store the results in a collection, in order to loop over them.

Now that we have a collection, we can just simply iterate over the items and assign them to a variable "varCurrentPerson".

It might be worth mentioning, that "varCurrentPerson" is of type "Person". This way you'll get a valid sharepoint user object, without needing to explicit call any web-service which would turn the user-id into an user-object.

Finally you can assign permissions to this user!

Voila!

Reply
rickbakker
Nintex Newbie

Re: “Nintex O365 update item permission” action not working with multi-value people picker

Jump to solution

Hi Henning Eiben​,

I just checked your solution and it works great. It is much less complex than the solution I mentioned.

Cheers,

Rick

Reply
Warwick
Nintex Newbie

Re: “Nintex O365 update item permission” action not working with multi-value people picker

Jump to solution

Nice!

0 Kudos
Reply
zwfsoftwarecons
Nintex Newbie

Re: “Nintex O365 update item permission” action not working with multi-value people picker

Jump to solution

Hi Henning,

great! That's the solution. Many thanks :-)

But there is one question left:

How can I update only the current item. Within the "Items to update" section?

I always get an error similar like this one:

"Filter rule error, column '4' does not exist. It may have been deleted by another user"

I tried

- Current Item: ID = Current Item: ID

- using variables for the mapping

- another column which correlates with the id

- Current Item:ID = 4

but it doesn't work.

Any ideas?

0 Kudos
Reply
eiben
Nintex Newbie

Re: “Nintex O365 update item permission” action not working with multi-value people picker

Jump to solution

You mean like this:

Works like a charm.

Reply