Skip to main content

Notifications

Power Automate - Building Flows
Answered

Need help creating flow for training invites

(0) ShareShare
ReportReport
Posted on by 6

I work in Learning and Development, and I need to create an automated flow that runs every morning. This flow should check an Excel spreadsheet to see which learners are scheduled for sessions that day. The spreadsheet contains the following information for each session:

  • Learner's full name
  • Learner's email address
  • Date scheduled
  • Time scheduled
  • Meeting invite link

We run multiple sessions daily, with different meeting invite links and times. I need the flow to send an email to each learner scheduled for a session on the current day. The email should include the relevant meeting invite link, session time, and any other necessary details I want to include.

Since I have never used Power Automate before, I’m unsure where to start. The flow should:

  • Only email learners who have a session scheduled for the current date.
  • Identify which session the learner is in based on the time and meeting invite link.
  • Send the correct session details to each learner.

Could someone guide me on how to set this up using Power Automate?

  • Verified answer
    365-Assist Profile Picture
    365-Assist 2,305 on at
    Need help creating flow for training invites
    To filter by Today I suggest the following

    ---------------------------------------------------
    Please Accept as Solution if it solves your question. Or just give it a Like if it is helpful as can help others.

    Subscribe: https://www.youtube.com/channel/UCFpvUlpx84FuIPOdInGKMTw

    Regards
    Darren Lutchner - 365 Assist

  • ZM-21010917-0 Profile Picture
    ZM-21010917-0 6 on at
    Need help creating flow for training invites

    Thank you for your response. After creating the flow outlined below, I’ve encountered an issue where, despite having different session dates in the Excel file, all participants are receiving emails, and the session date appears as a numerical value (e.g., "45677").

    Could you please advise on how to resolve this?

  • SudeepGhatakNZ Profile Picture
    SudeepGhatakNZ 14,231 on at
    Need help creating flow for training invites
    Setup your flow to start everyday by using a Scheduled trigger.
     
     
    Select "List rows present in a table", and configure it to connect to your Excel file and specify the table containing session details.
    Within the loop, add the "Send an email".
     
     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

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

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,434

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,722

Leaderboard