Forum Discussion
Re: Send Email to Email in List on Specific Date
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?
1 Reply
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.
