Skip to main content
Community site session details

Community site session details

Session Id : SSnie+mRP2ldqBRAtkyB0K
Power Automate - Building Flows
Unanswered

Using Forms checkbox output to build mailing list

Like (0) ShareShare
ReportReport
Posted on 12 Feb 2024 03:34:57 by 2

Hi everyone,

 

I might be trying to use the wrong tool for this, so please educate me if so.

 

I'm trying to use a forms checklist to help compile a mailing list. The idea being something like:

 

User selects options:

[] Option 1

[] Option 2

[] Option 3

 

Base mail list consists of addresses a - c.

Selecting Option 1 will add address d to the mail list.

Selecting Option 2 will add addresses e & f to the mail list .

Selecting Option 3 will add address g to the mail list.

 

I've converted the Form checkbox output information into an array, and created a string variable for the base mailing list.

Then I have an "Apply to each" block with nested Condition statements:

Condition 1: 'Current item' = Option 1; No - no action; Yes - Append 'address d' to string

 

Hopefully you get the idea. After the "Apply to each" block it sends an email, using the string as the mailing list.

 

However, when I try to run it it's being super inconsistent. I'm testing it with 3 email addresses, and it's seemingly randomly deciding which ones to email, regardless of which boxes are checked in the form! Can anyone advise of a reliable way to achieve this?Screenshot 2024-02-12 163208.jpg

  • tommyp135 Profile Picture
    2 on 12 Feb 2024 at 07:53:45
    Re: Using Forms checkbox output to build mailing list

    Hi MinashSolanki,

    Thanks for your reply!

    I've used Initialize Variable with json() linking to the answer data tag. The choice field does allow multiple selections, and I have successfully used this method with other applications.

    tommyp135_0-1707724270356.png

     

    Here is one of the conditions. Note that the string for the choice in the form is 'Work'

    tommyp135_1-1707724357114.png

    tommyp135_2-1707724419798.png

     

     

     

  • ManishSolanki Profile Picture
    15,085 Super User 2025 Season 2 on 12 Feb 2024 at 05:24:49
    Re: Using Forms checkbox output to build mailing list

    Hi @tommyp135 

     

    Could you pls share the screenshots for:

    1. How to convert choice value to array?

    2. Conditions action in edit mode

     

    Is choice field allowing multiple selections?

     

     

    If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Loading complete