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

911 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 8,111 Super User 2025 Season 2 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

Announcing our 2025 Season 2 Super Users!

Quick Links

Leaderboard > Power Automate

#1

Tomac 986 Moderator

#2

stampcoin 699 Super User 2025 Season 2

#3

Riyaz_riz11 577 Super User 2025 Season 2

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans