cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
AKB_2K19
Level: Powered On

Get row to select multiple excel rows at one time

Hello,

 

I am building approval workflow to connect Flow to Excel located in SharePoint. I have created 2 tables "Proposed Changes" and "Approved Changes" in that excel file. 

 

Initially changes are added to Proposed Changes table and after manager's approval flow moves the row to "Approved Changes" table and deletes the row from "Proposed Changes" table.

 

In the "Proposed Changes" table, I have created a column "Send for Approval" and it is being updated with "Yes" for each change that requires approval from manager. This "Send for approval" - Yes is triggering point for flow. Currently I have 3 row items in "Proposed Changes" table marked with "Send for approval" as Yes. But the flow is only picking up the first one and waiting till it is approved and moved to "Approved Changes" table

 

How can I send 3 separate approval emails for the 3 changes marked in Excel sheet?

 

 image.png

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Get row to select multiple excel rows at one time

Hi @AKB_2K19,

 

I am going to share more details on the flow configuration.

Before creating the flow, I have created an Excel table which contains Title, ApproverName for the approvers email address, and Status for Yes/No.

2.PNG

Then I configured the flow to list rows present in a table first, then filter out items that status is marked as “Yes”.

Under the action Filter array, add an Apply to each, select dynamic content Body from action Filter array. Add the action Start an approval within the Apply to each, enter the following codes for Title and Assigned to field separately:

Title:

 item()?['Title']

Assigned to:

 item()?['ApproverName']

Besides, click the ellipsis of Apply to each, go to Settings to turn on Concurrency control and set the Degree of parallelism to 50.

1.PNG

Please take a try with it on your side.

 

Best regards,

Mabel

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
Community Support Team
Community Support Team

Re: Get row to select multiple excel rows at one time

Hi @AKB_2K19,

 

I assume that the Concurrency Control would work for you. Enable Concurrency Control can ensure that all of the approvers receive their request at the same time.

Please check this doc on Parallel approvals:

https://flow.microsoft.com/en-us/blog/advanced-flow-of-the-week-send-parallel-approval-requests-to-a...

Click the ellipsis of Apply to each, then click Settings, then turn on Concurrency Control and set its degree of parallelism to 50.

I have made the following test for your scenario, all the approval requests would be sent out at the same time without waiting till the first approver gave a response.

1.PNG

Please feel free post back if you need more help.

 

Best regards,

Mabel

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
AKB_2K19
Level: Powered On

Re: Get row to select multiple excel rows at one time

Hello @v-yamao-msft , thanks for looking into this and your response/link. I am very new to FLOW and your answer gives me hope that there is a way out!

 

My flow is something like

  1. Excel sheet has propose change list and approved change list tables. Every day FLOW checks the excel sheet in Proposed change list table and selects all rows which have "Send for Approval" value marked as "Yes".
  2. There is a approver name column, who has to approve that particular change for their department.
  3. FLOW will trigger an individual email to each approver including details mentioned in Brief description, category, department to corresponding Approver.
  4. Approver name could be repeated in different rows for each change request mentioned in Proposed table.
  5. After approval, flow will capture the approver name, response, date and time along with their comments against corresponding change request row item.

When I used the filter Array, it is successfully filtering the 3 rows for approval based on "Send for Approval" value. So that part works! But when I use start an approval flow I dont see "name" value in the dynamic data list. which has been mentioned in your screenshot. I can just see Current item.

 

I changed Apply to each value to recurrence value of 50 but that even that didnt help.

 

image.png

 

When I added dynamic values from excel table, it is creating nested "Apply to each" for each value I am adding from table columns.

image.png

 

Any help here?

AKB_2K19
Level: Powered On

Re: Get row to select multiple excel rows at one time

Can anyone else help? Basically I want to loop through the rows where "Send for Approval" is marked as "Yes".

 

I created the following flow which successfully picks up 3 rows where previous condition is met, BUT it waits till 1st row item has been approved by an approver before it moves to next row. 

 

image.png

 

As all approvers are different and each row is independent request not related or linked to other rows, waiting for previous request to get approved so that next one is triggered is completely wrong process. Can I somehow trigger all X number of rows matching the "Send for Approval" criteria at one time for approval parallely and track each of them separately?

 

Thanks,

AK

Community Support Team
Community Support Team

Re: Get row to select multiple excel rows at one time

Hi @AKB_2K19,

 

I am going to share more details on the flow configuration.

Before creating the flow, I have created an Excel table which contains Title, ApproverName for the approvers email address, and Status for Yes/No.

2.PNG

Then I configured the flow to list rows present in a table first, then filter out items that status is marked as “Yes”.

Under the action Filter array, add an Apply to each, select dynamic content Body from action Filter array. Add the action Start an approval within the Apply to each, enter the following codes for Title and Assigned to field separately:

Title:

 item()?['Title']

Assigned to:

 item()?['ApproverName']

Besides, click the ellipsis of Apply to each, go to Settings to turn on Concurrency control and set the Degree of parallelism to 50.

1.PNG

Please take a try with it on your side.

 

Best regards,

Mabel

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (6,146)