Condition Flow Help

(2) Share

Report

Posted on by RayGo

I have a sharepoint list which is a matrix grid and I've built a flow which converts all Published values back to Not Priced at the end of the month.

To achieve this, my automation is basically a series of about 20 condition/Sharepoint update flows which check each column with a condition for each value (i.e. if published) and then if yes, updates item based on another variable Not Priced.

The problem is that the flow is very resource-intensive and takes about 20 mins to run because it checks every single entry numerous times.

Is there a way to achieve what I want to do in a more streamlined way? I'm thinking something like get all items, then check these items against a variable Published, if a match then update all items; something that avoids having to run 20 condition flows with an apply to each on every item in the database?

Thanks,

Categories:

Business Process Flows

All responses (2)

Answers (0)

Suggested answer

Coxjen81 2 on at

Like (1)

Report

Condition Flow Help

I like the idea of apply to each. In addition, can you run each condition and update simultaneously - as parallel branches?
Suggested answer

Sayan 789 Super User 2025 Season 1 on at

Like (1)

Report

Condition Flow Help

Hey, you can use a single "Get items" action to retrieve all the items from SharePoint list, then use "Apply to each" action to loop through the items and check their values.

Solution:

Get items from SharePoint List:

Use the "Get items" action to retrieve all items from your SharePoint list.

Initialize a variable (Array):

Use the "Initialize variable" to create an array that will hold the items that need to be updated.

Apply to each item:

Use the "Apply to each" to loop through the items retrieved from the "Get items" action.

Inside the loop, use a condition to check if the value of the column is "Published."

If the condition is true, append the item to the array variable.

Update items in SharePoint List:

After the loop, use another "Apply to each" action to loop through the array variable.

Inside this loop, use the "Update item" action to update the value of the column to "Not Priced."

Please try with the Above solution hope it will work.

I am Preparing the flow. I will share the flow once it is done.

-----------------------------------------------------------------------------------------------------------------------------------------------------

If my suggestion helps you, please gives it a Like and Marks as a Solution. Which motivates to solve more problems.

Thanks,

Sayan Patra

RPA Developer

Community site session details

Condition Flow Help

Helpful resources

News and Announcements

Quick Links

Michael Gernaey – Community Spotlight

Congratulations to the May Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Leaderboard > Power Automate

Featured topics

Product updates

Community site session details

Condition Flow Help

Helpful resources

News and Announcements

Quick Links

Michael Gernaey – Community Spotlight

Congratulations to the May Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Subscribe to this forum!

Select categories

Leaderboard > Power Automate

Featured topics

Product updates