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.

(0) Share

Report

Report

Posted on 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,945 Super User 2025 Season 1 on at

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

Upwork and Microsoft Power Platform Partnership

Welcome to the Power Platform Communities

Check out the New Agent Creator Community

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 566 Super User 2025 Season 1

#2

David_MA 516 Super User 2025 Season 1

#3

stampcoin 492

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans