News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows Optimize flow that usi...

Power Automate - Building Flows

Unanswered

Optimize flow that using many composes and creates item. Takes over 20 hours.

Like (0) Share

Report

Report

Posted on 4 Oct 2023 18:53:05 by wonka1234

909 Super User 2024 Season 1

Hi,

My flow takes over 20 hours to run.

Anyone know how i can optimize this?

my flow -

filtering a column to eliminate N/As.

my compose statements are mainly like this -

Compose Statement -

items('Apply_to_each')?[concat('Start ', '/', ' 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.

Categories:

Business Process Flows

All responses Img

All responses (1)

Answers Img

Answers (0)

lbendlin 7,848 Super User 2025 Season 1 on 04 Oct 2023 at 22:51:46

Like (0)

Report

Re: Optimize flow that using many composes and creates item. Takes over 20 hours.

Instead of listing the rows in the Excel table you could run a SQL query against that table which already produces the required output format for the sharepoint items

Helpful resources

News and Announcements

Welcome to the Power Platform Communities - Lets Get Started!

May 14th | Power Platform Community AMA: Power Apps Edition

Quick Links

Leaderboard > Power Automate - Building Flows

#1

stampcoin 125

#2

David_MA 118 Super User 2025 Season 1

#3

Michael E. Gernaey 110 Super User 2025 Season 1

Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans