Unanswered

how to improve performance inside flow

(1) Share

Report

Posted on by Veblitz

2,249

Below is the complete details of flow,so please suggest how to improve performances as i have received some alert that to enhance performance in this flow.

Details inside apply to each

Categories:

Using flows

I have the same question (0)

All responses (5)

Answers (0)

Michael E. Gernaey 53,442 Super User 2025 Season 2 on at

Like (1)

Report

Hi,

Without a detailed explanation of what you need done (not what the flow does), but the business process you have implemented, it not easy to make suggestions as we might break your functionality requirement..

Please share a detailed step by step business process, where the data comes from etc and happy to help. I am going to guess we can get rid of some of your Apply to eaches or at least enhance the flow if we have that information

Was this reply helpful? Yes No
Veblitz 2,249 on at

Like (0)

Report

Hello,

Here is the detailed requirement

when a new email arrives in the shared email box ,we need to extract the metadata properties such as From, To ,CC, Body, subject and parse in sharepoint list .Then we need to extract email attachment and store that in sharepoint document library with predefined folder path (Year\month/country/customer details),for creating a folder structure we are using year and month expression in the flow and for country we are hardcoding user account details country property and customer details we are checking email from address contains in customer list email address then customer list company name for that email address is fetched so this is how folder structure is created and email attachment is stored. So if the incoming email From address does not contain in the customer details email address then email is exported and stored in the temporary document library.

Master List: Extract email metadata properties

Subject (single line of text) From(single line of Text) To(Multi line of Text) cc(multi line of Text) Body (Multi line of Text)

Document Library: Store email attachments in predefined folder structure dynamically

Name From To CC

Customer List:

CustomerName(single line of Text) emailaddress(multi line of Text)

Was this reply helpful? Yes No
abc 123 784 Moderator on at

Like (1)

Report

The first problem is the existential argument of Folders vs. MetaData & Views. Did you choose folders for easy assignment of SharePoint permissions?

From there, there's nothing slower than i/o hits, except for the Apply to Each, and you have many of them, unfortunately.

Have you considered the option to have the attachment load automatically from the email address, like this:

Populating a SharePoint Document Library by E-Mail, Part 2 -- Redmondmag.com

Was this reply helpful? Yes No
Veblitz 2,249 on at

Like (0)

Report

I have used template when new email arrives in shared inbox but the folder path we have specified like this since its not default path document library so as per our requirement we need to extract email attachments and put them in this fashion ex: year/month/country/customername

year and month expression-email date year

Country-Recipients To address user profile country property

Customername: email from address contains in customer list customer email address then store customer name in variable for path

we have so many apply to each since we are building custom path based on above things

I would appreciate if you could still help in fine tuning if there is something to be improvised

Was this reply helpful? Yes No
Veblitz 2,249 on at

Like (0)

Report

Additionally,my above flow is getting failed with below error message,let me know if you have any idea

As of May 6, 2020, shared mailbox support was added for certain operations with an optional 'Mailbox address' parameter, allowing you to specify a shared mailbox address for your operation to access. If you were using this operation prior to May 6, 2020, you will need to explicitly update your operations to specify the shared mailbox address. Please follow the Office 365 documentation for more information:

Was this reply helpful? Yes No