web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : 272rIAovYHsvYxdeu205L9
Power Automate - Building Flows
Unanswered

Flow taking over 13 hours to run. Multiple Composes and create item in list

Like (0) ShareShare
ReportReport
Posted on 26 Sep 2023 13:24:39 by 915 Super User 2024 Season 1

Hi,

 

How can I better optimize my flow?13 hours is way to long...

 

First part - 

1. Reoccurrence.

2. Initialize variable of location of an excel on my onedrive

3. Get table from this excel.

wonka1234_0-1695734445360.png

4. Compose columns from this table in my excel file.

 

wonka1234_1-1695734498564.png

 

Compose Statement - 

items('Apply_to_each')?[concat('Start of Period ''/'' Date')]
 
2nd compose -
if(
    empty(outputs('Compose')), 
    null, 
    addDays('1899-12-30', int(outputs('Compose')), 'yyyy-MM-dd')
)

 

This is repeated several times for 6 or 7 date columns. Ie compose 3 and 4 will be for another date column, and so on.

 

5. Create items in list -

 

wonka1234_2-1695734608265.png

 

my excel table has about 50 columns and 2000 rows.

 

any help on making this faster would be appreciated.

 

I have the same question (0)
  • wonka1234 Profile Picture
    915 Super User 2024 Season 1 on 04 Oct 2023 at 16:47:25
    Re: Flow taking over 13 hours to run. Multiple Composes and create item in list

    @creativeopinion  here is my full flow -  there must be a way to optimize this. +13 is way to long.

    wonka1234_5-1696440592919.png

     

    I have this filter array but it literally filters out 1 record lol

    wonka1234_1-1696437894242.png

    then we have the composes... and create item

     

    wonka1234_2-1696437945752.pngwonka1234_3-1696437979645.pngwonka1234_4-1696438008847.png

     

  • creativeopinion Profile Picture
    10,474 Super User 2025 Season 2 on 27 Sep 2023 at 19:04:57
    Re: Flow taking over 13 hours to run. Multiple Composes and create item in list

    @wonka1234 What do you mean the column headers do no show up? Are you referring to them not displaying as dynamic content? That's odd, because I have spaces in some of my column headers and they show up. 

     

    Also, if you are trying to use an expression with your dynamic content—the dynamic content will not appear (see below on how you can use an expression to access the dynamic content).

    creativeopinion_2-1695841191416.png

     

    Get Dynamic Content with an Expression

    You can use an expression to access the values without dynamic content. In your List Rows present in a table action, limit the Top Count to 1 (so it only returns a single row of data).

     

    Add a Compose action to store the value dynamic content.

    creativeopinion_0-1695841073931.png

     

    Run a test. Take a look at the outputs. All dynamic content can be returned with an expression. You will need to know key for the content. The key is the text in red between the double quotes.

     

    creativeopinion_1-1695841146222.png

     

    Use the item() function. Any time you need to access dynamic content, start your expression like this:

    item()?['']

    In between the single quotes, enter the key for the content you'd like to return. 

     

    creativeopinion_3-1695841220977.png

     

    For example, to return the Task Description, the expression would look like this:

    item()?['Task Description']

     

    creativeopinion_4-1695841471431.png

     

     

  • wonka1234 Profile Picture
    915 Super User 2024 Season 1 on 27 Sep 2023 at 17:32:48
    Re: Flow taking over 13 hours to run. Multiple Composes and create item in list

    I cannot filter array as the column headers do  not show up. I tried filtering array like this blog post -  https://flowaltdelete.ca/2020/04/12/excel-filtering-columns-with-space/

     

    my full workflow is same as above - however i did make a change based your tutorial to get rid of the first apply to items .

  • creativeopinion Profile Picture
    10,474 Super User 2025 Season 2 on 27 Sep 2023 at 15:54:40
    Re: Flow taking over 13 hours to run. Multiple Composes and create item in list

    @wonka1234 Can you upload a screenshot of what your flow looks like? Did you add a Filter Array action to your flow?

  • wonka1234 Profile Picture
    915 Super User 2024 Season 1 on 27 Sep 2023 at 13:22:53
    Re: Flow taking over 13 hours to run. Multiple Composes and create item in list

    @creativeopinion  still took over 22 hours to complete. I only have the one apply to each now though. any other ideas as to why?

  • creativeopinion Profile Picture
    10,474 Super User 2025 Season 2 on 26 Sep 2023 at 13:57:24
    Re: Flow taking over 13 hours to run. Multiple Composes and create item in list

    @wonka1234 If you are returning a single table, you do not need the first Apply to Each action. Refer to this section of a YT tutorial on how you can avoid the first apply to each action.

     

    I also you can streamline your flow by using a Filter Array action. To learn more about how to use the Filter Array action, please refer to this recent YT Tutorial I uploaded. Use the Filter Array action to filter out the rows that do not have a Start of Period date so you can compose a date dynamically for those items. 

    Can you provide a bit more insight on the multiple date columns?

     

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Loading complete