Forum Discussion
Send Email to Email in List on Specific Date
Hey everyone! I am new to Power Automate and could use some assistance. My goal is to automate an email sent to access card holders two weeks prior to the card expiration. So far, I have a co...
Jon_Lake Thank you for the response, this looks like it will work.
The only thing missing is how do I tell the 'send an email (V2)' action to select the corresponding email to the 'expiry_reminder_date' in the list as the recipient?
The only thing missing is how do I tell the 'send an email (V2)' action to select the corresponding email to the 'expiry_reminder_date' in the list as the recipient?
Hi CXPAirport , your source table/list must contain either an email address or username which allows the drawdown of profile data from Azure AD, which will contain (amongst other things) the user email address. If you're using a people lookup field it's a simple process of using the 'Get user profile' action. If you're relying on a free-text user name field it should match an element of the user profile in Azure AD. Once you have the email address from the 'Get user profile' action you can use the email address returned by it.