I have an SPO list "XXContacts" that is based on a contacts app so has all of the outlook type fields including email address. FROM Sharepoint list page, I would like to be able to make multiple selections from the list, then either click a button or ? that sends a single email (which varies) to them (like a distribution list) but the list of recipients changes all the time so would need to be selected on the fly.
ex> today I want to sen an email to those that are category 1, tomorrow i want to send to those in arizona only, etc, etc.
I cannot seem to get from a single selectin to multi selection then trigger a flow....
I am ok having the email send from a local outlook but would prefer to use the flow smtp action.
Do you want to select multiple items in the List, and then get the email contained in these items, as the To address of the email, and send the mail?
I am afraid that Flow does not currently support selecting multiple items as triggers in the SP list.
You could post this idea in the Flow Ideas forum, so it might be considered for future releases.
Maybe you could consider classifying contacts, adding the category code column, and then inputting the category code using the button as trigger of Flow.
Use the Get items action to configure the Filter query to filter out the corresponding Items, like: the category code eq ‘input’.
Use an array to store the email address contained in the items and send it as To address of Email.
Take a try.
Thank you for your response, yes, I want our users to select multiple contacts from the "Contact" list then press a button to initiate an email to all of them at once (email address from list, same email contents for all) from the devices email client (typically outlook)....
.... I wonder if I can use a power APP to send the email from a list of selected items in the list??? any thoughts?
I will consider the category field as the trigger.... it may work as a temp solution.
Can you elaborate on the steps I would need to do???
Thank you in advance...
This is a really tricky one but thought of a potential workaround.
You could add a column called 'mail this person with a "Yes/No" type input and then set up a view to just show the "Yes" and use a recurring flow to email anyone that appears in the "Yes" view with it running every x number of minutes?
Not the cleanest way to do it but does work.
Thank you for posting on the Flow Community Forum! Have you had an opportunity to apply @scotth82‘s recommendation to adapt your Flow? If yes, and you find that solution to be satisfactory, please go ahead and click “Accept as Solution” so that this thread will be marked for other users to easily identify!
Thank you for being an active member of the Flow Community!
Flow Community Manager
Fill out a quick form to claim your user group badge now!
We've given our badges an overhaul and also added some brand new ones!
Learn how to build the business apps that you need.
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!