Boolean manual trigger to array

[BAEYER]

I want to manually trigger a flow that sends emails. I already have a flow that looks at a sharepoint list, looks at all the available departments and their e-mail addresses, and sends mails when necessary. I want to change this flow so that i can send emails only to departments selected in the manual trigger with a yes/no button.

I think i can get it to work if i can get my "true" boolean items in an array.

For example:

If I trigger the flow and select Dep 1 and Dep 2, i want an array that gives those names as values.

I think it should be possible, but i can't get it to work.

I refer to a different list for the department names and their emails, because they frequently change/add departments and emails. Harding this in the flow resulted in a lot of work to change a few things. I can manually add these departments in the boolean selector in the trigger, as i think this will be the easiest way to do this.

[creativeopinion · Accepted solution]

@BAEYER Have you considered using a multi-text field instead?

In the meantime, you might be interested in this YT Tutorial: How to Send a SINGLE EMAIL ✉️ with multiple SharePoint list items | Build THIS Power Automate Flow

IN THIS VIDEO:

✅ How to send multiple list items in a single email with a Power Automate Flow

✅ How to create a dynamic date range

✅ How to use the Convert Time Zone action

✅ How to use a Filter Query in the Get Items action

✅ How to count number of items in an array

✅ How to use the Select action to extract a users display name and email address

✅ How to create a unique list of email addresses

✅ How to use the Create HTML Table action

✅ How to customize the HTML Table with CSS styles

✅ How to use the Send an email (V2) action

✅ How to use the Append to String Variable action

✅ How to create a custom list of items for an email

✅ How to use the Send an email (V2) action

✅ How to display singular or plural text based on the number of items returned

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response! If you're feeling generous— ☕️  Buy me a coffee: https://www.buymeacoffee.com/acreativeopinion

👉 Watch my tutorials on YouTube
👉 Tips and Tricks on TikTok

[BAEYER]

This is exactly what I needed, thank you!

This option id not available in the new view, but if you switch to the old view you can still select this option.