Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Get individual user info as Apply to each iterates thru SharePoint multiple person column

Posted on by 158

When using an Apply to each on a SharePoint multiple person column, (Approvers) how do you pass individual user info (display name, email, id...) to a variable within as it iterates?

 

applytoeach.PNG

  • v-bacao-msft Profile Picture
    v-bacao-msft on at
    Re: Get individual user info as Apply to each iterates thru SharePoint multiple person column

    Hi @bdc604 ,

     

    It seems that the variable type you set is unable to pass the name, email and id you mentioned. Please try setting the variable type to String.

    Or a variable type that matches the data type of the user info you mentioned.

    Image reference:

    14.PNG

    In addition, you could also consider using Compose to pass these values, like:

    15.PNG

     

    Please take a try.

     

    Best Regards,

  • Brad_Groux Profile Picture
    Brad_Groux 4,560 on at
    Re: Get individual user info as Apply to each iterates thru SharePoint multiple person column

    @bdc604 wrote:
    I appreciate the links but it doesn’t answer my question. SP ootb approval flows are too simplistic and static for our needs. We need to pull participants (approvers, reviewers, informed) from a distribution list with multi person columns.

    Which you can do with the links I provided above. 

  • bdc604 Profile Picture
    bdc604 158 on at
    Re: Get individual user info as Apply to each iterates thru SharePoint multiple person column
    I appreciate the links but it doesn’t answer my question. SP ootb approval flows are too simplistic and static for our needs. We need to pull participants (approvers, reviewers, informed) from a distribution list with multi person columns.
  • Brad_Groux Profile Picture
    Brad_Groux 4,560 on at
    Re: Get individual user info as Apply to each iterates thru SharePoint multiple person column

    What exactly are you trying to accomplish? It looks like you are trying to configure your own approval from scratch rather than use the built-in approvals functionlity? The official Microsoft Flow documentation has demos of pretty much every possible approval type:

    As the documentation above shows, the submitter's data would be contained within a SharePoint list based upon columns that you create for that list. That data can be piped into the Flow via various fields of the approval step(s), like shown here: provide-approval-config-info

     

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

October 2024 Newsletter…

October 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #4 How to Conntact Support…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 142,733

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,750

Leaderboard