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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Need to collect emails...
Power Automate
Answered

Need to collect emails into a variable to use in Create a Teams Meeting

(0) ShareShare
ReportReport
Posted on by 576

I have a flow that uses a SharePoint list to create items for course registrants. There will be more than one registrant per course. For each course, I need to gather the emails of all registrants and put them in the Required Attendees field of the Create a Teams Meeting control. I'm struggling with which type of variable to use and where I collect or append the emails. Thanks for the help. Below is my flow section for that meeting.

ahhollan_0-1711387172892.png

ahhollan_1-1711387179799.png

 

 

Categories:
  • SudeepGhatakNZ Profile Picture
    14,396 Most Valuable Professional on at

    1. Collect the emails in an array

    2. Create a concatenated list of emails using the join function

    3. Provide the concatenated string in the Teams meeting invite action

     

     

  • ahhollan Profile Picture
    576 on at

    Where do I put the array and join in the flow?

  • Verified answer
    SudeepGhatakNZ Profile Picture
    14,396 Most Valuable Professional on at

    SudeepGhatakNZ_2-1711582049916.png

     

    SudeepGhatakNZ_0-1711581953900.png

     

     

    SudeepGhatakNZ_1-1711582015015.png

     

  • ahhollan Profile Picture
    576 on at

    I get the following error from the Set Variable step. The variable 'varEmails' of type 'Array' cannot be initialized or updated with value of type 'String'. The variable 'varEmails' only supports values of types 'Array'.

  • SudeepGhatakNZ Profile Picture
    14,396 Most Valuable Professional on at

    Is Attendee a multi choice field in your case?

     

  • ahhollan Profile Picture
    576 on at

    No, it is a text field.

  • SudeepGhatakNZ Profile Picture
    14,396 Most Valuable Professional on at

    Let me tweak the flow then

     

  • SudeepGhatakNZ Profile Picture
    14,396 Most Valuable Professional on at

    But you said "There will be more than one registrant per course. ". Can you post a screenshot of your list?

     

  • ahhollan Profile Picture
    576 on at

    my list will look something like this.

    CourseNameEmail
    Intro to Power BIJoe SmithJoe@blahblah.com
    Intro to Power BIJohn DoeDoe@blahblah.com

     

    When Sue Smith registers, I need to add her to the Teams meeting without emailing everyone else. So, I'm using Send an HTTP Request to SharePoint to get the event details, then I need to join all the emails so that I can do another Send an HTTP Request to SharePoint. Based on my research, it should only email the new person. 

     

  • SudeepGhatakNZ Profile Picture
    14,396 Most Valuable Professional on at

    Here you go

    SudeepGhatakNZ_0-1712091268466.png

    SudeepGhatakNZ_2-1712091569113.png

     

     

    SudeepGhatakNZ_1-1712091543814.png

     

    To email new attendee, you can use the Send HTTP request to SharePoint or the GRAPH API

    Add an attendee to an invite without emailing exis... - Power Platform Community (microsoft.com)

     

     

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 321 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 271

#3
Henil Profile Picture

Henil 115

Last 30 days Overall leaderboard