Send "Approval request" email to all owners at once if the condition is fulfilled

(2) Share

Report

Posted on by brg1

Hello everyone,

I am building a flow that is running daily and checking the "Date" column of a Dataverse table containing projects, to check if that specific row is older than 6 months. If the condition is true, I want my flow to send an email to the project owner and ask for approval.

However, it might be the case that there are 5 projects have a date that is more than 6 months in the past, in which case, I would like all the owners to receive an email with their project details and the possibility to approve or decline the request.

With my current set-up, the flow will send an email to the owner of the first project in the table, and only sends the email to the owner of the second project, once the first owner approves the request. In my case, the projects are independent and we want all the email to go out at once.

Below you can se my current set up.

What is the best way to go around this? Thank you!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

David_MA 12,982 Super User 2025 Season 2 on at

Like (1)

Report

What you will need to do is to create either a child flow or a flow that you can call from an HTTP request. This way, when your above flow calls the approval flow, each will be its own instance and will not need to wait for the outcome of the prior action to complete before another one can begin. You could also enable concurrency on the Apply to each action, but I ran into issues doing it that way and now prefer to call the flow from an HTTP request.

By doing this, each approval process is isolated, and you avoid the bottleneck of waiting for one approval to complete before starting the next. Note, if you use the child flow approach, you do not want to pass the outcome of the approval back to the initiating flow or you will have the same issue you have now. Instead, you just want to pass some confirmation back to the initiating flow to let it know the flow started so it can move on to the next item.

Was this reply helpful? Yes No
Michael E. Gernaey 53,433 Super User 2025 Season 2 on at

Like (1)

Report

Hi,

Apologies, you were explaining sending Emails, not sending Approval emails so I am confused (lol I always am), are you saying

that you want everyone to be on the same Approval?

Or that you want separate Approvals for Each Email, but that you need it to be Dynamic. Meaning today you send 1 approval email because your flow only pulled back 1, but then tomorrow, you pulled 2 rows, so you want 2 separate Approval Emails? And day 3, 13 rows etc

FYI I do see David answered and just wanted to verify for myself what you were asking :-)

Was this reply helpful? Yes No
brg1 6 on at

Like (0)

Report

Hi Mike an David,

To answer your question, Mike. You are right, I explained sending emails while I should have said sending Approval requests, I guess? I just refered to them as email as these requests are sent on the email of the approval person. I will try to edit in the post.

Regarding your second paragraph, I want a separate approval for each email and I need it to be dynamic. If today only one solution meets the criteria, send that owner an approval request. If tomorrow there are 3 solutions that fall under my true criteria, send an three different approval requests, one for each solution/solution owner.

David, could you tell me more about this HTTP request and maybe guide me towards some resources that could help me build that? I'm not very technical but I think I can get it done if I have the right information.

Thanks both and sorry for the delay in my reply.

Was this reply helpful? Yes No