web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Grant access to a shar...
Power Automate
Unanswered

Grant access to a sharepoint list item based on multiple person column (Array?)

(0) ShareShare
ReportReport
Posted on by 31

Hi All,

I want to set a flow when I click, I could grant access (from edit to view) to each SharePoint list item base on multiple person column.

Error message:

The execution of template action 'Apply_to_each_2' failed: the result of the evaluation of 'foreach' expression '@items('Apply_to_each')' is of type 'Object'. The result must be a valid array.

I think that because person column is array but I am not sure how to extract only email address from the column.

Can someone help me with this? Thank you!

 

Flow screenshot as below

studyri10_1-1680425110326.png

 

studyri10_2-1680425304137.png

 

 

Categories:
I have the same question (0)
  • Verified answer
    v-zhoqian-msft Profile Picture
    Microsoft Employee on at

    Hi, @studyri10 

     

    Based on your description, I have made a simple test for your reference.

     

    In my test, the name of  multiple person column is “Employee”.

    vzhoqianmsft_0-1680492098302.png

     

     

    This is my flow:

    You could refer to my parameter settings for each apply to each.

     

    vzhoqianmsft_1-1680492098306.png

    Result:

    The flow run successfully.

    vzhoqianmsft_2-1680492098307.png

     

    Best Regards,

    Community Support Team _ habsburg Qian

    If this post helps, then please consider Accept it as the solution to help the other members find it.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 523 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 406 Moderator

#3
abm abm Profile Picture

abm abm 245 Most Valuable Professional

Last 30 days Overall leaderboard