
Announcements
Hi all,
I am building a power app to send an email every morning to a list of contacts within Snowflake. Here's how I have it set up:
1. have a recurrence set up with an interval of 1 day, starting 3-27-23
next step in workflow
2. I am using check the status and get results (Preview) to get the data from snowflake.
For the instance: <my account identifier>.snowflakecomputing.com
For the statement Handle: SELECT DISTINCT Emails FROM mydatabase.myschema ."mytable"
next step in workflow
3. Apply to each - for the "select an output from previous steps" I placed the dynamic content: "data"
next step in workflow
4. Send an email (V2) - this is where I am having problems - I want to place the "emails" from snowflake in the "To" box for the outlook emails but no dynamic content is showing up for "emails".
Did I do something wrong in the previous steps? how can I get these email addresses from snowflake to the "To" line for sending an email?
thank you!