Power Platform Community Forum Thread Details

Hello,

Super new to automate, but can't seem to get this to work. Basically I just need to send unique voucher codes from an excel sheet to different emails using an email template.

Basically take row 1 of the voucher sheet and the email from row 1 of the email sheet and send an email with that code using a template. Then iterating to the next row and so on.

Please advise, thanks in advance!

Categories:

Building flows

What I would do is to iterate through your first excel sheet with email addresses (using the excel connector). At the end of this loop, create your email template to send to that email address with the voucher code.

Inside the loop I think the easiest thing to do is to query the voucher sheet, select your table inside the excel and get the first row. Create another column in you excel sheet for 'used' voucher codes. When you query the excel sheet, ensure your 'used' column isn't yes/true. Once you send the email, update your excel sheet to update the 'used' column to true. As you loop through your email list, you'll be updating the voucher list marking vouchers as used or not. Your query for new vouchers at each loop should only return 1 unused voucher at a time.