Skip to main content

Notifications

Power Automate - General Discussion
Suggested answer

Cloud Flow execution

(0) ShareShare
ReportReport
Posted on by 30
Scheduled a flow to run every 1min and it will fetch the details from sharepoint list.  sharepoint list has 300 records, i want to send email and get acknowledgement for each record. after sending email we can put delay for 2mins after that need to check the acknowledgement. 
 
Questions 1:
 
1. 2mins delay for each mail then check ack for 300 records, will leads to ore time consuming. How to process these in parallel  and improve the execution time?
2.how to read the acknowledgement from mailbox in the same flow and update it against the record in sharpoint list.
3. if any exception or timeout occurs it should affect another record processing. example, while processing 10th record , if any exception occurs, it should continue to process the 11th and remaining records, finally it should send consolidated email for the failed ones. 
 
Categories:
  • Suggested answer
    SaiRT14 Profile Picture
    SaiRT14 1,931 on at
    Cloud Flow execution
    pls try the following approach: 
    • Use Concurrency Control in your flow: When looping through the SharePoint list items, enable the Parallelism feature in the Apply to Each step. Steps: Select the Apply to Each action. Open its settings. Toggle Concurrency Control and set the degree of parallelism (e.g., 20 to process 20 items simultaneously).
    • Use the Get Emails (V3) action: Filter emails based on subject or sender to locate the acknowledgment. Configure conditions to ensure the email matches the record. Update SharePoint list based on acknowledgment: Use the Update Item action to record the acknowledgment against the corresponding SharePoint record.
    • Add Try-Catch Logic: Surround the critical operations (sending email, checking acknowledgment, updating the record) with Scope actions. Add two scopes: Try Scope: Normal processing. Catch Scope: Triggered on failure to log the error or take necessary fallback actions.

    • Continue on Error: Configure each action (e.g., Send Email, Update Item) to Continue on Error: Click on the action’s settings. Enable Configure Run After and select has failed or is skipped.

    • Consolidate Failed Records: Use an array variable to log failed records. At the end of the flow, send a summary email with failed record details: Use the Append to Array Variable action to add failed records. Use the Send an Email (V2) action to send the consolidated email.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard