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

Community site session details

Session Id : lT9wgaBwjlrJIQ3kwS6ZuR
Power Automate - Building Flows
Answered

Need help building an automatic flow that pulls an email address from contact/calendar to then send out an email

Like (0) ShareShare
ReportReport
Posted on 21 May 2020 21:34:23 by 10

Need some help creating my first flow!

 

I wanted to send out an email once someone booked an appointment in the booking calendar that had specific information and attachments. I see that there are no flows for the booking application so I was trying to create a work around. When somebody books an appointment it then creates a calendar event. I wanted to pull the email address from that event and then send an email to that person with specific info and attachments. Is this even possible or should I wait for them to create flows for the bookings app?

  • v-alzhan-msft Profile Picture
    on 27 May 2020 at 01:26:14
    Re: Need help building an automatic flow that pulls an email address from contact/calendar to then send out an email

    Hi @shafii ,

     

    So why the to field is null?

    You need to troubleshooting it or share the screenshot of run history.

     

    Best regards,

    Alice   

    Community Support Team _ Alice Zhang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • shafii Profile Picture
    10 on 26 May 2020 at 14:39:49
    Re: Need help building an automatic flow that pulls an email address from contact/calendar to then send out an email

    I get the same error message. It says the TO field is empty and cannot be empty. I have done all of the Dynamic content for attendees but nothing seems to work (optional, required, organizer, and resource). It doesn't make sense to me why it is not pulling the information b/c I see it finds the correct email address in the"GET EVENT" step. In the final step it errors b/c for some reason the email from step 2 doesn't get send to the final step. When I manually put an email in the TO field on the lats step it worked as planned. So somewhere between step 2 and 3 I am hitting a snag. 

  • v-alzhan-msft Profile Picture
    on 25 May 2020 at 06:11:22
    Re: Need help building an automatic flow that pulls an email address from contact/calendar to then send out an email

    Hi @shafii ,

     

    What is the value of the OPTIONAL ATTENDEE dynamic content?

    Please save the OPTIONAL ATTENDEE dynamic content in a Compose and run the flow to check the value.

     

    Best regards,

    Alice   

    Community Support Team _ Alice Zhang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • shafii Profile Picture
    10 on 22 May 2020 at 11:15:59
    Re: Need help building an automatic flow that pulls an email address from contact/calendar to then send out an email

    I typed in my email address in the TO field and it worked. For some reason when I try to use the dynamic content from the EVENT, it does not work.

     

    I reviewed the GET EVENT fields and I see the OPTIONAL ATTENDEES data. So the correct email address is getting pulled. However when I use that OPTIONAL ATTENDEE dynamic content for the send email it will not work. Is there something I am missing that connects these two steps?

  • shafii Profile Picture
    10 on 22 May 2020 at 11:03:36
    Re: Need help building an automatic flow that pulls an email address from contact/calendar to then send out an email

    I kjeep getting to the end and it stops. I am not for sure why it says  the field cannot be empty bc I have info in those fields. Thoughts?

     

    SharedScreenshot.jpgSharedScreenshot.jpg

  • Verified answer
    v-alzhan-msft Profile Picture
    on 22 May 2020 at 06:16:46
    Re: Need help building an automatic flow that pulls an email address from contact/calendar to then send out an email

    Hi @shafii ,

     

    The screenshot of the flow should as below(I use mail connector since I don't have outlook connector permission):

    1.png

     

    Best regards,

    Alice   

    Community Support Team _ Alice Zhang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • DeepakS Profile Picture
    2,301 Most Valuable Professional on 21 May 2020 at 22:14:10
    Re: Need help building an automatic flow that pulls an email address from contact/calendar to then send out an email

    Hi @shafii 

     

    yes, you can get attachments if they are getting stored in One drive or SharePoint.

    You should use

    1) "Get Files" Action to get all the files (attachments) and their properties 

    2) "Get File content" Action to get the file content and send it in email

    Following link had the solution on how to send email attachment for your reference.

    https://powerusers.microsoft.com/t5/Building-Flows/Send-email-with-attaching-file-from-SharePoint-library-document/td-p/87682

     

    Regards

     

    Regards,

  • shafii Profile Picture
    10 on 21 May 2020 at 22:04:02
    Re: Need help building an automatic flow that pulls an email address from contact/calendar to then send out an email

    ok I will try that and see if that works for the email address. The attachment I need to send is stored in onedrive/sharepoint. Once the flow pulled the email using V3 coult it then pull that attachment from there to send you think?

     

  • DeepakS Profile Picture
    2,301 Most Valuable Professional on 21 May 2020 at 22:02:14
    Re: Need help building an automatic flow that pulls an email address from contact/calendar to then send out an email

    Hi @shafii 

     

    yes you can do that using "When a new event is created (V3)" trigger, you will get the associated properties for the event. but i am not sure if you get the attachment in invite from APP so that part may not work?

     

    Regards,

  • shafii Profile Picture
    10 on 21 May 2020 at 21:56:28
    Re: Need help building an automatic flow that pulls an email address from contact/calendar to then send out an email

    The booking app sends a calendar invite to outlook and creates a calendar event. Can I pull the email address from that event to then send an email since outlook has connectors?

     

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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2