Unanswered

Bulk Email based on Condition

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi All,

As i have started working with flows i have known that we can schedule a bulk email for items in sharePoint List which was not possible in SharePoint Designer.
But now i have a requirement which i think i am struggling with in flows too, cant seem to wrap my head around as to how to build this flow.
Requirement: So what i would want is to Create a Flow which would Send out bulk email.
Now, I haave a column named XYZ which contains a number and for this Column there can be multiple Parts.
For Example: XYZ112 has 10 parts so it will have 10 line items in shaerpoint list with same XYZ112 value in XYZ column.
Now what the user wants is to send a bulk email when all the 10 line items have a value of Yes in Column Business action.
So if business action is yes then only it will send email but i would want to send email for all the 10 parts and not one single part.
Idk if this makes sense but i guess i have made most of my requirements clear!!
Please do tell me if you need to know something else too.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

Please see the screenshot below:

Here I am using ODATA query filter to get the records based on the condition and using the apply to each loop to send the email. This will send email for all aterations recieved in the get items list satisfying the filter.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@yashag2255 i have used this method previously to solve my previous issues but my MCO Number will be dynamic always and will not have a fixed number of parts so i cannot put a filter in a query for static MCO/MCN Number.
So how do i filter out the dynamic MCO along with their part numbers and then send an email.
The problem is 1 MCO maybe have x number of parts so once all the parts have the flag as yes it needs to send an email.
@yashag2255 wrote:
Hi @Anonymous

Please see the screenshot below:

Here I am using ODATA query filter to get the records based on the condition and using the apply to each loop to send the email. This will send email for all aterations recieved in the get items list satisfying the filter.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

Okay so what you can do is, have an array that has all the MCO. create an apply to each on this MCO and then put the rest of the flow into this apply to each. In the odata filter, MCO eq currentitem and BusinessAction eq 1. This should get you all the items with the same MCO and send emails across.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@yashag2255 but then again how does the flow know that it has to send email once the flag changes to yes for only 10 parts for that MCO.
and also can you put screenshots if possible as i am really confused about it.
Would really appreciate it
@yashag2255 wrote:
Hi @Anonymous

Okay so what you can do is, have an array that has all the MCO. create an apply to each on this MCO and then put the rest of the flow into this apply to each. In the odata filter, MCO eq currentitem and BusinessAction eq 1. This should get you all the items with the same MCO and send emails across.

Was this reply helpful? Yes No