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:
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:
Could someone guide me on how to set this up using Power Automate?
---------------------------------------------------
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
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?