Power Automate - Update a Multi-Person-Column 👨‍👩‍👦‍👦 

Your comment made my day @Rachel! Subscribe if you liked it, would help the channel to grow :)

@@Enea I boosted your video our comoany's SharePoint user group that I run and the Power Hours meeting I participate in. And I added a link to our Tips and Tricks page!

Thank you Rachel :)

Awesome! Happy I could help :)

Happy it worked! The select action is needed because the multipeople picker control in SharePoint expects a table. By using select you create a table in a JSON format with key:value pairs. In this case the key is claims and the values are dynamically populated from the array items. Why we use claims is because the control needs some kind of unique identifier to find the user and that is claims. Havent tested it with display name but I imagine it wont work since display name can be similar between multiple employees, claims cannot. Hope this helps

I haven’t tried it with anything else to be honest. But with claims you are safe that it will work :)

Have you tried it filtering the query with a multiple slection question 2 value? It should not work but what is the error? I need to test it out

Thanks! Yes the compose was just to better show the output of the variable and to demonstrate the error. Since we then use the select action, the compose is unnecessary, you are right :)

Thanks! Its a people picker, you see it when I hold my mouse over the name and it pops up the info of the user from Delve (4:22). As for "Question2" I am not sure since I cannot find the list anymore (its been >2 years) but since I am using Option 1, Option 2... it will be 99% a choice column. Hope this helps

Can you explain a bit more? Not sure if I understood it right

@@Enea Thanks for your reply! :) I have 2 SP Lists, main list is a Request and the other Delegation list (approvers log their time away here). I have a flow that triggers when a new item is created or modified (on the main list) sends approval to the approvers (multi-select person column) in the order their names where added. I use Start and Wait for Approval - first to respond. I want to check if the first approver is away using the Delegation list (columns here are delegate to single-person column, start date, end date, crated by). If yes get the assigned backup and update my main list multi-person column. Repeat this step for all the next approvers. Appreciate your help! I’m stuck here. 🙏

@@janicemendoza376 of course you can do that. I am not sure how to help you though, since doing a video about such a (more or less) complicated and very specific use case, wont be much of a use to the majority on my channel…

No worries. It does sound possible just haven’t found the right formula just yet. Thanks for sharing knowledge on your channel!

@@janicemendoza376 I might do a video on a topic that goes on that direction though, not sure when to be honest, a lot going on at the moment. Stay tuned :)

I don’t, but If you give me an example of what exactly you mean, I will record one just for you!

Thanks! Subscribe if you like, it will help me as well :)

Happy to help Fernando, subscribe if you like :)

Thanks! If its optional why would you send null? You can leave it blank

Thank you 😊

Thank you :)

Happy to help! Subscribe if you like :)

Cannot think why not! Try it out and let me know. Happy I could help so far :)

@@Enea Instead of having all the emails in a single column I wanted to create a row in a different list for each person using claims token. It's similar to what you have, just individual rows and instead of update its create item. I'm basically trying to create a policy tracker for each person

Thanks! Subscribe to the channel if you like, more is to come! :)

Thank you! :)

@@Enea Sorry just a quick question if i may. How would you do to send an email to all the selected owners (in your case) in once ? So, let's say that the next step in your flow is to send an email to the 3 guys added in your Owner column for option 1. I guess it's not that straight forward with multiple person values?

@@jsgahylle8341 actually it is, you need to create a variable at the top and o save the recipients. It should be an array. Then after you have the three people like in my flow, you do an append to variable. This will become an apply to each and with each run will append the variable with the email of the user. At the end you should have a variable of type array with the emails separated with a semicolon. Then you can put the variable in the recipient field of your send email action. Hope it makes sense

@@Enea Thanks! I'll try to configure something based on your tips ;-)

Hi, thanks for the feedback. Try entering the user manually in SharePoint and see what the column expects. Them check the failed run of your flow and see what the flow is trying to enter in the column. If its the same then the user really doesn’t exist. If not then try to make your flow enter the user the same way the column does it. Usually is the user email address written in lower case.

Happy to help! Subscribe if you like :)

Thanks Alda! You need to get the file metadata from the library. In a SharePoint List you get the item, in a Library you get the file and its metadata. Pretty much the same, just different actions in Power Automate. Feel free to subscribe and like the video if you liked it, would help the channel a lot :)

@@Enea My subscription is already done! thank you for your help! 😄

I have not tested it with string variable, instead I went directly with an array since thats usually the data format needed for such operations.

You are welcome, subscribe if you want, would help me as well :)

Initialize an array variable and then do an append to string of the emails and separate them with a semicolon. Then put the variable in the recipient field. Should work

At that minute is the creation of the get items (second action in the flow). Is that what you mean?

@@Enea Yes! I realized this is because I'd like this to run off a manual trigger or off "When an Item is modified" not "When Item is created". Do you know if there is a way to do that?

@@MicroStepswithBre I do not understand what you are trying to do unfortunatelly. Reach out to me on LinkedIn or Facebook if you like and I can try to help

Similar to email

In your example, the compose data operation is not needed?